SWIN BUR · NE * SWINBURNE UNIVERSITY OF TECHNOLOGY INF10003 - Assessment 3 Outline Word count = 1800-2000 words Assignment 3 submission details Swinburne University Individual Weighting: 40% Due date: See Unit Schedule . All pages should include your name and student number in the document footer . All references should be appropriately cited using the Harvard style · Submit your assignment as file format: Microsoft Word document and macro enabled Excel document . Save your files as follows: [student number_A3.filetype] 1234567_A3.doc · Submit your assignment (report and spreadsheet) via the Canvas link > Assignments > Assessment 3 Assignment Specifications The primary aim of this assessment is to understand the effect and impact that business processes, complimentary technologies and information systems have on an organisation. This means that you need to discuss how the organisation within the case study will use your proposed solutions to gain an additional advantage over its competitors. There is an expectation that your submission will be analytical, and will draw on theory to frame responses to tasks. Essential Resources Please make sure that you download the following files from the unit website. Required files: • GDF_case_study.pdf (case study) · GDF_W10_data_2020.xlsx • GDF_Process_Model.pptx · GDF Process Model_To-Be_Template Overview: (read the case study) The general manager of GDF would like to have a clearer understanding before these changes are implemented so he has asked you to submit a business report (with academic references) with the following information: - Complete the spreadsheet with the appropriate formulas (refer Task A) - Within the spreadsheet, create three (3) graphs (refer Task A) - Complete one (1) process models depicting the proposed 'To-Be' processes (refer Task B) - Answering a series of general questions regarding the business and its journey towards a more technological business environment. (refer Task C) Task A: EXCEL for Business Intelligence GDF wants to evaluate the sales statistics for the past year and the current year to predict future sales. The general manager knows enough about Excel to realise it could be a useful tool so he has asked you to create a Microsoft Excel prototype which lists the milk product types with the client ordering details and the revenues collected. The partly completed spreadsheet from a random average week (week 10) is available as a separate attachment. Sales data is collected on a 52 week cycle. PLEASE NOTE: Do not adjust any data already provided by the client. Spreadsheet Requirements: Complete the spreadsheet by using the correct formulas to fill in the missing data. 1. In the "Ordering Raw Data" table complete the "Equiv Litre per Crate/Carton" column in the "Ordering Raw Data" table complete the "Supplier Price per unit" and "Retail Sale price per unit" columns. 2. Complete the projected Customer Order Review for 2021 based on the percentage increase provided. 3. In the "Milk Products" table complete the "Supplier Price per unit" column. 4. In the "Customer Order (week2) review" table complete the "Total Orders 2020 (W10)". 5. Complete the missing macro functions and