Question: can you help me with the below problem? 2. The Sunshine company sells chairs through a chain of stores, has been experiencing issues with production

can you help me with the below problem?

can you help me with the below problem? 2. The Sunshine company

2. The Sunshine company sells chairs through a chain of stores, has been experiencing issues with production (over and under production) due their inability to accurately forecast the sales. As such, the manager of the company hired you to solve this problem. The company provided you with data detailing the monthly sales for the past 9 months. Month Oct Nov Dec Jan Feb Mar Apr May \"mm a) (10 marks) Calculate the monthly sales forecast for October through June using a 4-month moving average (include the formula of this forecasting model). b) (10 marks) Calculate the monthly sales forecast for October through June using a 4-month weighted moving average. Weights to be used: 0.20, 0.50, 0.05, and 0.25 (include the formula of this forecasting model). c) (10 marks) Calculate the mean squared error (MSE) for October through June (only one MSE) for each of the forecasting models previously used. Which forecasting model would you adopt to forecast sales for next month (July)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!