Exhibit 15.15: 15.15: DeskJet Demand Demand Data from Euro pe
Europe Options
NOV
A
DEC
80
JAN
-
FE B
MAR 90
21
48
19,864
20,316
4,908
5,295
90
-
645
210
87
432
2,358
1,676
204 23,103
248 15,692
20,572
20,895
19,252
11,052
AU AA
AQ
AY
248 29,872
TOTAL
3,207
400 4,008
255
2,196
450 27,003
7,485 408
MAY
60
AB
4,564
APR
4,761
378 32,344
1,953
306 18,954
1,008
219 26,617
13,336
A Beginning Inventory Safety Stock
0
0
0
0
0
0
0
10 5
1 05
1 05
10 5
10 5
1 05
10 5
Quantity Requirement
185
105
165
195
126
153
105
Ending Inventory
105
105
105
105
105
105
105
A Beginning Inventory Safety Stock
0
0
0
0
0
0
0
1 8 26 4
18 26 4
18264
1 8 26 4
18264
1 8 2 64
18264
Quantity Requirement
38,836
39,159
37,516
29,316
38,128
38,580
31,600
Ending Inventory
18,264
18,264
18,264
18,264
18,264
18,264
18,264
Lead Time Manufacturing Shipping
7 35
The The orde orderr siz size e for for a fix fixed ed-e -eri riod od mo
T L d-bar s d
F i x ed ed Ti Tim
L I
Number of month between reviews Lead time in days Forecast average demand (d-bar) Standard deviation of demand Service Level Current inventory level
1 1.5
s T+L
42
z
Standard deviation of demand over the review and lead t z-value for the stated service level
32.4
Average demand over the vulnerable period
98 %
Safety stock
150 51.250 2.054 105
q
Order Quantity
105.25 60
JUN
JUL 9
AUG
SEP
OCT
Mean
Std. Dev
Lead Time
20
54
84
42
42
32.4
1.5
10,578
6,096
14,496
23,712
9,792
15830
5624.6
1.5
4,385
4,302
6,153
4208
2204.6
1.5
456
273
420
203.9
1.5
1,797
2,961
2301
1168.5
1.5
234 19,455
307 23109
103.1 6244.0
1.5 1.5
5,004 816
540
484 17,431
430
2,310
164 13,405
5,103 630
2,046
363 22,692
384 30,735
0
0
0
0
0
105
105
105
105
105
114
125
159
189
147
105
105
105
105
105
0
0
0
0
0
18264
18264
18264
18264
18264
28,842
24,360
32,760
41,976
28,056
18,264
18,264
18,264
18,264
18,264
ime
Service Level
Current Inventory
AVG Demand over order period
Safety Stock
98%
0
105
105
98%
0
39575
18264
98%
0
10520
7159
98%
0
1050
662
98%
0
5752.5
3794
98% 98%
0 0
767.5 57772.5
335 20276
Exhibit 15.15: DeskJet Demand Data from Euro pe
NOV
Europe Options 1
2
20.00
3
4
5
20.00
20.00
6 -
7
A
AB
5,143.00
5,143.00
5,143.00
5,143.00
5,223.75
5,223.75
5,223.75
AU AA
1,141.00
1,141.00
1,141.00
1,141.00
801.75
801.75
801.75
100.00
100.00
100.00
100.00
63.75
AQ
1,002.00
1,002.00
1,002.00
1,002.00
AY
62.00 7,468.00
62.00 7,468.00
62.00 7,468.00
62.00 7,468.00
TOTAL
20.00
DEC
-
-
63.75
63.75
549.00
549.00
549.00
112.50 6,750.75
112.50 6,750.75
112.50 6,750.75
A
0
Beginning Inventory
141.00
Order Quantity
121
Ending Inventory
121
101
-
-
101
81
61
81
61
61
-
61
61 -
61
61
AB
0
Beginning Inventory Quantity Requirement
40,862.00
Ending Inventory
35,719
35719
30576
25433
20290
-
-
-
-
30,576
25,433
20,290
15,066
15066
9842
-
-
9,842
4,618
Lead Time Manufacturing Shipping
7 35
The order size for a fixed-eriod model given variable demand that is normally distributed is determined by
Fixed Time Period Model with Safety Stock
T L 6 11 d-bar
Number of month week reviews
8.1
Standard deviation of demand
1
98% 0 21.439 2.054 77
s d
L I s T+L
z
Lead time in weeks Forecast average demand (d-bar)
Service Level Current inventory level Standard deviation of demand over the review and lead time z-value for the stated service level Average demand over the vulnerable period
44.03 121
Safety stock
q
Order Quantity
JAN 8
FEB
9 -
10
15.00
11
15.00
12
15.00
13
15.00
14
22.50
22.50
15
16
22.50
22.50
5,223.75
4,813.00
4,813.00
4,813.00
4,813.00
2,763.00
2,763.00
2,763.00
2,763.00
801.75
1,871.25
1,871.25
1,871.25
1,871.25
1,227.00
1,227.00
1,227.00
1,227.00
63.75
102.00
102.00
102.00
102.00
161.25
161.25
161.25
161.25
549.00
1,190.25
1,190.25
1,190.25
1,190.25
488.25
488.25
488.25
488.25
112.50 6,750.75
94.50 8,086.00
94.50 8,086.00
94.50 8,086.00
94.50 8,086.00
76.50 4,738.50
76.50 4,738.50
76.50 4,738.50
76.50 4,738.50
61
61
-
61
36,325.00 35,719
-
46
4618
46
31 105.00
31
121
106
-
-
121
106
35719
30906
26093
21280
-
-
-
-
30,906
26,093
21,280
16,467
83 -
83
16467
13,704
60
-
60
10941
10,941
106.00 37
13704
37 120
8178
-
-
8,178
5,415
MAR
APR
17
18
5.25
19
5.25
20
5.25
MAY
21
5.25
22
12.00
23
12.00
24
12.00
12.00 5,079.00
4,966.00
4,966.00
4,966.00
4,966.00
5,079.00
5,079.00
5,079.00
1,323.75
1,323.75
1,323.75
1,323.75
22.50
22.50
22.50
52.50
52.50
21.75
21.75
21.75
252.00
252.00
252.00
252.00
589.50
589.50
54.75 6,654.25
54.75 6,654.25
54.75 6,654.25
54.75 6,654.25
51.00 5,775.75
51.00 5,775.75
52.50
120
114
108
102
-
-
-
-
114
108
102
5415
35719
30753
25787
20821
-
-
-
-
35,270.00
52.50
35,719
30,753
25,787
96 -
96
20,821
15,742
21.75
108.00
589.50
589.50
419.00
51.00 5,775.75
51.00 5,775.75
62.00 3,923.00
72
60
72
60
15742 10,663
3,334.00 -
-
-
-
22.50
84
84
25
-
5,584
48
10663
48
5584 35,214.00
35,719
48
35719 32,385
JUN 26
27 -
28 -
3,334.00 -
3,334.00 -
JUL
29 -
30
2.25
31
2.25
32
2.25
33
2.25
34
5.00
5.00
3,334.00
2,644.50
2,644.50
2,644.50
2,644.50
1,524.00
1,524.00
1,251.00
1,251.00
1,251.00
1,251.00
1,096.25
1,096.25
-
108.00
108.00
108.00
204.00
204.00
204.00
204.00
107.50
107.50
419.00
419.00
419.00
135.00
135.00
135.00
135.00
577.50
577.50
62.00 3,923.00
62.00 3,923.00
62.00 3,923.00
121.00 4,357.75
121.00 4,357.75
121.00 4,357.75
121.00 4,357.75
41.00 3,351.25
41.00 3,351.25
48 48
48 48
48
48
-
-
48
29051
25717
22383
-
-
-
-
25,717
22,383
-
45
32385 29,051
45
19,738
42
120
117
112
-
-
-
120
117
112
107
17093
14448
11803
10279
81.00 42
19738 17,093
14,448
11,803
-
-
10,279
8,755
AUG 35
36
5.00
SEP
37
5.00
38
13.50
39
13.50
40
13.50
41
13.50
21.00
42
43
21.00
21.00
1,524.00
1,524.00
3,624.00
3,624.00
3,624.00
3,624.00
5,928.00
5,928.00
5,928.00
1,096.25
1,096.25
1,275.75
1,275.75
1,275.75
1,275.75
1,075.50
1,075.50
1,075.50
107.50
107.50
157.50
157.50
157.50
157.50
114.00
114.00
114.00
577.50
577.50
511.50
511.50
511.50
511.50
449.25
449.25
449.25
41.00 3,351.25
41.00 3,351.25
90.75 5,673.00
90.75 5,673.00
90.75 5,673.00
90.75 5,673.00
96.00 7,683.75
96.00 7,683.75
96.00 7,683.75
107
102
-
-
-
102
97
8755
7231
-
7,231
97
35,719
83
30,012.00
83
69 -
69
32095
28471
-
-
-
28,471
24,847
41
-
55
35719 32,095
55
101.00 41
24847 21,223
100
-
-
121
100
79
21223
15295
9367
121
15,295
-
-
9,367
3,439
OCT 44
Mean
45
21.00
46
10.50
47
10.50
Std. Dev
Lead Time
48
10.50
10.50
11
8.1
6
5,928.00
2,448.00
2,448.00
2,448.00
2,448.00
4058
1345.9
6
1,075.50
1,538.25
1,538.25
1,538.25
1,538.25
1020
535.3
6
114.00
68.25
68.25
68.25
68.25
107
50.0
6
449.25
740.25
740.25
740.25
740.25
564
288.7
6
58.50 4,863.75
58.50 4,863.75
58.50 4,863.75
58.50 4,863.75
78 5838
25.3 1541.4
6 6
96.00 7,683.75
79
58
-
58
38,208.00 35,719
36
-
47
3439
47
95.00 36
120 -
120
109
35719
33271
30823
28375
-
-
-
-
33,271
30,823
28,375
25,927
78
21,135
4875
35,719
1320938
Service Level
Current Inventory
AVG Demand over order period
Safety Stock
98%
0
77
44
98%
0
28406
7313
98%
0
7140
2909
98%
0
749
272
98%
0
3948
1569
98% 98%
0 0
546 40866
138 8376
