Comm 399 HP Solution - Nov Europe Options A AA AB AQ AU AY Total Average Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct 80 400 20,572 4,008 4,564 248

Comm 399 HP Solution - Nov Europe Options A AA AB AQ AU AY...

This preview shows page 1 - 2 out of 5 pages.

Europe Options Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct VAR A 80 0 60 90 21 48 0 9 20 54 84 42 508 42.33 9.78 32.40 1049.76 AA 400 255 408 645 210 87 432 816 430 630 456 273 5,042 420.17 97.04 203.90 41575.21 AB 20,572 20,895 19,252 11,052 19,864 20,316 13,336 10,578 6,095 14,496 23,712 9,792 189,960 15830.00 3655.89 5624.60 ### AQ 4,008 2,196 4,761 1,953 1,008 2,358 1,676 540 2,310 2,046 1,797 2,961 27,614 2301.17 531.45 1168.50 1365392.25 AU 4,564 3,207 7,485 4,908 5,295 90 0 5,004 4,385 5,103 4,302 6,153 50,496 4208.00 971.82 2204.60 4860261.16 AY 248 450 378 306 219 204 248 484 164 363 384 234 3,682 306.83 70.86 103.10 10629.61 Total 29,872 27,003 32,344 18,954 26,617 23,103 15,692 17,431 13,404 22,692 30,735 19,455 277,302 23108.50 5336.84 6157.52 ### g Average 4,979 4,501 5,391 3,159 4,436 3,851 2,615 2,905 2,234 3,782 5,123 3,243 46,217 Monthly Average Demand Data From the Case: The total factory throughput time through the PCAT and FAT stages Manufactureing Lead Time(L1) 1 week The transportation time from Vancouver to the European DC (ocean transit) Transportation Lead Time (L2) 5 weeks The plant sends a weekly to the DC in Europe Review Period(T) 1 week HP's cost of debt plus some warehousing expenses Inventory Cost 25% Assume that all printers cost an average of approximately $250 Safety stock probability for the model 98% service factor for 98% service level Service Factor(z) 2.05 Exposure period 6 weeks Existing Inventory Model: P-Model Sea Freight Cost per Unit $9 Weekly Order (Q ) =

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture