O. Problem Set Q Search Sheet Home Insert Page Layout Formulas Data Review View 3+ Share a Insert - WA 49 * Delete - .no .00 Cell Styles Format Sort Filter L L N 0 Arial - 10 A- A Eto Wrap Text Ceneral 17 2. Paste B I A A Merge & Center $. % Conditional Format Formatting us Table K20 fx A B D E F G H 1 J K 1 Problem 4 4 2 Bill Bunting buys boxes of baby bibs for Brianna's Boutique. But Bill berates bad business buying and is 3 constantly consumed with capitalizing on concepts that control costs. Bill discovered desirable discounts displayed 4 on the distributor's daily dispatch and decides to devise a discount disposition. Analyze to obtain the 5 optimal order amount B Demand 952 per year 7 Holding rate 60% of the value of the item, per year 8 Order cost $25 per order 9 Regular price $7.99 per bib 10 Discounts 10% for 100 or more bibs 11 18% for 400 or more bibs 12 13 14 Range 15 Price LOW High EOQ Adjusted TC 16 $7.99 0 99 17 $7.19 100 399 18 $6.55 400 unlimited 19 20 a. what is the optimal number of detectors to order at a time? 21 22 b. what will be the annual total cost, including the cost of the items themselves if this is the order quantity. 23 24 25 26 27 28 29 30 Summary 11 #2 #5 A6 A 7 + #4 Reaciy IF 140%