#$2.$ Using the Fastgro Fertilizer Company data again, develop a seasonally adjusted forecast for the demand.$$

Use the upper table to compute the seasonal factors and the total forecast for year $2019.$

$$Use linear trend line: find the intercept and slope of the totals for years $2016-2018.$

$$Predict the total for $2019$ using the linear trend line equation.

$$Compute the seasonal factors for each quarter.

Use the lower table to compute the seasonal forecast and error measures.

$$Use the seasonal factors and the total forecast for each year to forecast for each quarter.

$$Compute the MAD.

How does this method compare to the methods from Question #$1$in terms of accuracy?

Question $2$ Note: Only the yellow shaded boxes are autograded.

Instructions to the right.

#$2.$ Using the Fastgro Fertilizer Company data again, develop a seasonally adjusted forecast for the

demand.

Use the upper table to compute the seasonal factors and the total forecast for year $2019.$

Use linear trendline: find the intercept and slope of the totals for years $2016-2018.$

Predict the total for $2019$ using the linear trend line equation.

Compute the seasonal factors for each quarter.

Use the lower table to compute the seasonal forecast and error measures.

Use the seasonal factors and the total forecast for each year to forecast for each quarter.

Compute the MAD.

How does this method compare to the methods from Question #$1$in terms of accuracy?

SHOW IN EXCEL USING EXCEL FORMULAS TO FILL IN EACH SQUARE