Assignment3 HP case excel - LT Review period Exposure period(EP Service Level z I Unit cost 5 1 6 4.33 98 2.06 25 $250 Brand A AB AU AA AQ AY Total

Assignment3 HP case excel - LT Review period Exposure...

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

LT 5 weeks Review period 1 week Exposure period (EP) 6 weeks 4.33 weeks/mo Service Level 98% z 2.06 I 25% Unit cost $250 Monthly Weekly Demand during EP Safety St. Pipeline Cycle St. Cost Brand Mean Std dev Mean Std dev Mean Std dev Units Units Units Total For Each (units) (units) (units) (units) (units) (units) (units) (units) (units) Inventory Model A 42.3 32.4 9.8 15.6 58.6 38.1 78.6 48.8 4.9 132.3 $8,268.59 AB 15830.1 5624.6 3655.9 2703.0 21935.5 6621.0 13639.3 18279.6 1828.0 33746.8 $2,109,173.06 AU 4208.0 2204.6 971.8 1059.5 5830.9 2595.1 5346.0 4859.1 485.9 10691.0 $668,189.47 AA 420.2 203.9 97.0 98.0 582.3 240.0 494.4 485.2 48.5 1028.2 $64,261.51 AQ 2301.2 1168.5 531.5 561.5 3188.7 1375.5 2833.5 2657.3 265.7 5756.5 $359,783.19 AY 306.8 103.1 70.9 49.5 425.1 121.4 250.0 354.3 35.4 639.7 $39,981.87 Total 23,108.6 5336.9 Total Inventory cost: $3,249,657.69 Inventory Cost/unit shipped: $ 11.72 Total Supply Chain Cost/printer For Generic Printers: Monthly Weekly Demand during EP Safety St. Pipeline Cycle St. Brand Mean Std dev Mean Std dev Mean Std dev Units Units Units Total (units) (units) (units) (units) (units) (units) (units) (units) (units)

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture