Feel free to add as many columns as needed to do your work. Make sure to show your work (meaning all computations required for forecasting and errors for all weeks and all 4 methods, as well as MAPE for each method).You need to show all the forecasting computations, and all individual error computations for all methods. Important note: The excel sheet computations need to be obtained using formula and NOT entered as values. Any work submitted as pasted values will not count
Instructions:
Using the provided data, compute the following 4 tasks:
1- Compute forecasting for that data using 4 methods:
a- Simple moving average with n= 2
b- Weighted moving average with n=4 and weights of 8, 6, 4, and 2
c- Exponential smoothing with alpha= 0.1 (assuming initial forecast of 52)
d- Exponential Smoothing with alpha=0.8 (assuming initial forecast of 52)
2- For each of the four forecasting methods produced, compute the corresponding error for each week, and then compute the overall MAPE for each method (do this task on third Tab:Data)
3- Which of the four forecasting methods can you say best fit the data? Please provide your rationale for your choice (type your answer on the Exercise Question Tab)
MAKE SURE AGAIN TO SHOW YOUR WORK AND TO HAVE ALL COMPUTATIONS PERFORMED USING FORMULA AND NOT JUST PASTED STATIC NUMBERS
DataPeriodDemand (calls)Week 150Week 235Week 325Week 440Week 545Week 635Week 720Week 830Week 935Week 1020Week 1115Week 1240Week 1355Week 1435Week 1525Week 1655Week 1755Week 1840Week 1935Week 2060Week 2175Week 2250Week 2340Week 2465
The post Excel sheet computations appeared first on PapersSpot.
Comments