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?

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
Get step-by-step solutions from verified subject matter experts
