QUESTION 2 a. Month Demand 1 45 2 48 3 43 4 48 5 49 6...

Transcribed Image Text:

QUESTION 2 a. Month Demand 1 45 2 48 3 43 4 48 5 49 6 54 7 47 8 50 9 46 10 47 Using the table above, calculate two forecasts using the following method:- b. 11. First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 45.0 and an alpha of 0.4. [3 marks] Calculate the weighted moving average for periods 4 through 10, using weights of [3 marks] .70, .20, and .10, with 0.70 applied to the most recent data. 111. Calculate the mean absolute deviation (MAD) for each forecasting procedure. Which forecasting procedure would you select? Why? [6 marks] The number of disk drives (in millions) made at a plant in China during the past 5 years follows: Year Disc Drives 1 140 2345 160 190 200 210 i. Forecast the number of disk drives to be made next year, using linear regression. [13 marks] TOTAL 25 MARKS QUESTION 2 a. Month Demand 1 45 2 48 3 43 4 48 5 49 6 54 7 47 8 50 9 46 10 47 Using the table above, calculate two forecasts using the following method:- b. 11. First, for periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 45.0 and an alpha of 0.4. [3 marks] Calculate the weighted moving average for periods 4 through 10, using weights of [3 marks] .70, .20, and .10, with 0.70 applied to the most recent data. 111. Calculate the mean absolute deviation (MAD) for each forecasting procedure. Which forecasting procedure would you select? Why? [6 marks] The number of disk drives (in millions) made at a plant in China during the past 5 years follows: Year Disc Drives 1 140 2345 160 190 200 210 i. Forecast the number of disk drives to be made next year, using linear regression. [13 marks] TOTAL 25 MARKS