Question: Week Demand Moving Average abs err % err 1 2750 2 3100 3 3250 4 3300 5 2900 6 3050 7 3300 8 3100 9
Week Demand Moving Average abs err % err 1 2750 2 3100 3 3250 4 3300 5 2900 6 3050 7 3300 8 3100 9 2950 10 3000 11 3200 12 3220 13 Week Demand Exponential abs % err 1 2750 2 3100 3 3250 4 3300 5 2900 6 3050 7 3300 8 3100 9 2950 10 3000 11 3200 12 3220
a) Compute a moving average that uses the past two actual demand values to predict the next week b) Show the Demand and the Forecast on the same graph c) Compute the MAPE for this forecast I d) Comlute an Exponentially Smoothed forecast in the second part, using that alpha value in G5 e) Show the Demand and the Forecast on the same graph f) Compute the MAPE for this forecast g) Which forecast technique is better if Alpha = 0.1?
I want to know BLANKS' answers
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
