Question

3. This is the following demand data: Period | Demand 1 | 250 2 | 275 3 | 320 4 | 300 5 | 350 6 | 287 7 | 250 8 | 450 a. Use Excel or some other statistical package to calculate the regression equation for the data. b. Use the regression equation to forecast the data for all the time period. Plot the graph. c. Calculate the ratio of demand to forecast for all the time period. d. Calculate the seasonal multipliers for all the time period. e. Calculate the seasonally adjusted regression forecast of all the time period. Plot the graph and also show the comparison with the data obtained in Question b. f. Calculate the % error for the set of data obtained in Question b and Question e. In which case is the % error less? g. Only with the forecast data obtained in Question b, calculate the Mean forecast Error (MFE) and Mean Absolute Deviation (MAD).

          3. This is the following demand data:

Period | Demand
1 | 250
2 | 275
3 | 320
4 | 300
5 | 350
6 | 287
7 | 250
8 | 450

a. Use Excel or some other statistical package to calculate the regression equation for the data.
b. Use the regression equation to forecast the data for all the time period. Plot the graph.
c. Calculate the ratio of demand to forecast for all the time period.
d. Calculate the seasonal multipliers for all the time period.
e. Calculate the seasonally adjusted regression forecast of all the time period. Plot the graph and also show the comparison with the data obtained in Question b.
f. Calculate the % error for the set of data obtained in Question b and Question e. In which case is the % error less?
g. Only with the forecast data obtained in Question b, calculate the Mean forecast Error (MFE) and Mean Absolute Deviation (MAD).

3. This is the following demand data:

Period | Demand
1 | 250
2 | 275
3 | 320
4 | 300
5 | 350
6 | 287
7 | 250
8 | 450

a. Use Excel or some other statistical package to calculate the regression equation for the data.
b. Use the regression equation to forecast the data for all the time period. Plot the graph.
c. Calculate the ratio of demand to forecast for all the time period.
d. Calculate the seasonal multipliers for all the time period.
e. Calculate the seasonally adjusted regression forecast of all the time period. Plot the graph and also show the comparison with the data obtained in Question b.
f. Calculate the % error for the set of data obtained in Question b and Question e. In which case is the % error less?
g. Only with the forecast data obtained in Question b, calculate the Mean forecast Error (MFE) and Mean Absolute Deviation (MAD).

Added by Anthony B.

Question

Please give Ace some feedback