# Question: In Problems 5 17 and 5 18 three different fore casts were developed

In Problems 5-17 and 5-18, three different fore-casts were developed for the demand for fertilizer. These three forecasts are a 3-year moving average, a weighted moving average, and a trend line. Which one would you use? Explain your answer.

In Problems 5-17, Data collected on the yearly demand for 50- pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Develop a 3-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 2 years are each given a weight of

Demand for Fertilizer

Year (1,000s of Ba gs)

1 ........... 4

2 ........... 6

3 ........... 4

4 ........... 5

5 ........... 10

6 ........... 8

7 ........... 7

8 ........... 9

9 ........... 12

10 .......... 14

11 .......... 15

In Problems 5-17, Data collected on the yearly demand for 50- pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Develop a 3-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 2 years are each given a weight of

Demand for Fertilizer

Year (1,000s of Ba gs)

1 ........... 4

2 ........... 6

3 ........... 4

4 ........... 5

5 ........... 10

6 ........... 8

7 ........... 7

8 ........... 9

9 ........... 12

10 .......... 14

11 .......... 15

**View Solution:**## Answer to relevant Questions

How would the forecast for week 25 of the previous problem change if the initial forecast was 40 instead of 50? How would the forecast for week 25 change if the forecast for week 1 were assumed to be 60?If the ROP is greater than the order quantity, explain how the ROP is implemented. Can the ROP be more than twice the order quantity and, if so, how is such a situation handled?Refer to Problem 6-64. Develop a net material requirements plan assuming that there are currently 150 units of Part A, 40 units of Part B, 50 units of Subassembly C, and 100 units of Part F currently in inventory.In Problem ...The German towns around the Black Forest are rep-resented by nodes in the network below. The dis-tances between towns is shown in kilometers. Find the shortest route from city 1 to city 16. If flooding in cities 7 and 8 ...For the Billy’s Bank situation in Problems, the salary and benefits for a teller would be $12 per hour. The bank is open 8 hours each day. It has been estimated that the waiting time cost per hour is $ 25 per hour in the ...Post your question