Assignment3_HP.xls - 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 weeks week

Assignment3_HP.xls - LT Review period Exposure period(EP...

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. Brand Mean Std dev Mean Std dev Mean Std dev Units Units Units (units) (units) (units) (units) (units) (units) (units) (units) (units) A 42.3 32.4 9.8 15.6 AB 15830.1 5624.6 3655.9 2703.0 AU 4208.0 2204.6 971.8 1059.5 AA 420.2 203.9 97.0 98.0 AQ 2301.2 1168.5 531.5 561.5 AY 306.8 103.1 70.9 49.5 Total 23,108.6 5336.9 Total Inventory cost: Inventory Cost/unit shipped: 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 (units) (units) (units) (units) (units) (units) (units) (units) (units) All 23,108.6 6,244.0 5,336.9 3,000.7 Total Inventory cost: Inventory Cost/unit shipped:
Exhibit:

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture