Task A: QUESTIONS Respond to the following questions (i) What are some benefits to the General Manager, Ms Franka Spencer in viewing a Process Model such as your Swim Lane Diagram for Zucchero? Include your Swim Lane Diagram (from Task B) as part of your explanation. (ii) Broadly explain the importance of information in organisations like Zucchero and provide an example of how Information Technology can be a useful tool for attracting new customers and gathering information. (iii) How can using a software tool such as Microsoft Excel support Franka’s business decision making? Include the two (2) graphs (from Task C) as part of your explanation. NOTE: Minimum of three (3) in–text references required from credible sources (i.e., books, journal papers, conference papers). ***** Your responses form part of 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: EXCEL SPREADSHEET Franka wants to evaluate the 2013 and 2014 sales figures. Franka 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. Column chart: Show the yearly net profit (example on next page). 2. Column chart: Show, by product, whether there has been a profit or
