Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. 1. To develop a 3-year moving average to fo forecast sales, complete the 3-Yr MA column below. What is the MAD (3-year moving average)? 2. Complete the 3-Yr Wt. MA column to estimate demand 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. What is the MAD (3-year weighted moving average)? 3. To develop a trend line for the demand for fertilizer, complete the Trend line column in the table. What is the MAD (trend line)? Year Demand 3-Yr MA 3-Yr Wt. MA Trend line 1 4 0.73 2 6 1.67 3 4 4 5 0.55 1.44 5 10 5.00 2.51 6 8 1.67 0.75 7 7 0.75 2.60 8 9 0.67 1.00 1.65 9 12 4.00 0.29 10 14 4.67 1.24 11 15 3.34 2.75 1.18 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. 1. To develop a 3-year moving average to fo forecast sales, complete the 3-Yr MA column below. What is the MAD (3-year moving average)? 2. Complete the 3-Yr Wt. MA column to estimate demand 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. What is the MAD (3-year weighted moving average)? 3. To develop a trend line for the demand for fertilizer, complete the Trend line column in the table. What is the MAD (trend line)? Year Demand 3-Yr MA 3-Yr Wt. MA Trend line 1 4 0.73 2 6 1.67 3 4 4 5 0.55 1.44 5 10 5.00 2.51 6 8 1.67 0.75 7 7 0.75 2.60 8 9 0.67 1.00 1.65 9 12 4.00 0.29 10 14 4.67 1.24 11 15 3.34 2.75 1.18