Assignment SpecificationsThe primary aim of this assessment is to understandthe effect and impact that business processes,complimentary technologies and information systemshave on an organisation. This means that you need todiscuss how the organisation within the case study willuse your proposed solutions to gain an additionaladvantage over its competitors. There is anexpectation that your submission will be analytical,and will draw on theory to frame responses to tasks.Overview: (read the case study) The general manager of UMC would like to have a clearer understanding before thesechanges are implemented so he has asked you to submit a business report (with academic references) with thefollowing 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)– Develop a prototype mobile application with 4-8 mock-up designs (refer Task C)– Answering a series of general questions regarding the business and its journey towards a more technologicalbusiness environment. (refer Task D)Task A: EXCEL for Business IntelligenceUMC wants to evaluate the sales statistics for the past year and the current year to predict future sales. The generalmanager knows enough about Excel to realise it could be a useful tool so he has asked you to create a Microsoft Excelprototype which lists the milk product types with the client ordering details and the revenues collected. The partlycompleted spreadsheet from a random average week (week 32) is available as a separate attachment. Sales data iscollected on a 52 week cycle.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 RawData” table complete the “Supplier Price per unit” and “Retail Sale price per unit” columns.2. In the “Milk Products” table complete the “Supplier Price per unit” column.3. In the “Customer Order (week32) review” table complete the “Total Orders 2017 (W32)”.4. Complete the milk production tableThe formulas required to reveal the missing data include Vlookup, Countif and Sum. Absolute addressing is alsorequired.Essential ResourcesPlease make sure that you download the following filesfrom the unit website.Required files:• UMC_case_study.pdf (case study)• UMC_W32_data_2018.xlsx• Process model.pptxSwinburne UniversityINF10003 – Assignment 3 Outline Group© Swinburne University 2018Spreadsheet Graphs: You are also required to create two (2) graphs.1. Column chart: Show total orders by customers for all 3 years (2015-2018).2. Column or Pie chart: By using the milk production data, create a chart showing illustrating these figures.3. Create a Column or Pie chart: Your choice. This chart can reflect an element from any of the data tables thatyou feel will add value to the user.All graphs must be dynamic to show visible changes instantly when the data is altered.Task B: BUSINESS PROCESS MODELSProduce one (1) process model (not hand drawn) using Swim Lane format from the details provided in the case study:1. The first Swim Lane diagram ‘As-Is’ is provided. Use this model and the provided template to assist you indeveloping a second Swim Lane diagram that represents the proposed ‘To-Be’ application processes at UMC.(Partly completed template will be provided)
