| University | Singapore Management University (SMU) |
| 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.
Buy Custom Answer of This Assessment & Raise Your Grades
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.
If you are unable to complete your data analytics and business modelling assignments, you can seek the help of our homework help experts. They are available round the clock to offer you data analytics assignment help services. Our assignment experts can provide accurate solutions to all problems.
Looking for Plagiarism free Answers for your college/ university Assignments.
- ECE210 Advocacy and Collaborations with Families Assignment: Supporting Young Children Through Grief and Family-Centered Partnerships
- ACC707 Accounting and Finance Assignment: Evaluating Investment Decisions, Budgeting Strategies, and Financial Performance Analysis
- NCO201 Learn to Learn, Learn for Life TMA-01: Developing Self-Directed Learning Through the Journey of Mastering Public Speaking
- PSS219 Public Safety and Security in Singapore Group-Based Assignment: Strengthening National Resilience Through Policy Responses from the 2025 Committee of Supply Debate
- MTH240 Engineering Mathematics I Assignment: Heat Transfer, Chemical Balancing, Circuit Analysis, Signal Processing, and Matrix Theory
- Engaging Youth with IBM Skills Build Assignment: Designing Innovative Strategies for Skill Development and Career Growth
- BUS368 Innovation Management and Digital Transformation Assignment: Managing Innovation in Foldable, Trifold, and Stretchable Display Technologies
- BUS366 Assignment: Process Improvement and Recruitment Optimization Using Lean Six Sigma Methodology
- HBC203 Statistics and Data Analysis for the Social and Behavioural Sciences TMA-01: A Comparative Analysis of Workplace Wellbeing Interventions and Their Impact on Employee Productivity
- BCAF003 Business Accounting Assignment: A Comprehensive Study on Bank Reconciliation, Cash Controls, Inventory Valuation, and Financial Analysis