Question: D) Calculate three forecasts using the following data. First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3
D) Calculate three forecasts using the following data. First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 45.0 and an alpha of 0.4. Second, calculate the three-period moving-average forecast for periods 4 through 10. Third, calculate the weighted moving average for periods 4 through 10, using weights of .70, .20, and .10, with 0.70 applied to the most recent data. Calculate the mean absolute deviation (MAD) and the cumulative sum of forecast error (CFE) for each forecasting procedure. Which forecasting procedure would you select? Why? (3 +4 + 5 +5 +2 marks)
| Month | Demand |
| 1 | 45 |
| 2 | 48 |
| 3 | 43 |
| 4 | 48 |
| 5 | 49 |
| 6 | 54 |
| 7 | 47 |
| 8 | 50 |
| 9 | 46 |
| 10 | 47 |
). A restaurant has tracked the number of meals served at lunch over the last four weeks. The data show little in terms of trends, but do display substantial variation by day of the week. Use the following information to determine the seasonal (daily) indices for this restaurant. Round all numbers in your calculations to four decimal places. (10 marks
| Week | AVERAGE | AVG Monthly | SEASONAL INDEX | ||||
| Day | 1 | 2 | 3 | 4 | |||
| Sunday | 40 | 35 | 39 | 43 | |||
| Monday | 54 | 55 | 51 | 59 | |||
| Tuesday | 61 | 60 | 65 | 64 | |||
| Wednesday | 72 | 77 | 78 | 69 | |||
| Thursday | 89 | 80 | 81 | 79 | |||
| Friday | 91 | 90 | 99 | 95 | |||
| Saturday | 80 | 82 | 81 | 83 | |||
| TOTAL | |||||||
| OVERALL AVERAGE | |||||||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
