Question

Please show full work so i can understand. 5-17Data 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 1. Which method do you think is better? DEMAND FOR FERTILIZER 1,000s OF BAGS 4 6 4 5 10 8 7 YEAR 1 2 3 4 5 6 7 3 month mov avg 4 5 6 7 8 9 10 3 month weighted moving avg 4 5 6 7 8 9 10 ABS Dev 1 2 1 2 2 1 3 yr 4 5 6 7 8 9 10 ABS DEV(moving) 1 2 1 2 2 1 3 TOTALABS DEV

          Please show full work so i can understand.
5-17Data 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 1. Which method do you think is better?
DEMAND FOR FERTILIZER 1,000s OF BAGS 4 6 4 5 10 8 7
YEAR
1
2
3
4
5
6
7
3 month mov avg
4
5
6
7
8
9
10
3 month weighted moving avg
4
5
6
7
8
9
10
ABS Dev
1
2
1
2
2
1
3 yr
4
5
6
7
8
9
10
ABS DEV(moving)
1
2
1
2
2
1
3
TOTALABS DEV

please show full work so i can understand 5 17data 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 m 90924

Added by Albert R.

Question

Please give Ace some feedback