HP Deskjet Printer Supply Chain.xlsx - Monthly Demand Data...

This preview shows page 1 - 6 out of 10 pages.

Monthly Demand Data by option Nov Dec Jan Feb Mar Apr May Jun A 80 0 60 90 21 48 0 9 AA 400 255 408 645 210 87 432 816 AB 20572 20895 19252 11052 19864 20316 13336 10578 AQ 4008 2196 4761 1953 1008 2358 1676 540 AU 4564 3207 7485 4908 5295 90 0 5004 AY 248 450 378 306 219 204 248 484 Total 29872 27003 32344 18954 26617 23103 15692 17431 Europe Options
n type Jul Aug Sep Oct 20 54 84 42 42.3 32.4 508 430 630 456 273 420.2 203.9 5042 6096 14496 23712 9792 15830.1 5624.6 189961 2310 2046 1797 2961 2301.2 1168.5 27614 4385 5103 4302 6153 4208.0 2204.6 50496 164 363 384 234 306.8 103.1 3682 13405 22692 30735 19455 23108.6 6244.0 Total 277303.2 z= 2.054 Sea Air L 5 2 R 1.5 1.5 $15 $30 Product cost $400 30% Europe Options Annual Demand Monthly Mean Monthly Std Dev ROP= d* per unit transportation Inv carrying cost
Lead Time Demand Safety Stock Sea Air Sea Air 42.3 32.4 48.8 19.5 34.8 22.0 182 85 420.2 203.9 484.8 193.9 219.0 138.5 1147 532 15830.1 5624.6 18265.5 7306.2 6041.8 3821.2 31639 14684 2301.2 1168.5 2655.2 1062.1 1255.2 793.8 6573 3050 4208 2204.6 4855.4 1942.2 2368.1 1497.7 12401 5755 306.8 103.1 354.0 141.6 110.7 70.0 580 269 23108.6 6244 26663.8 10665.5 6707.1 4242.0 35123 16301 Monthly Mean Monthly Std Dev Lead Time Demand Standard Deviation (σ) Sea (5 weeks) Air (2 weeks) *(R+L) + Z* σ * R+L
Order Upto Level Sea Air Sea Air Sea Air Sea 246 119 305.1 144.0 36612.6 17274.9 5632.7 1777 872 2035.6 968.1 244270.8 116177.4 37580.1 55384 27469 59331.1 28418.2 7119728.5 3410183.8 1095342.9 10025 4909 11585.3 5505.0 1390237.5 660604.8 213882.7 18713 9154 21757.7 10332.3 2610921.4 1239880.7 401680.2 1040 517 1100.0 527.6 132002.8 63315.3 20308.1 69786 34965 70016.2 33783.1 8401948.4 4053970.9 1292607.4 Average Total Inventory Inventory Holding Cost (for R+L period) Inventory H (per w
Total Cost (Per week) Air Sea Air Sea

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture