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 $1.$ Which method do you think is better? YEARDEMAND FOR FERTILIZER $(1,000$s OF BAGS$)1426344551068778991210141115$ Develop a trend line for the demand for fertilizer in Problem $5-17,$ using any computer software.In Problems $5-17$ and $5-18,$ three different forecasts 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.Use exponential smoothing with a smoothing constant of $0\mathrm{.}3$ to forecast the demand for fertilizer given in Problem $5-17.$ Assume that last periods 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-17?$ Explain your answer" Sales of Cool$-$Man air conditioners have grown steadily during the past $5$ years: YEARSALES$145024953518456355846?$ The sales manager had predicted, before the business started, that year $1$s sales would be $410$ air conditioners. Using exponential smoothing with a weight of $=0\mathrm{.}30,$ develop forecasts for years $2$ through $6.$Using smoothing constants of $0\mathrm{.}6$ and $0\mathrm{.}9,$ develop forecasts for the sales of Cool$-$Man air conditioners $($see Problem $5-22).$What effect did the smoothing constant have on the forecast for Cool$-$Man air conditioners? $($See Problems $5-22$ and $5-23.)$ Which smoothing constant gives the more accurate forecast?Use a $3-$year moving average forecasting model to forecast the sales of Cool$-$Man air conditioners $($see Problem $5-22).$Using the trend projection method, develop a forecasting model for the sales of Cool$-$Man air conditioners $($see Problem $5-22).$Would you use exponential smoothing with a smoothing constant of $0\mathrm{.}3,$ a $3-$year moving average, or a trend line to predict the sales of Cool$-$Man air conditioners? Refer to Problems $5-22,5-25,$ and $5-26."$