Developing a Decision Model for Omega Pty Ltd: Business Scenario Analysis and Recommendation

The business problem

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 2018, 2019 and 2020. 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.

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).

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 businessactivities for the . 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 (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.

In helping you to prepare the summary report, you MUST do the following to provide evidence to supportyour discussion and recommendation.

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.

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.

1. Profitability Analysis

Over the last three years, the outlets had contributed an accumulated total of 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 Coasthasdemonstrated poor performance with a negative growth trend. For product profitability, HiFi Systems are most profitable follow by TVs and Fridges.

2. Financial Performance Analysis
3. Sales Performance Analysis
4. Feasibility of Maroochydore store