Aim:
The primary aim of this assessment is to understand the effect and impact that business processes, competing and/or complimentary technologies and information systems have on an organisation. This means that just describing a technology or how the case study organisation may use a technology is an inadequate response to the tasks in this assignment. There is an expectation that your submission will be analytical, and will draw on theory to frame responses to tasks.
Task Requirements
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):
NB: You do not need to use special software for this. Microsoft Word will suffice or you can use Microsoft Visio – you may have access to elms to get if for free: https://elms.ict.swin.edu.au/
Please note: instructions on Visio will not be given as it is your choice to use this software
***** 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 organisation? 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.