Question: Please Help in solving this problem using excel or basic understanding formulas for dummies. a) Assuming an initial forecast for week 1 of 17,000 miles,

Please Help in solving this problem using excel or basic understanding formulas for dummies.
a) Assuming an initial forecast for week 1 of 17,000 miles, use exponential smoothing to compute miles for weeks 2 through 12 . Use =0.18 (round your responses to two decimal places). b) The MAD for this model =2.83 thousand (round your response to two decimal places). c) Compute the Cumulative Forecast Errors, cumulative MAD in thousands, and tracking signals (round your responses to two decimal places). Are the tracking signals within acceptable limits? The control limits for the tracking signal are set at \pm 5 MADs. The tracking signals acceptable limits
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
