Question: I need help with d and e. Please show work and add notes if possible. I am very confused and would love the help. Thank


I need help with d and e. Please show work and add notes if possible. I am very confused and would love the help. Thank you.
1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. YEAR 1 2 3 4 5 6 7 8 DEMAND FOR FERTILIZER (1,000S OF BAGS) 7 6 5 7 10 9 13 15 d) Develop a trend line model to forecast sales. You may use Excel to find the intercept and slope coefficients of the trend line. e) Which of the developed forecasts:3-year moving averages, 3-year weighted moving averages, exponential smoothing, or trend line, would you use based on each of MAD, MSE, MAPE, and bias? To answer this question, you need to calculate 16 values (4 accuracy measures for each of the 4 forecasting model)Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
