Question: Please provide excel formulas Problem 1: Monthly demand for batteries at Jump Start Batteries is as follows: Month 1 2 3 4 5 6 7
Please provide excel formulas
Problem 1: Monthly demand for batteries at Jump Start Batteries is as follows: Month 1 2 3 4 5 6 7 8 9 10 11 12 Demand 20 21 15 14 13 16 17 18 20 20 21 23 Produce a forecast of demand for the next four months using a five-month moving average model as well as a simple exponential smoothing model with a = 0.2. You can initialize the exponential smoothing model with a three-period centered average used as the estimate of a2. Evaluate the his- torical MSE, RMSE, MAD, and MAPE values for each model and determine which of the two models you recommend. Justify your recommendation. [30 points)
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
