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 trend forecast (using the seasonalize relatives) to get the final forecasted data. Do this for the historical data (periods 1-8) as well as periods 9 and 10. 5. Finally, calculate MAD and MAPE.

Period	Quarter	Sales (Dollars)
1	1	$210,563
2	2	$251,456
3	3	$264,123
4	4	$271,895
5	1	$289,652
6	2	$267,441
7	3	$278,952
8	4	$280,178

plz show work in cells, thanks :)