Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Year Quarter Sales (units) 2020 Q1 1800 Q2 2100 Q3 1400 Q4 2500 2021 Q1 1300 Q2 1500 Q3 1200 Q4 2000 2022 Q1 1600

Year Quarter Sales (units) 2020 Q1 1800 Q2 2100 Q3 1400 Q4 2500 2021 Q1 1300 Q2 1500 Q3 1200 Q4 2000 2022 Q1 1600 Q2 1800 Q3 1100 Q4 2200 2023 Q1 2000 Q2 2300 Q3 1600 4.1. Using the 3QMAM, calculate the gadget's quarterly sales forecasts for the period 2020Q4 to 2024Q1. (4 marks) 4.2. Conduct a simple regression analysis to determine the trend equation of the sales and use it to estimate the number of units of the gadget expected to be sold throughout the fiscal year 2024. Assume that Q1 of 2020 is 1, Q2 of 2020 is 2, etc. Present all details of the calculations. (8 marks) 4.3. Evaluate the relative forecasting accuracies of the 3QMAM and the regression analysis for the period from 2020Q4 to 2023Q4 using the Mean Absolute Percentage Error (MAPE) method. (4 marks) 4.4. Summarise the findings derived from the assessment conducted in 4.3. (4 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles of managerial finance

Authors: Lawrence J Gitman, Chad J Zutter

12th edition

978-0132479547

Students also viewed these Mathematics questions