ABC%20Example - 4863.655 critical fractile 0.388889 optimal...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
SKU Demand Unit Price Annual Sales ($) %Sales F-1 40,000 0.06 2400 5.3% 7 F-3 195,000 0.1 19500 43.0% 1 F-7 30,000 0.09 2700 5.9% 6 H-1 100,000 0.05 5000 11.0% 3 H-3 3,000 0.15 450 1.0% 10 H-4 50,000 0.06 3000 6.6% 5 H-6 10,000 0.07 700 1.5% 8 J-1 30,000 0.12 3600 7.9% 4 J-3 150,000 0.05 7500 16.5% 2 K-3 6,000 0.09 540 1.2% 9 45390 Cum % ABC Class 195,000 0.1 19500 43.0% 43.0% A 150,000 0.05 7500 16.5% 59.5% A 100,000 0.05 5000 11.0% 70.5% B 30,000 0.12 3600 7.9% 78.4% B 50,000 0.06 3000 6.6% 85.0% B Q* 30,000 0.09 2700 5.9% 91.0% C 80% stock out 112.6243 40,000 0.06 2400 5.3% 96.3% C 10,000 0.07 700 1.5% 97.8% C Printing Ex 6,000 0.09 540 1.2% 99.0% C Profit 0.35 3,000 0.15 450 1.0% 100.0% C underage cost 0.55 forecast 12000 chance sales exceed 20k 5% Z 95% value 1.644854 units 20000 20k-12k/s=z std dev=8k/z
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 4863.655 critical fractile 0.388889 optimal order quantity Q* 10627.4 10628 Demand 1000 Demand 10000 Fixed Cost 20 Std dev 130 Holding 8.33 Cost to place 10 Ch 99.96 Ch 1.5 lead time 10 days 0.027397 EOQ 20.004 cost per unit 15 T ann $ 1999.6 stock out risk 5% Orders per year 49.99 D/Q z 1.644854 Time between orders 0.020004 Q/D Safety Stock 21383.1 7.30146 days EOQ 365.1484 days 260 daily dema 100 Demand 26000 std dev 30 L 3 Ch 9.4 Co 35 per order SL 92% z 1.405072 EOQ 440.0193 Safety Sto 73.00966 ROP 373.0097 TC 5129.624 p 0.016924 4.400193...
View Full Document

This note was uploaded on 11/29/2011 for the course MGMT 4060 taught by Professor Mcdermott during the Spring '11 term at Rensselaer Polytechnic Institute.

Page1 / 3

ABC%20Example - 4863.655 critical fractile 0.388889 optimal...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online