EXCEL-ASSIGNMENT 3 - Exhibit 4 DeskJet Demand Data from Europe Europe Options A AB AU AA AQ AY TOTAL NOV 80 20,572 4,564 400 4,008 248 29,872 DEC

EXCEL-ASSIGNMENT 3 - Exhibit 4 DeskJet Demand Data...

This preview shows page 1 out of 7 pages.

Unformatted text preview: Exhibit 4: DeskJet Demand Data from Europe Europe Options A AB AU AA AQ AY TOTAL NOV 80 20,572 4,564 400 4,008 248 29,872 DEC 20,895 3,207 255 2,196 450 27,003 JAN FEB 60 19,252 7,485 408 4,761 378 32,344 90 11,052 4,908 645 1,953 306 18,954 MAR 21 19,864 5,295 210 1,008 219 26,617 APR 48 20,316 90 87 2,358 204 23,103 MAY 13,336 432 1,676 248 15,692 JUN JUL 9 10,578 5,004 816 540 484 17,431 20 6,096 4,385 430 2,310 164 13,405 AUG 54 14,496 5,103 630 2,046 363 22,692 SEP 84 23,712 4,302 456 1,797 384 30,735 OCT 42 9,792 6,153 273 2,961 234 19,455 Mean 42.3 15830.1 4208.0 420.2 2301.2 306.8 23108.6 Std. Dev Coeff of Var 32.4 5624.6 2204.6 203.9 1168.5 103.1 6244.0 76.6% 35.5% 52.4% 48.5% 50.8% 33.6% 27.0% LT Review period Exposure period (EP) Service Level z I Unit cost Current Safety Stock 37.4 14002.1 3722.1 371.7 2035.5 271.4 Brand A AB AU AA AQ AY 20440.2 5 weeks 1 week 6 weeks 4.33 weeks/mo 98% 2.05 25% $250 Monthly Mean Std dev (units) (units) 42.3 32.4 15830.1 5624.6 4208.0 2204.6 420.2 203.9 2301.2 1168.5 306.8 103.1 Weekly Mean Std dev (units) (units) 9.8 15.6 3655.9 2703.0 971.8 1059.5 97.0 98.0 531.5 561.5 70.9 49.5 23,108.6 5336.9 6244.0 3000.7 Demand during EP Mean (units) 58.6 21935.5 5830.9 582.3 3188.7 425.1 32,021 Total Inventory Cost: Inventory Cost/unit shipped: For Generic Printers: Brand All Monthly Mean Std dev (units) (units) 23,108.6 6,244.0 Weekly Mean Std dev (units) (units) 5,336.9 3,000.7 Demand during EP Mean (units) 32,021.2 Total WEEKLY Inventory Cost: Inventory Cost/unit shipped: Demand during EP Std dev (units) 38.1 6621.0 2595.1 240.0 1375.5 121.4 7350.1 Total Inventory Cost: Inventory Cost/unit shipped: Demand during EP Std dev (units) 1,225.0 otal WEEKLY Inventory Cost: Inventory Cost/unit shipped: Safety St. Units (units) 78.3 13597.9 5329.8 492.9 2824.9 249.3 22573.1 Pipeline Cycle St. Units Units (units) (units) 48.8 4.9 18279.6 1828.0 4859.1 485.9 485.2 48.5 2657.3 265.7 354.3 35.4 26684.3 2668.4 Total Inv Units (units) 132.1 33,705.4 10,674.8 1,026.7 5,747.9 639.0 51,925.8 $3,245,363.51 $11.70 Safety St. Pipeline Cycle St. Units Units Units (units) (units) (units) 15,095.3 26,684.3 2,668.4 $2,778,001.94 $10.02 Total Inv Units (units) 44,448.0 LT Review period Exposure period (EP) Service Level z I Unit cost Current Safety Stock 37.4 14002.1 3722.1 371.7 2035.5 271.4 1 weeks 1 week 2 weeks 4.33 weeks/mo 98% 2.05 25% $260 Brand A AB AU AA AQ AY 20440.2 Monthly Mean Std dev (units) (units) 42.3 32.4 15830.1 5624.6 4208.0 2204.6 420.2 203.9 2301.2 1168.5 306.8 103.1 Weekly Mean Std dev (units) (units) 9.8 15.6 3655.9 2703.0 971.8 1059.5 97.0 98.0 531.5 561.5 70.9 49.5 Demand during EP Mean (units) 19.5 7311.8 1943.6 194.1 1062.9 141.7 23,108.6 5336.9 10,673.7 6244 3000.7 Total Inventory cost: Inventory Cost/unit shipped: For Generic Printers: Brand All Monthly Mean Std dev (units) (units) 23,108.6 6,244.0 Weekly Mean Std dev (units) (units) 5,336.9 3,000.7 Demand during EP Mean (units) 10,673.7 Total Inventory cost: Inventory Cost/unit shipped: Demand during EP Std dev (units) 22.0 3822.6 1498.3 138.6 794.1 70.1 2121.8 Total Inventory cost: Inventory Cost/unit shipped: Demand during EP Std dev (units) 2,121.8 Total Inventory cost: Inventory Cost/unit shipped: Safety St. Units (units) 45.2 7850.7 3077.1 284.6 1631.0 143.9 13032.6 Pipeline Cycle St. Units Units (units) (units) 9.8 4.9 3655.9 1828.0 971.8 485.9 97.0 48.5 531.5 265.7 70.9 35.4 5336.9 2668.4 Total Inv Units (units) 59.9 13,334.6 4,534.9 430.2 2,428.2 250.2 21,037.9 $1,367,461.48 $4.93 Safety St. Units (units) 8,715.3 $1,086,836.89 $3.92 Pipeline Units (units) 5,336.9 Cycle St. Units (units) 2,668.4 Total Inv Units (units) 16,720.6 ...
View Full Document

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture