Question: A16 fta) Develop a 3-month moving average to forecast sales from 4 to 11 period. (3 pts) B CIDI E F G Beau's department at

A16 fta) Develop a 3-month moving average to
A16 fta) Develop a 3-month moving average to forecast sales from 4 to 11 period. (3 pts) B CIDI E F G Beau's department at a local department store has tracked the sales of a product over the last ten weeks. lolololno Period Demand 1 24 2 23 7 3 26 8 4 36 9 26 10 30 11 7 32 12 26 13 9 25 14 10 28 15 16 a)Develop a 3-month moving average to forecast sales from 4 to 11 period. (3 pts) 17 b)Estimate sales again for 6 to 11 period within a 5-month weighted moving average in which registrations 18 in the most recent year are given a weight of 30, 25, 20, 15 and 10. (4 pts) 19 c)Compute the sales forecasts for each month untill May using exponential smoothing, with an initial 20 forecast for period 3 of 28. Use a -0.20 (4 pts) 21 d)Using MAD, which of the three forecasting methods is best? (3 pts) e)Using MSE, which of the three forecasting methods is best? (3 pts) 23 Using MAPE which of the three forecasting methods is best? pts)

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 General Management Questions!