BSOP 330 Week 1 Lab
PROBLEM 4.1
A) (374 + 368 + 381) / 3 = 374.33 Pints
B) Forecast: (381 x .1) = 38.1 (368 x .3) = 110.4 (374 x .6) = 224.4 38.1 + 110.4 + 224.4 = 372.9 Pints
C)
Week Of
Pints Used
Forecast with exponential smoothing applied
31st Aug
360
360.00
7th Sep
389
360.00
14th Sep
410
365.80
21st Sep
381
374.64
28th Sep
368
375.91
5th Oct
374
374.33
12th Oct
374.26
Forecast : 374.26 Pints
PROBLEM 4.5
A) (3700 + 3800) / 2 = 3750 Miles
B) MAD = (100 + 100 + 100) / 3 = 100
C) MAD = (200 + 160 + 60) / 3 = 140
D) MAD = (100 + 350 + 75) / 3 = 175
PROBLEM 4.9
A)
Month
Price per Chip ($)
2-month moving average
January
1.8
February
1.67
March
1.7
1.735
April
1.85
1.685
May
1.9
1.775
June
1.87
1.875
July
1.8
1.885
August
1.83
1.835
September
1.7
1.815
October
1.65
1.765
November
1.7
1.675
December
1.75
1.675
January
1.725
B)
Month
Price per Chip ($)
3-month moving average
January
1.8
February
1.67
March
1.7
April
1.85
1.72
May
1.9
1.74
June
1.87
1.82
July
1.8
1.87
August
1.83
1.86
September
1.7
1.83
October
1.65
1.78
November
1.7
1.73
December
1.75
1.68
January
1.70
C)
Month
Price per Chip ($)
2-month moving average
Error
Absolute
January
1.8
February
1.67
March
1.7
1.735
-0.035
0.03
April
1.85
1.685
0.165
0.17
May
1.9
1.775
0.125
0.13
June
1.87
1.875
-0.005
0.00
July
1.8
1.885
-0.085
0.09
August
1.83
1.835
-0.005
0.00
September
1.7
1.815
-0.115
0.12
October
1.65
1.765
-0.115
0.12
November
1.7
1.675
0.025
0.03
December
1.75
1.675
0.075
0.08
MAD
0.08
Month
Price per Chip ($)
3-month moving average
Error
Absolute
January
1.8
February
1.67
March
1.7
April
1.85
1.72
0.13
0.13
May
1.9
1.74
0.16
0.16
June
1.87
1.82
A) (374 + 368 + 381) / 3 = 374.33 Pints
B) Forecast: (381 x .1) = 38.1 (368 x .3) = 110.4 (374 x .6) = 224.4 38.1 + 110.4 + 224.4 = 372.9 Pints
C)
Week Of
Pints Used
Forecast with exponential smoothing applied
31st Aug
360
360.00
7th Sep
389
360.00
14th Sep
410
365.80
21st Sep
381
374.64
28th Sep
368
375.91
5th Oct
374
374.33
12th Oct
374.26
Forecast : 374.26 Pints
PROBLEM 4.5
A) (3700 + 3800) / 2 = 3750 Miles
B) MAD = (100 + 100 + 100) / 3 = 100
C) MAD = (200 + 160 + 60) / 3 = 140
D) MAD = (100 + 350 + 75) / 3 = 175
PROBLEM 4.9
A)
Month
Price per Chip ($)
2-month moving average
January
1.8
February
1.67
March
1.7
1.735
April
1.85
1.685
May
1.9
1.775
June
1.87
1.875
July
1.8
1.885
August
1.83
1.835
September
1.7
1.815
October
1.65
1.765
November
1.7
1.675
December
1.75
1.675
January
1.725
B)
Month
Price per Chip ($)
3-month moving average
January
1.8
February
1.67
March
1.7
April
1.85
1.72
May
1.9
1.74
June
1.87
1.82
July
1.8
1.87
August
1.83
1.86
September
1.7
1.83
October
1.65
1.78
November
1.7
1.73
December
1.75
1.68
January
1.70
C)
Month
Price per Chip ($)
2-month moving average
Error
Absolute
January
1.8
February
1.67
March
1.7
1.735
-0.035
0.03
April
1.85
1.685
0.165
0.17
May
1.9
1.775
0.125
0.13
June
1.87
1.875
-0.005
0.00
July
1.8
1.885
-0.085
0.09
August
1.83
1.835
-0.005
0.00
September
1.7
1.815
-0.115
0.12
October
1.65
1.765
-0.115
0.12
November
1.7
1.675
0.025
0.03
December
1.75
1.675
0.075
0.08
MAD
0.08
Month
Price per Chip ($)
3-month moving average
Error
Absolute
January
1.8
February
1.67
March
1.7
April
1.85
1.72
0.13
0.13
May
1.9
1.74
0.16
0.16
June
1.87
1.82