HP Deskjet Printer Analysis.xlsx - HP Deskjet Base Case...

This preview shows page 1 - 3 out of 3 pages.

HP Deskjet - Base Case Unit cost = $400 Lead time, L (weeks) = 5 C.-L. Li Holding cost rate = 30% Target CSL = 0.98 z = 2.054 Number of weeks per month = 4.333 Sample Deskjet Demand Data (Europe): Option Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Monthly Mean Monthly S.D. A 80 0 60 90 21 48 0 9 20 54 84 42 42.3 32.4 AA 400 255 408 645 210 87 432 816 430 630 456 273 420.2 203.9 AB 20572 20895 19252 11052 19864 20316 13336 10578 6096 14496 23712 9792 15830.1 5624.6 AQ 4008 2196 4761 1953 1008 2358 1676 540 2310 2046 1797 2961 2301.2 1168.5 AU 4564 3207 7485 4908 5295 90 0 5004 4385 5103 4302 6153 4208.0 2204.6 AY 248 450 378 306 219 204 248 484 164 363 384 234 306.8 103.1 Total 29872 27003 32344 18954 26617 23103 15692 17431 13405 22692 30735 19455 23108.6 6244.0 Safety Stock Calculations: Monthly Monthly Weekly Weekly Pipeline Safety Option Mean S.D. Mean S.D. Stock Stock A 42.3 32.4 9.8 15.6 48.8 71.5 AA 420.2 203.9 97.0 98.0 484.8 449.9 AB 15830.1 5624.6 3653.4 2702.1 18266.9 12408.7 AQ 2301.2 1168.5 531.1 561.3 2655.4 2577.9 AU 4208.0 2204.6 971.2 1059.1 4855.8 4863.7 AY 306.8 103.1 70.8 49.5 354.1 227.5 Total 23108.6 6244.0 26665.8 20599.2 Annual Holding Cost: Holding cost of safety stock = $2,471,907 Holding cost of pipeline stock = $3,199,896 Total safety and pipeline stock holding cost = $5,671,803 Per unit supply chain holding cost = $20.45
HP Deskjet - Air Freight Unit cost = $400 Lead time, L (weeks) = 1 C.-L. Li Holding cost rate = 30% Target CSL = 0.98 z = 2.054 Number of weeks per month = 4.333 Sample Deskjet Demand Data (Europe): Option

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture