Comm204 Assingment 3 Excel.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

Comm204 Assingment 3 Excel.xls - LT Review period Exposure...

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

LT 5 weeks Annual D 277,303 Review period 1 week C $ 250.00 Exposure period (EP) 6 weeks I 25% 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 58.6 38.1 78.6 48.8 4.9 AB 15830.1 5624.6 3655.9 2703.0 21935.5 6621.0 13639.3 18279.6 1828.0 AU 4208.0 2204.6 971.8 1059.5 5830.9 2595.1 5346.0 4859.1 485.9 AA 420.2 203.9 97.0 98.0 582.3 240.0 494.4 485.2 48.5 AQ 2301.2 1168.5 531.5 561.5 3188.7 1375.5 2833.5 2657.3 265.7 AY 306.8 103.1 70.9 49.5 425.1 121.4 250.0 354.3 35.4 Total 23,108.6 5336.9 22,642 26,684 2,668 Total Inventory cost: $3,249,657.69 Inventory Cost/unit shipped: $ 11.72 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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture