4 MGMT 4317 Chapter 8 Homework Problems - You must show all work in all problems to receive credit. You will receive zero (0) credit for providing the answer only 1. Demand over past 3 months has been 240, 210, and 223 units. Using a three-month moving average, determine the forecast for month four. If the actual demand in month 4 is 264, calculate the forecast for month 5 using a three-month moving average.. 2. Given the following data, calculate the three month moving average forecasts for months 4, 5, 6, and 7. Remember that the data to calculate the forecast is given to you in the table Month Actual Demand Forecast 1 65 2 80 3 30 45 5 60 6 70 7 3. If the forecast for May was 222, and the actul demand for May is 235, what would be the forecast for June if the smoothing constant (alpha) is.207 I June demand is actually 290, calculate forecast for July 4. Given the following average demand, calculate the seasonal indices for each quarter: Quarter Average Demand Seasonal Index 1 164 2 480 3 490 14 170 Total 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 1 2 3 4 6. Calculate the descasonalized demands for the following: Quarter Annual Demand Seasonal Index Deseasonalized Demand 1 130 2 170 1.00 3 375 1.80 4 90 0.50 Total WWW 0.20 7. For the following data, calculate the mean absolute deviation (MAD) Period Forecast Actual Demand Absolute Deviation 1 100 80 2 100 110 3 100 130 4 100 75 s 100 105 Total 8. A company uses a tracking signal trigger of+or-4 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 16.67. Is there any previous indication that the forecast should be reviewed? Period Forecast Actual Deviation Cumulative Deviation Tracking Signal 1 100 110 2 TOS 90 3 110 85 4 115 110 5 120 IOS 6 125 95