5. Following table shows the sales data of printing paper (in reams) for the past 12...

Transcribed Image Text:

5. Following table shows the sales data of printing paper (in reams) for the past 12 weeks at a stationary retailer: Week 2 3 4 5 7 8 19 19 11 12 897 Sales 908 919 924 909 912 907 882 914 895 917 891 a. Calculate the forecast sales for week 13 using four-week moving average b. Forecast sales for week 13 using the weighted moving average method. The weights are _W1 =0.5, W2 = 0.3, W3 = 0.2. c. If the actual sales for week 13 is 901, calculate the forecasting error for each method (MA and WMA) for week 13. d. Which forecasting method is more accurate? Explain why. to earn full credit. Show all calculations 5. Following table shows the sales data of printing paper (in reams) for the past 12 weeks at a stationary retailer: Week 2 3 4 5 7 8 19 19 11 12 897 Sales 908 919 924 909 912 907 882 914 895 917 891 a. Calculate the forecast sales for week 13 using four-week moving average b. Forecast sales for week 13 using the weighted moving average method. The weights are _W1 =0.5, W2 = 0.3, W3 = 0.2. c. If the actual sales for week 13 is 901, calculate the forecasting error for each method (MA and WMA) for week 13. d. Which forecasting method is more accurate? Explain why. to earn full credit. Show all calculations

Answer rating: 100% (QA)

Here are the stepbystep calculations a Four week moving average W... View the full answer