Question: I am stuggling with this question can someone please help me ? Question 32 (18 points) Jim's department at a local department store has tracked
Question 32 (18 points) Jim's department at a local department store has tracked the sales of a product over the last seven weeks. Period Demand 1 24 2 23 3 26 4 36 5 26 6 30 7 32 Round your answers to two decimal places. a) Compute a three-period weighted moving average forecasts for weeks 4, 5, 6, and 7, with weight 6, 4, 3 (largest weight is for most recent data). (4pt) b) Use exponential smoothing with smoothing constant a = 0.4 to forecast sales for weeks 5, 6, and 7. Assume a sales forecast of 30 for week 4. (4pt) c) Compute MAPE for weighted moving average and exponential smoothing (Parts a and b). (7pt) d) Which model is more accurate? (1pt) e) Forecast week 8 with the more accurate method. (2pt)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
