| Subject | Data Analytics and Business Modelling |
Learning Outcomes:
SLO 1: demonstrate the principles of modelling in business decision making processes;
SLO 2: apply spreadsheet modelling skills in building decision models;
SLO 3: employ decision models to examine, analyze, and solve business decision problems.
ASSESSMENT TASK 2: DESCRIPTION
The aim of this assessment is to apply modelling principles, spreadsheet engineering techniques, and modelling skills to develop a decision model and summary report for a given business scenario.
Instructions:
- Read the business scenario below
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 has requested you to develop a decision model to analyze the yearly business activity information and submit a 1500 word summary report on the findings of your analysis and recommendation for the proposed Maroochydore outlet.
- Access the Decision modelling template and apply modelling principles, spreadsheet engineering techniques, and modelling skills to complete PART 1 of this assessment task
Use the template and associated worksheets to build the decision model and address the queries of the stakeholders mentioned below. You are also provided with a series of videos to guide you in completing the template.
The stakeholders are:
- General Manager: Relevant exception trend reports & graphs, & overall profitability by location & product
- Finance Manager: Financial performance including the ability to forecast next year financial performance for various sales forecasts (e.g. 10% decrease, 10% & 20% increase)
- Purchasing/Inventory Manager: Inventory turnover performance.
- Marketing/Sales Manager: Sales performance compared to plan & trends.
- Staff/Administration Manager: Staff allocation and performance.
- Management: Recommendation for Maroochydore outlet.