The purpose of this assessment task is for you to demonstrate your understanding of the impact that business processes, competing and/or complementary technologies and information systems have on an organisation. You will create a business report and spreadsheet for a fictitious company Combined Milk Products Pty Ltd. This assessment task will be the first report of two that you will complete throughout this unit. Assessment details The report and spreadsheet will be based on this case study: Business report and structure In order to understand CMP better and to improve processes, Michael has asked you to submit a business report with the following information:  An executive summary [not included in word count].  A table of contents [not included in word count].  Introduction. Combined Milk Products Pty Ltd (CMP) Combined Milk Products Pty. Ltd. (CMP) was founded in 1963 in Cranbourne, Victoria by Peter Frost, a former East Gippsland farmer. From humble beginnings as a milk processor for the local dairy farmers, the company has grown into a multi-million dollar mixed-product firm with a strong penetration in the Australian market, and a developing export business. Not only is a large range of milk produced now (whole milk, reduced fat, skinny, flavoured etc.), but also butter, cheese, yoghurt, and dried milk. Every morning, a fleet of spotless stainless steel CMP tankers leaves the factory to collect the whole milk from selected farms in the area. When the tankers return, the thousands of litres of milk is pasteurised and homogenised, after which the milk is either packaged or undergoes further processing to become skinny milk, butter, cheese, etc. A second fleet of refrigerated trucks then delivers the product to major distributors around Australia. The factory office workers keep details on farmers, product manufacture, and distributors. The sales team keep records of sales data (refer section on Sales Data). Recently a new general manager, Michael Johnson, took over the reins from Peter Frost who retired. 2 INF10003 Introduction to Business Information Systems  Body of report must include: o Part A: responses to questions with in-text references. o Part B: a process model that represents the main processes at CMP, including assumptions. o Part C: two graphs created in Microsoft Excel that show the last two year's net profits, with short descriptions for each.  Conclusions.  Reference list, using Swinburne Harvard style [not included in word count].  Appendix (if needed) [not included in word count]. It is not enough to only describe a technology or how the case study organisation may use a technology. Your submission must be analytical, and draw on theory to frame responses. Each of the following sections should be integrated into the body of your business report. Part A: Questions Respond to the following questions 1. What are some benefits for using a process model to portray current systems at CMP? 2. How does using a software tool such as Microsoft Excel support business intelligence? 3. How can CMP use Web 2.0 applications for collaborating? In your explanation include two Web 2.0 tools you would recommend being adopted by CMP? Responses should include a minimum of three in-text references (6 or more for HD) from credible sources (e.g. books, journal papers, conference papers). Part B: Process model Produce one process model (not hand drawn) using Swim Lane format from the details provided in the case study (clearly state any assumptions made): You do not need to use special software for this. Microsoft Word will suffice or you can use Lucid Chart (https://www.lucidchart.com). The tool is unimportant, use the one that is easiest for you. Part C: Graphs and spreadsheet Michael needs to evaluate the net profit experienced at CMP over the past two years. You must create a Microsoft Excel prototype which calculates the net profits for 2012 and 2013 from the Sales Data (see inf10003-ass-1-sales-data attachment). Your Excel spreadsheet must demonstrate proficiency in using SUM and VLOOKUP formulas. The spreadsheet must look professional in layout and include appropriate headings. It should be designed so that a non-technical user can understand it easily without needing verbal explanations.