Question: To answer the question above, firstly based on the monthly sales data of Year 1 , 2 , 3 , 4 and 5 , you

To answer the question above, firstly based on the monthly sales data of Year 1,2,3,4 and 5, you should forecast the 12 monthly demands of Year 6 from January to December using "moving average", "simple exponential smoothing", "Holts' model", and "Winter's model", respectively. Secondly, you should calculate the forecast-error indicators of bias, TS, MAD, MAPE, and MSE regarding these four models. Thirdly, based on your findings, you should identify the best forecasting methods and provide your justifications.
Two documents should be submitted for this assignment. The first is the Excel file in which the formula, the calculation processes and solutions of the four forecasting methods, and the related forecast-error estimates of bias, TS, MAD, MAPE, and MSE should be given. The second is the word file template as report by answering questions asked in the report template. This word file template will be posted on D2L (Note: Sample of the work in excel and Video recording of the tutorial is posted on D2L)
 To answer the question above, firstly based on the monthly sales

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!