BUS105 Production and Operations Management HW Assignment 4
Number 1
Week Actual # of Patients
Having Trouble Meeting Your Deadline?
Get your assignment on BUS105 Production and Operations Management HW Assignment 4 completed on time. avoid delay and – ORDER NOW
1 65
2 62
3 70
4 48
5 63
6 52
A B C
W4 0.167 0.16667 0.1
W3 0.25 0.25 0.2
W2 0.25 0.25 0.3
W1 0.333 0.333333 0.4
A B C
7 56.756 56.75 56.3
A) Value of forecast is __________
B) The forecast will ___________ as the weights remain the same
C) Forecast for week 7 is _______________
Number 2
A
Month Price Per Chip Two month Moving Average in $
January $1.80
February $1.67
March $1.70 $1.735
April $1.85 $1.685
May $1.90 $1.775
June $1.87 $1.875
July $1.80 $1.885
August $1.83 $1.835
September $1.70 $1.815
October $1.65 $1.765
November $1.70 $1.675
December $1.75 $1.675
B
Month
January
Price Per Chip
$1.80
Three month Moving Average in $
February $1.67
March $1.70
April $1.85 $1.723
May $1.90 $1.740
June $1.87 $1.817
July $1.80 $1.873
August $1.83 $1.857
September $1.70 $1.833
October $1.65 $1.777
November $1.70 $1.727
December $1.75 $1.683
C
Error for Two Month Error For Three Month
0.0305
0.165 0.127
0.125 0.16
0.005 0.054
0.085 0.073
0.005 0.026
0.115 0.133
0.115 0.126
0.025 0.026
0.075 0.067
Total 0.75 0.79
MAD Total 0.075 0.088
MAD For the 2 Month Total is performing better than MAD for month 3.
D
a=0.1 a=0.3 a=0.5
Month Price Per Chip Forecast Error Forecast Error Forecast Error
January $1.80 1.8 0 1.8 0 1.8 0
February $1.67 1.8 0.13 1.8 0.13 1.8 0.13
March $1.70 1.79 0.09 1.76 0.06 1.74 0.04
April $1.85 1.78 0.07 1.74 0.11 1.72 0.13
May $1.90 1.79 0.11 1.77 0.13 1.79 0.12
June $1.87 1.8 0.07 1.81 0.06 1.84 0.03
July $1.80 1.8 0 1.83 0.03 1.86 0.06
August $1.83 1.8 0.03 1.82 0.01 1.83 0
September $1.70 1.81 0.11 1.82 0.12 1.83 0.13
October $1.65 1.8 0.15 1.79 0.14 1.76 0.11
November $1.70 1.79 0.08 1.75 0.05 1.71 0.01
December $1.75 1.77 0.02 1.73 0.02 1.7 0.05
Totals 0.86 0.86 0.81
MAD 0.72 0.072 0.675
1 2 3 4 5 6 7 8 9 10 11 12
Price
2 Month Moving Average
Number 3
A
With a=0.6 Year
Actual
Forecast
Error
Absolute
1 At
45 Ft
41 At-Ft
4 Error
4
2 50 43.4 6.6 6.6
3 52 47.36 4.64 4.64
4 56 50.14 5.86 5.86
5 58 53.66 4.34 4.34
6 56.26
25.44
Calculate 0.6 Forecast
Calculate 0.9 Forecast
2 44.6
3 49.46
4 51.75
5 55.75
6 57.76
B Year Actual Forecast Error Absolute At Ft At-Ft Error
1 45
2 50
3 52
4 56 49 7 7
5 &
