Ch12Ex9 - 991.67 5 247.06 495.83 25000 25742.89 15 1050 4.8...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 12: Example 9 Inventory Quantity Discount Model Data Demand rate, D 5000 Setup cost, S 49 Holding cost %, I 0.2 Range 1 Range 2 Range 3 Minimum quantity 700 1000 2000 Unit Price, P 5 4.8 4.75 Results Range 1 Range 2 Range 3 Q* (Square root formu 700 714.43 718.18 Order Quantity 700 1000 2000 Holding cost $350.00 $480.00 $950.00 Setup cost $350.00 $245.00 $122.50 Unit costs $25,000.00 $24,000.00 $23,750.00 $25,700.00 $24,725.00 $24,822.50 Base inc on 700 Cost table Q Unit cost Setup cost Holding cost Total unit costs Total Costs 1 233.33 #N/A 1050 #N/A #N/A #N/A 2 291.67 #N/A 840 #N/A #N/A #N/A 3 350 #N/A 700 #N/A #N/A #N/A 4 408.33 #N/A 600 #N/A #N/A #N/A 5 466.67 #N/A 525 #N/A #N/A #N/A 6 525 #N/A 466.67 #N/A #N/A #N/A 7 583.33 #N/A 420 #N/A #N/A #N/A 8 641.67 #N/A 381.82 #N/A #N/A #N/A 9 700 5 350 350 25000 25700 10 758.33 5 323.08 379.17 25000 25702.24 11 816.67 5 300 408.33 25000 25708.33 12 875 5 280 437.5 25000 25717.5 13 933.33 5 262.5 466.67 25000 25729.17 14
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 991.67 5 247.06 495.83 25000 25742.89 15 1050 4.8 233.33 504 24000 24737.33 16 1108.33 4.8 221.05 532 24000 24753.05 17 1166.67 4.8 210 560 24000 24770 18 1225 4.8 200 588 24000 24788 19 1283.33 4.8 190.91 616 24000 24806.91 20 1341.67 4.8 182.61 644 24000 24826.61 21 1400 4.8 175 672 24000 24847 22 1458.33 4.8 168 700 24000 24868 23 1516.67 4.8 161.54 728 24000 24889.54 24 1575 4.8 155.56 756 24000 24911.56 Total cost, T c 233.33 583.33 933.33 1283.33 23400 23600 23800 24000 24200 24400 24600 24800 25000 25200 Total Cost vs Order Quantity Quantity Cost Enter the data in the shaded area. The minimum quantity is the minimum amount that needs to be ordered in order to get the price that is in the same column....
View Full Document

This note was uploaded on 11/24/2010 for the course QUANT DSCI taught by Professor B during the Fall '10 term at Fairleigh Dickinson.

Ask a homework question - tutors are online