Question DEMAND FOR FERTILIZERYEAR (1,000S OF BAGS)1 42 63 44 55 106 87 78 99 1210 1411 15Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: Develop a trend line for the demand for fertilizer using any computer software.For these three forecasts, 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.3 to forecast the demand for fertilizer given. Assume that last period’s 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? Explain your answer.

1.) Given Data - YEAR Demand for fertilizer 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9…

Answered: Question DEMAND FOR FERTILIZER…

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

Related questions

Question

Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table:

Develop a trend line for the demand for fertilizer using any computer software.
For these three forecasts, 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.3 to forecast the demand for fertilizer given. Assume that last period’s 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? Explain your answer.

Expert Solution