Forecasting using template provide with excel
Why was Mark’s initial forecast of call volume so far off? What could have been the reasons for this?
What could Mark have done differently to improve his initial forecast What could Mark have done differently to improve his initial forecast? ?
Describe the details of the Last Value method used by Harry and explain its accuracy (MAD value) in comparison with the accuracy of the other methods.
Describe the details of the Averaging method used by Harry and explain its accuracy (MAD value) in comparison with the accuracy of the other methods.
Describe the details of the Moving Average (5 days) method used by Harry and explain its accuracy (MAD value) in comparison with the accuracy of the other methods.
Describe the details of the Exponential Smoothing (alpha = 0.1) method used by Harry and explain its accuracy (MAD value) in comparison with the accuracy of the other methods.
Describe the details of the Exponential Smoothing (alpha = 0.7) method used by Harry and explain its accuracy (MAD value) in comparison with the accuracy of the other methods.
Based on the analysis above, provide your recommendations to Mark on daily call volume forecasting to improve the scheduling of the call enter staff.