HP Deskjet Supply Chain
HP Deskjet Supply Chain
HP Deskjet Supply Chain
x d
Customized
Models
Avg. Monthly
Demand
Standard
Deviation of
Monthly Demand
42.3
420.2
15,830.10
2,301.20
4,208.00
306.8
32.4
203.9
5,624.60
1,168.50
2,204.60
103.1
A
AA
AB
AQ
AU
AY
Safety
Stocks
(Monthly)
90.56
569.92
15721.23
3266.06
6162.04
288.17
Customized
Models
A
AA
AB
AQ
AU
AY
Avg. Monthly
Demand
Standard
Deviation of
Monthly Demand
Safety
Stocks - Air
Shipping
(Monthly)
42.3
420.2
15,830.10
2,301.20
4,208.00
306.8
32.4
203.9
5,624.60
1,168.50
2,204.60
103.1
40.50
254.88
7030.75
1460.63
2755.75
128.88
Safety
Stocks Sea
Shipping
(Monthly)
113.20
712.40
19651.54
4082.57
7702.56
360.22
Reduction
in Safety
Stock
64.22%
Avg.
Monthly
Demand
Safety
Stock
Total
Avg.
Inventory
Value of
Inventory
A
AA
42.3
420.2
113.20
712.40
134.35
922.50
67175.47
461248.64
AB
AQ
AU
AY
15,830.10
2,301.20
4,208.00
306.8
19651.54
4082.57
7702.56
360.22
27566.59
5233.17
9806.56
513.62
13783296.83
2616585.49
4903277.71
256808.29
Avg. Inventory
holding cost
Shipping
Cost
2820339.91
132968943.07
118737044741.6
9
4279074778.07
15026332661.53
41219060.45
84.6
840.4
2820424.51
132969783.47
31660.2
4602.4
8416
613.6
Total
118737076401.89
4279079380.47
15026341077.53
41219674.05
Total Cost
138219506741.93
Customi
zed
Models
Avg.
Monthly
Demand
Safety
Stock
Total
Avg.
Inventory
Value of
Inventory
42.3
40.50
61.65
30825.00
AA
420.2
254.88
464.98
232487.50
AB
15,830.10
7030.75
14945.80
7472900.00
AQ
2,301.20
1460.63
2611.23
1305612.50
AU
4,208.00
2755.75
4859.75
2429875.00
AY
306.8
128.88
282.28
141137.50
Avg. Inventory
holding cost
Shipping
Cost
118772.58
253.8
119026.38
6756304.71
2521.2
6758825.91
6980529301.25
94980.6
6980624281.85
213078000.02
13807.2
213091807.22
738036564.45
25248
738061812.45
2489974.24
1840.8
2491815.04
Total
Total Cost
7941147568.84
As we can see from the above tables, Shipment from Air ways (at rate of $6) can also
result in significant saving in terms of total inventory cost due to reduction in safety
stock(68%).
Ship Generic (Basic / Bare Model) printers to the European DC and localizing them
based on local demand
By having bigger inventory of Generic printer and creating a small unit to work on local
modification / customization, we can cater local demand with shorter lead time and
smaller safety stock of specialized models.
We can even further tweak this model by following current existing procedures for AB
model, which is having 68% share in total average monthly sales, and at the same time
localizing other models (A, AA, AQ, AU, and AY) in Europe.
Current: Factory-Localization
MFG
DC
Customers
European DC -Localization
MFG
DC
Customers