Data collected on the yearly demand for 50-pound bags of fertilizer at wallace garden supply areshown in the following table. develop a 3-year moving average to forecast sales. then estimate demandagain with a weighted moving average in which sales in the most recent year are given a weight of 2and sales in the other 2 years are each given a weight of 1. which method do you think is best? demand for fertilizeryear (1,000s of bags)1 42 63 44 55 106 87 78 99 1210 1411 15a)develop a trend line for the demand for fertilizer in problem 5-15, using any computer software. b) three different forecasts were developed for the demand for fertilizer. thesethree forecasts are a 3-year moving average, a weighted moving average, and a trend line. whichone would you use? explain your answer. c) use exponential smoothing with a smoothing constant of 0.3 to forecast the demand for fertilizergiven in question (a). assume that last period forecast for year 1 is 5,000 bags to begin the procedure. would you prefer to use the exponential smoothing model or the weighted average model developed in problem 5-15? explain your answer.