Task A: EXCEL SPREADSHEET
Erica wants to evaluate the 2014 and 2015 sales figures. Erica knows enough about Excel to realise it could be a useful tool so she has asked you to create a Microsoft Excel prototype which provides an overview of the revenue and expenses over the two-year period. The data for the spreadsheet is available on the next page as well as a suggested layout with additional hints and information.
Graphs: You are also required to create two (2) graphs.
1. Show, by product, whether there has been a percentage growth or loss in earnings from 2014 to 2015. Graph must look like Graph 1 shown on next page (except amounts). Colors may differ.
2. Show the yearly earnings. Graph must look like Graph 2 shown on next page (except amounts). Colors may differ.
Both of your graphs must be included on your Excel file and copied into your business report
Task B: PROCESS MODEL
Produce one (1) As-Is process model (not hand drawn) using Swim Lane format from the details provided in the Background section (clearly state any assumptions made)
Your Swim Lane Diagram and assumptions must be copied into your business report
Task C: QUESTIONS
Respond to the following questions
(i) What is the role of business process modelling for organisations such as Balogne? What are some benefits to the General Manager, Ms Erica Norris in viewing a Process Model such as your Swim Lane Diagram for Balogne? Include your Swim Lane Diagram (from Task B) as part of your explanation.
(ii) How could using a software tool such as Microsoft Excel support Erica’s business decision making? Refer to the two (2) graphs (from Task A) as part of your explanation.
(iii) How could Balogne use Web 2.0 applications to better collaborate inside and outside the organization? In your explanation include two (2) different types of Web 2.0 applications you would recommend for adoption by Balogne. The first application must address the use of Web 2.0 for internal communication while the second application could be used to communicate with farmers or distributors.
(iv) How could Ms Norris use Decision Support Systems to help support her decision making?
(v) Explain the value chain and how Balogne could use it to improve operations.