Share
Explore BrainMass

Forecasting techniques -regression moving average

Perform a linear regression, 8 month moving average & 3 month moving average forecasting technique to see which is most accurate for the new quarter 11 if quarter 11 sales are 172,000 units

Quarter Quarter Demand Shown in Thousand (1000) units
1 121
2 132
3 159
4 160
5 141
6 166
7 189
8 199
9 170
10 190

Make sure to include the equation for the linear regression calculation.
Explain 5 factors that could affect forecast accuracy.

Solution Preview

Please see ** ATTACHED ** file(s) for complete solution and details!!

Perform a linear regression, 8 month moving average & 3 month moving average forecasting technique to see which is most accurate for the new quarter 11 if quarter 11 sales are 172,000 units

Quarter (X) Demand (Y)
1 121
2 132
3 159
4 160
5 141
6 166
7 189
8 199
9 170
10 190
Demand Shown in Thousand (1000) units
Make sure to include the equation for the linear regression calculation.

1) Linear regression

Linear regression equation is
Y= a + b X

where

(X) ...

Solution Summary

Performs a linear regression, 8 month moving average & 3 month moving average forecasting techniques.

$2.19