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 and you should forecast the monthly demands of Year from January to December using "moving average", "simple exponential smoothing", "Holts' model", and "Winter's model", respectively. Secondly, you should calculate the forecasterror 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 forecasterror 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 DL Note: Sample of the work in excel and Video recording of the tutorial is posted on DL
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
