5. Using the data in problem, and the son indices you have closed, calculate expected quarterly demand if the a l Quarter Seasonal Index fomcast is 2000 Forecast the descansonalized demands for the following Anal Demand Seasonal Inter Dealed Demand 2 170 7. For the following data, calculate the 10 TO * A company was a tracking signal trigger for decide whether a first show viewed Given the following ary determines which the whole be reviewed Moun Alte Dev (MAD ActualDub 4. Given the following average demand, calculate the seasonal indices for each quarter. Mean demand for 4 quarters = 311 Quarter Average Demand 144 Seasonal Index 144/311 = 0.463 460/311 = 1.479 490/311 = 1.5755 460 490 150 150/311 = 0.4823 Total (150+490+460+144)/4= 311 Note that your answer, if calculated correctly, should have all of the seasonal indices add up to the number of quarters in the entire season. 5. Using the data in problem 4, and the seasonal indices you have calculated, calculate expected quarterly demand if the annual forecast is 2000 units. Quarter Seasonal Index Forecast 6. Calculate the descasonalized demands for the following: Quarter Descasonalized Demand Annual Demand 130 Seasonal Index 0.60 1.10 170 Total 7. For the following data, calculate the mean absolute deviation (MAD). Period Forecast Actual Demand Absolute Deviation 100 90 Total 8. A company uses a tracking signal trigger of or- 3 to decide whether a forecast should be reviewed. Given the following history, determine in which period the forecast should be reviewed. Mean Absolute Deviation (MAD) for the item is 15. Is there any previous indication that the forecast should be reviewed? Period Forecast Actual Deviation Cumulative Deviation Tracking Signal 100 10595 110 115 100 105