3. Use excel to answer the folowing questions and show work and formulas used

Problem 3 One of the items a garden supply store stocks is a certain liquid fertilizer. The sales of this fertilizer are seasonal. Quarterly demands (in cases) for the past 2 years follow: a. Compute the quarterly seasonal indices for the demand using the simple average method. b. De-seasonalize the admissions demand. c. Develop a linear trend equation using the de-seasonalized demand. d. Develop a trend (de-seasonalized) forecast for quarters 1 to 4 for year 3 . e. Develop a final seasonalized forecast for quarters 1 to 4 for year 3