FORECATING HOMEWORK OM211/MGT1311 1. The demand for a product in each of the last five months is shown below. Month 1 2 3 4 5 Demand ('00s) 1300 1700 1900 2300 2400 Use a two-month moving average to generate a forecast for demand in month 6. What is the nave forecast for month 6? 2. The table below shows the demand for a new aftershave in a shop for each of the last 7 months. Month 1 2 3 4 5 6 7 Demand 23 29 33 40 41 43 49 Calculate a two month moving average for months two to seven. What would be your forecast for the demand in month eight? 3. The table below shows the demand for a particular brand of razor in a shop for each of the last nine months. Month 1 2 3 4 5 6 7 8 9 Demand 10 12 13 17 15 19 20 21 20 Calculate a three month moving average for months three to nine. What would be your forecast for the demand in month ten? 4. The table below shows the demand for a particular brand of fax machine in a department store in each of the last twelve months. Month 1 2 3 4 5 6 7 8 9 10 11 12 Demand 12 15 19 23 27 30 32 33 37 41 49 58 Calculate the four month moving average for months 4 to 12. What would be your forecast for the demand in month 13? 5. The table below shows the demand for a particular brand of microwave oven in a department store in each of the last twelve months. Month 1 2 3 4 5 6 7 8 9 10 11 12 Demand 27 31 29 30 32 34 36 35 37 39 40 42 Calculate a six month moving average for each month. What would be your forecast for the demand in month 13