Simulation Activity (Modelling Project)

 DESCRIPTION The aim of this assessment is to apply modelling principles, spreadsheet engineering technique and modelling skills to develop a decision model for a given business scenario using the information provided. You are the business analyst of Omega Pty Ltd and have been given information regarding the business activities for the Year 2017, 2018 and 2019. The General Manager have request you to develop a decision model to analyst these information and submit a 1500 word summary report on the findings of your analysis and recommendation for the proposed Maroochydore outlet. The summary report must discuss and address the queries of the following stakeholders: 1. General Manager: Relevant exception trend reports & graphs, & overall profitability by location & product 2. Finance Manager: Financial performance including ability to forecast next year financial performance for various sales forecasts (eg 10% decrease, 10% & 20% increase) 3. Purchasing/Inventory Manager: Inventory turnover performance. 4. Marketing/Sales Manager: Sales performance compared to plan & trends. 5. Staff/Administration Manager: Staff allocation and performance. 6. Management: Recommendation for Maroochydore outlet. Instructions In helping you to prepare the business report, you MUST do the following to provide evidence to support your discussion and recommendation. Part 1: Decision Model (75%) You will be provided with a decision modelling template. The template contains many worksheets that has been designed to assist you to build the decision model to address the queries of the stakeholders mentioned above. You are also provided with series of videos to guide you to complete the template. You are required to apply modelling principles, spreadsheet engineering technique and modelling skills to complete the template and develop an analytic decision model. Part 2: Summary Report & Communication (25%) Structure your summary report by addressing the queries. Focus the report on findings of your analysis. Recommendation for Maroochydore outlet must be supported by your findings and analysis. A sample report structure is provided for your reference. Project Deliverables In this simulation activity, students are to demonstrate their ability to apply modelling principles, spreadsheet engineering technique and modelling skills to develop a decision model using Microsoft Excel for a given business scenario using the information provided. Appropriate “what if” analysis (goal seek, data table and scenarios), multi-dimensional pivot tables, and appropriate chars and graph are to be used to present and analyse the information provided. Together with the decision model, students must also submit a summary report (word limit: 1500 words not including appendices) of their findings and recommendations. Note: Students should keep a back-up copy of their decision model.