Chart Range and Increment Values Increment based on: "X-Axis Range Q" "Y-Axis Range Total Cost" 1000 0 $24,000.00 2400 $26,000.00 Increment by: -240 $(200.00) Cost Curve Data Order Quantity, Q Unit Cost Setup Cost Holding Cost Total Unit Cost Total Costs 1 333 $5.00 $735.00 $166.67 $25,000.00 $25,901.67 2 417 $5.00 $588.00 $208.33 $25,000.00 $25,796.33 3 500 $5.00 $490.00 $250.00 $25,000.00 $25,740.00 4 583 $5.00 $420.00 $291.67 $25,000.00 $25,711.67 5 667 $5.00 $367.50 $333.33 $25,000.00 $25,700.83 6 750 $5.00 $326.67 $375.00 $25,000.00 $25,701.67 7 833 $5.00 $294.00 $416.67 $25,000.00 $25,710.67 8 917 $5.00 $267.27 $458.33 $25,000.00 $25,725.61 9 1000 $4.80 $245.00 $480.00 $24,000.00 $24,725.00 10 1083 $4.80 $226.15 $520.00 $24,000.00 $24,746.15 11 1167 $4.80 $210.00 $560.00 $24,000.00 $24,770.00 12 1250 $4.80 $196.00 $600.00 $24,000.00 $24,796.00 13 1333 $4.80 $183.75 $640.00 $24,000.00 $24,823.75 14 1417 $4.80 $172.94 $680.00 $24,000.00 $24,852.94 15 1500 $4.80 $163.33 $720.00 $24,000.00 $24,883.33 16 1583 $4.80 $154.74 $760.00 $24,000.00 $24,914.74 17 1667 $4.80 $147.00 $800.00 $24,000.00 $24,947.00 18 1750 $4.80 $140.00 $840.00 $24,000.00 $24,980.00 19 1833 $4.80 $133.64 $880.00 $24,000.00 $25,013.64 20 1917 $4.80 $127.83 $920.00 $24,0

Chart Range and Increment Values X-Anxis Range -Amis Range Increment based on: Qa Total Cost 1000 o1s 24,000.00 2400/5 26,000.00 Increment by: -240] 5 (200.00) Cost Curve Data Order Quantity, @ Unit Cost Setup Cost Holding Cost = Total Unit Cost Total Costs 1 166.67 |S 25,000.00 25,901.67 2 208.33 )5 25,000.00 25,796.33 3 i 250.00] 5 25,000.00 25,740.00 5 667) 5 5.00 367.50] 5 333.33 |$ 25,000.00 25,700.83 6 25,701.67 917) 5 5.00 267.27 | 5 458.33 |5 25,000.00 25,725.61 3 4280.00 |S 24,000.00 24,725.00 10 520.00 |S 24,000.00 24,746.15 11 560.00 | 5 24,000.00 24,770.00 12 600.00 |5 24,000.00 24,796.00 13 640.00 |5 24,000.00 24,823.75 14 680.00 |5 24,000.00 24,852.94 16 1583| 5 4.80 154.74 | 5 760.00 | 5 24,000.00 24,914.74 17 24,947.00 15 1833|5 4.80 | 5 133.64 | 5 880.00 | 5 24,000.00 25,013.64 20 5 24,000.00 25,047.83 21 S 23,750.00 24,822.50 22 S 23,750.00 24,857.18 23 1,029.17 |S 23,750.00 24,892.24 24 1,068.75 |5 23,750.00 24,927.64 25 1,108.33 | 5 23,750.00 24,963.33 Figure 5 'Order Quantity Discount: Total Cost vs Order Quantity by Roussel $26,000.00 $75,600.00 $75,600.00 $25,400.00 $25,200.00 $25,000.00 $24,200.00 $24,600.00 $24,400.00 inoo Order Quantity (CO) 2000 Result Statements Note: Write result statements that concisely presents all of the information in arecommendation format. Answer the following questions for Range 2 1. What order quantity will minimize the total inventory? 2. What is the oder quantity? 3. What are the holding costs? 4. What is the order cost? . What are the unit costs? in 6. What is the total cost