Batch 23 3 7 11 15 18 5 25 1 2 4 13 19 21 22 10 12 16 6 20 24 8 9 14 17 Average Defects Defects Scissor Mechanics Key Brightness Stuck Keys Dead Connections Dusting 2 1 6 3 1 5 3 1 1 2 3 3 2 2 1 3 2 2 3 1 2 1 4 2 2 3 3 2 2 0 0 3 3 2 1 4 2 0 1 2 1 4 2 0 1 2 2 3 0 0 0 3 2 2 0 2 1 0 0 4 0 1 3 0 3 3 1 0 3 0 3 2 2 0 0 1 2 0 1 2 1 1 0 2 2 1 0 1 3 1 0 2 1 0 2 1 2 0 0 2 3 0 0 0 2 1 1 2 0 0 1 0 0 3 0 1 2 0 1 0 2 1 1 0 0 1.8 1.72 1.48 1.24 1.16 Total Defects 13 12 11 11 11 10 9 9 8 7 7 7 7 7 7 6 6 6 5 5 5 4 4 4 4 This chart isn't available in your version of Excel. Editing this shape or saving this workbook into a different file format will permanently break the chart. Order Cost Annual Holding Cost Per Box Purcahse 160 21 28000 Annual hold cost the annual inventory ordering costs each box cost EOQ Operation expects Annual holding cost Cost of placing an order 140 653.1973 28000 21 160 Economic Order Quantity 653.1973 Annual Holding Costs Average Inventory Level 6858.571 326.5986 Annual Inventory Ordering Cost 6858.571 Annual Orders 42.86607 Total Inventory Co 100 150 200 250 300 350 400 450 500 550 600 650 700 750 800 850 900 950 1000 1050 $ 588,000.00 dering costs $ 3,920,160.00 Total Inventory Costs 13717.1425595858 total inventory costs 12 10 costs 8 6 4 2 0 0 200 400 600 order quantity 800 1000 1200