Forecasting Crates Homework

Rock1027
FORECASTaHW2.XLS
Home>Business & Finance homework help>Management homework help>Forecasting Crates Homework

Simple MA

INPUTS OUTPUTS
Number of Periods in Moving Average = Forecast = 0
Number of Periods of Data Collected = MSE = 0 MAPE = 0
MAD = 0 LAD = 0
Past Periods 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Weighting 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Absolute Error Absolute
Period Value Forecast Error Error Squared % Error 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
0 0 0 0 0 1
0 0 0 0 0 0 2 0
0 0 0 0 0 0 3 0 0
0 0 0 0 0 0 4 0 0 0
0 0 0 0 0 0 5 0 0 0 0
0 0 0 0 0 0 6 0 0 0 0 0
0 0 0 0 0 0 7 0 0 0 0 0 0
0 0 0 0 0 0 8 0 0 0 0 0 0 0
0 0 0 0 0 0 9 0 0 0 0 0 0 0 0
0 0 0 0 0 0 10 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 11 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 12 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 13 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 14 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 15 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 21 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 22 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 23 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 24 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 26 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 27 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 28 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 29 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 30 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 32 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 33 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 34 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 35 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 37 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 38 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 39 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 40 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 41 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 43 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 45 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 46 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 47 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 48 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 49 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 50 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 51 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 52 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 53 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 54 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 55 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 56 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 57 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 58 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 59 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 61 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Weighted MA

INPUTS OUTPUTS
Number of Periods in Moving Average = Forecast = 0
Number of Periods of Data Collected = MSE = 0 MAPE = 0
MAD = 0 LAD = 0
Past Period 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Weighting
Sum 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Absolute Error Absolute
Period Value Forecast Error Error Squared % Error 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
0 0 0 0 0 1
0 0 0 0 0 0 2 0
0 0 0 0 0 0 3 0 0
0 0 0 0 0 0 4 0 0 0
0 0 0 0 0 0 5 0 0 0 0
0 0 0 0 0 0 6 0 0 0 0 0
0 0 0 0 0 0 7 0 0 0 0 0 0
0 0 0 0 0 0 8 0 0 0 0 0 0 0
0 0 0 0 0 0 9 0 0 0 0 0 0 0 0
0 0 0 0 0 0 10 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 11 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 12 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 13 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 14 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 15 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 21 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 22 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 23 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 24 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 26 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 27 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 28 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 29 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 30 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 32 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 33 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 34 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 35 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 36 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 37 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 38 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 39 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 40 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 41 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 43 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 45 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 46 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 47 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 48 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 49 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 50 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 51 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 52 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 53 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 54 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 55 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 56 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 57 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 58 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 59 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 60 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 61 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Exp. Smooth.

INPUTS OUTPUTS
Number of Periods of Data Collected = Forecast = 0
Smoothing Constant (alpha) = MSE = 0 MAPE = 0
Initial Forecast Value = 0 MAD = 0 LAD = 0
Absolute Error Absolute
Period Value Forecast Error Error Squared % Error
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0

Class. Decomp.

INPUTS OUTPUTS
Number of Periods of Data Collected = Period Forecast = 0
Number of Periods in Season =
MSE = 0.00 MAPE = 0.000
MAD = 0.000 LAD = 0.000
OUTPUTS
Period 0 0 0 0 0 0 0 0 0 0 0 0
Forecast 0 0 0 0 0 0 0 0 0 0 0 0 2 3 4 5 6 7 8 9 10 11 12 2 3 4 5 6 7 8 9 10 11 12
1 0 0 0 0 0 0 0 0 0 0 0
Centered Seasonal/ Desesonalized Absolute Error Absolute 0 0 2 0 0 0 0 0 0 0 0 0 0 0
Period Value Moving Av. Random Values Forecast Error Error Squared % Error 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 9 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 average 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Adj. Seasonal Factors
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 3 4 5 6 7 8 9 10 11 12
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 9 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
Ssxy = 0 SSx = 0 B1 = 0 B0 = 0
Copyright 2001 John Lawrence & Barry Pasternack