Use the data in the attached Excel file. Do the following:

1. Calculate the seasonal relatives for each quarter.

2. Using the seasonal relatives, deseasonalize the sales data.

3. Find a linear trend forecast for the deseasonalized data. Forecast for periods 1-8 as well as 9 and 10.

4. Adjust the linear tend forecast (using the seasonalize relatives) to get the final forecasted data. Do this for the historical data (periods 1-8) as well as period 9 and 10.

5. Finally, calculate MAPE. Comment on the likely accuracy of the forecast.

Auror CH Homework 3 12 - Excel e Search Else Storkamp Fic Home need Page Layout Formulas Data Review Help Share Comments - 11 Clien -AA Autosum Wrap Test Bad General Neutral Good 27 0 X Cut Cupy - Format Paint Clipboard SEX FI Iriset Odete Format Poste Normal Conditional Formatas Calculation Tormatting Table BU 3Merge & Center $ %, Check Cell -50 Explanatory input Clear Sort Find a Titte Select D. Analys Date Analysis Font Allprent Number Styles Cells Editing 012 D E F . H 1 K L M N 1 2 3 4 5 6 Period 1 2 3 4 5 6 7 8 B Quarter 1 2 3 4 1 2 3 4 C Sales (Dollars) $210,563 $251,456 $264,123 $271,895 $289,652 $267,441 $278,952 $280,178 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Data Onplay ang 10