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

I am stuggling with this question can someone please help me ?  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 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!