(See Steps) Data collected on the yearly demand for SO-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Develop a three-year
Question: Data collected on the yearly demand for SO-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Develop a three-year moving average to forecast sales. Then estimate demand again with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other two years are each given a weight of 1. Which method do you think is best?
| Year | Demand for fertilized (1000's of bags) |
| 1 | 4 |
| 2 | 6 |
| 3 | 4 |
| 4 | 5 |
| 5 | 10 |
| 6 | 8 |
| 7 | 7 |
| 8 | 9 |
| 9 | 12 |
| 10 | 14 |
| 11 | 15 |
Deliverable: Word Document 