OPMACh2HW2 - 1 Computer Store Printer Rentals Week 6 Week 7...

1. Computer Store Printer Rentals
Week 6
Week 7
Week 8
Week 9
Week 10
Week 11
a. S
b.
b.i. Week 6: |28 – 27| = 1, Week 7: |32 – 28| = 4, Week 8: |35 – 30| = 5, Week 9: |26 – 30| = 4,
Week 10: |24-30| = 6
b.i.1. Total = 20/5 = 4
Month 3-month average Absolute Error(3) Percent
Error (3)
4-month average Absolute Error(4) Percent Error (4)
May |37-27.33|=9.67 26.14% |37-25.5|=11.5 31.08%
June |47-31.67|=15.33 32.62% |47-29.75|=17.25 36.71%
July |53-38.33|=14.67 27.68% |53-35.5|=17.5 33.02%
August |62-45.67|=16.33 26.34% |62-42|=20 32.26%
September |54-54|=0 0% |54-49.75|=4.25 7.87%
October |36-56.33|=20.33 56.47% |36-54|=18 50%
November |32-50.67|=18.67 58.34% |32-51.25|=19.25 60.16%
December |29-40.67|=11.67 40.24% |29-46|=17 58.62%
Average: 13.33 33.48% 15.59 38.71%
2. Dalworth Company Sales
Questions C-E Answers
Measure 3-Month 4-Month Recommendation
Mean Absolute
Deviation
13.33 15.59 3-Month
Mean Absolute %
Error
33.48% 38.71% 3-Month

Mean Squared Error 213.56 267.21 3-Month
In reference to above [C-E)
26.14
31.0810
8
9.67 11.5
32.62
36.7021
3
15.33 17.25
27.68
33.0188
7
14.67 17.5
26.34
32.2580
6
16.33 20
0
7.87037
0 4.25
56.47
50
20.33 18
58.34
60.1562
5
18.67 19.25
40.24
58.6206
9
11.67 17
33.4787
5
38.7134
3
1708.46
2
213
7.68
8
213.557
8
267.
210
9
(Excel Document)
3.
Week Actual
Calls
F(t+1) Alpha Error CFE MAD MSE MAPE
1 24 24 0.2 0 0
2 32 25.6 0.2 8 8 8 64 25
3 36
27.68 0.2 10.4 18.4 10.4 108.16 28.8888
9
4 23 26.744 0.2 -4.68 13.72 4.68 21.9024 20.3478
3
5 25 26.3952 0.2 -1.744 11.976 1.744 3.04153
6
6.976
6 26.4
0.2 6.206 49.2759
8
20.3031
8
4) [a]
Month Sales ($
millions)
3-Month Weighted Average Absolute
Error
Absolute Error
%
Squared
Error
January 20
February 24
March 27
April
31
24.83 6.17 19.89 38.03
May 37 28.5 8.5 22.97 72.25
June 47 33.33 13.67 29.08 186.78
July
53
41 12 22.64 144

August 62 48.33 13.67 22.04 186.78
Septembe
r