Reference no: EM133446655
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 naïve 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?