Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

Assessment Task 2: Simulation Activity (Modelling Project)

ASSESSMENT TASK 2:  DESCRIPTION

The aim of this assessment is to apply modelling principles, data analytics 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 2021, 2022 and 2023. The General Manager requests you to develop a decision model to analyse these information and submit a 1000 word summary report on the findings of your analysis and recommendation for the proposed Maroochydore store.

The business problem

Omega Pty Ltd, an Australian company selling whitegoods and consumer electronics including Washing Machines, Fridges, Computers and Tablets, Microwaves, TVs, Mobile Phones, Games and Consoles. Sales staff have been trained to sell all items.

Omega has sales outlets in Brisbane, Gold Coast, Townsville, and Cairns and is considering opening a new store at Maroochydore. The sales volumes and costs from this new store are expected to be similar to the Gold Coast, but there is an establishment cost of $1million. The establishment cost are cost of setting up the new store (buying the building and renovation).

Mr Andy William, the financial analysis of Omega Pty Ltd, has worked up several options to financial the $1 million establishment cost.

Andy has recommended Option 1 as the best option in financing the new store establishment cost. The annual loan amount of $244,627 will be used in simulating the income statement Maroochydore store.

(For detail analysis of the financing options - see Module 8: Topic 3)

The General Manager is uncertain what staffing levels should be set for this new Maroochydore outlet, and requests you to provide several staffing level options on the feasibility of the Maroochydore store.

You are the business analyst of Omega Pty Ltd and have been given information regarding the business activities for the Year 2021, 2022 and 2023. The General Manager requests you to develop a decision model to analyse these information.

The general manager specifically asks you to develop a decision model using Excel and develop some useful KEY PERFORMANCE INDICATOR DASHBOARD (KPIs) for analysis. The general manager also requests you to submit a 1000 words summary report to:

1. highlight the major findings of your analysis, and

2. recommend feasibility options of the proposed Maroochydore  store.

The summary report will be use to brief the executive management meeting next month.

Instructions

In helping you to prepare the summary 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 for analysis and to build useful performance dashboard.

You are required to apply modelling principles, spreadsheet engineering technique and modelling skills to complete the template and develop an analytic decision model.

You are provided with series of videos in the learning activities to guide you to complete the template.

Part 2: Summary Report & Communication (25%)

Structure your summary report using headers. Focus the report on the findings of your analysis. Recommendation for Maroochydore store must be supported by your findings and analysis.

A sample report structure is provided for your reference.

Summary Report Sample

1. Profitability Analysis

Over the last three years, the outlets had contributed an accumulated total of A$xxxxxx profit to Omega Pty Ltd. Brisbane outlet has been the major profit contributor for the past 3 years. Cairns outlet has outperformed Brisbane in 201X. Brisbane, Townsville and Cairns outlets show positive growth trends but Gold Coast has demonstrated poor performance with a negative growth trend. For product profitability, Hi-Fi Systems are most profitable follow by TVs and Fridges. (Your reference: worksheet)

2. Financial Performance Analysis

3. Sales Performance Analysis

4. Feasibility of Maroochydore store

Submission

1. Log on to you subject site on LearnJCU and select the assessment tab

2. Select the link to the assessment task 2 dropbox and upload your (1) decision model and (2) summary report.

Note:

(1) Rename the template to include your name before submission (yourname.xlsx)

(2) Include a cover page for the summary report. The cover page must have your name and student number.

ASSESSMENT ITEM 2: SIMULATION ACTIVITY Aligned professional standards/ competencies: https://www.cpaaustralia.com.au/academics/accreditation-guidelines-for-higher-education-programs/professional-accreditation-guidelines/section-3-professional-skills-competency-areas-and-learning-outcomes Group or individual: Individual (Please do NOT confuse the reference to Groups in the data provided which is set up to provide variation in variable cost data for each individual student. See the attached document 'BX2016 Student List Individual Group number for Assessment 2' below which will identify which of the 60 variations of data has been assigned to each student).