Please Show Excel Formula, Thanks

File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Calibri - 11 ab Wrap Text General F Normal Bad TIT % Cut Eg Copy Format Painter 4 Share AutoSum AY Fill - Sort & Find & Clear - Filter - Select Editing Paste BLU- -A- = = .00 C. % Merge & Center - Neutral Insert Delete Format Conditional Format as Good Formatting Table - Styles Clipboard Font Alignment Number Cells M18 X fie M N O P Q R S T V w Y z AA AB AC A B C D F G H K The ABC Semi Conductor Company purchase 40,000 units of mother board each year at a cost of $30.00 per unit. The ordering cost is $10.00 per order, and the annual holding cost is estimated at 15% of the unit value. 5 1. What is the EOQ for the ABC? 6 2. What is the total annual inventory cost for the mother board if it is ordered in economic 7 quantities? 8 3. How many orders should be placed each year? 9 10 11 D Demand 40000 units 12 H Holding Cost 4.5 $/unit/yr 13 S Ordering Cost 10 $/order 14 15 16 17 Case 1 Case 2 Case 3 Case 4 Case 5 Case 6 Case 7 18 Quantity 100 200 300 400 500 1000 2000 19 Average 20 Total Holding Cost 21 Total Ordering Cost 22 Total COST = 23 24 25 26 27 28 29 30 31 32 33 24 O