Question: ( 2 6 pts ) Refer to the data set in the Q 2 spreadsheet, which shows monthly demand for the ABC corporation. a )

(26 pts) Refer to the data set in the Q2 spreadsheet, which shows monthly demand for the ABC corporation. a) Forecast the monthly demand for Year 6 using the trend projection only. Report your forecast. (2 pts) What are the values of MAD, MAPE, MSE, and TS?(4 pts) b) Forecast the monthly demand for Year 6 using the trend & seasonality adjustment. Report your forecast. (8 pts) What are the seasonal factors for each month? (4 pts) What are the values of MAD, MAPE, MSE, and TS?(4 pts) c) Based on your analysis, should you consider the seasonality in the forecast? Why or why not? (4 pts)\table[[Sales,Year 1,Year 2,Year 3,Year 4,Year 5]]
 (26 pts) Refer to the data set in the Q2 spreadsheet,

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 General Management Questions!