AutoSave Off HB V Exam 2 Version 1 Workbook - Excel File Home Insert Draw Page Layout Formulas Data Review E5 > fx Details given in the question A B C D E F G H 2 Question #1 3 4 5 Weekly Demand Demand [D] Unit costo Speakers per year 6 7 Setup cost (A) question Details given in the 8 Holding cost [h] 9 Lot Size [Q] 10 New Demand Speakers per year 11 12 Parta Lot Size [Q] 13 Speakers 14 15 16 Optimum Annual Cost 17 Part b 18 19 20 21 Part 22 23 24 Part d 25 New Lot Size Annual Cost 26 27 Parto Ratio of actual to optimum Problem #1 Question #2 Ready Question #3 + Type here to search Please use this the Exam 2 Version 1 Workbook.xlsx Audio kit Inc. would like to compute its optimal carrying cost of inventory based on economic order quantity (EOQ) model. In order to make their 12 inch speakers the setup costs is $100, and sales of the speakers are priced in bulk at a group cost of $71.25 for four. The unit holding costs is 35% of the unit sales cost and the average annual demand is 4552. Assuming a year is 42 weeks, find the following: a. Determine the optimal number filters that need to be ordered each time an order is placed? b. What is the optimal annual yearly holding costs? c. An error has been made and you demand has been determined to be 150 speakers per week. Determine the new lot size? d. Determine the annual yearly cost based onTthe new demand and lot size you obtained in part C? e Mathematically compare your answers from parts b and d? Explain from the standpoint of sensitivity to changes in lot size