Answer Question with EXCEL and show formula

The reorder point for BB-1 is 60 sets. What level of safety stock should be maintained for BB-1?

The optimal quantity of safety stock which minimizes the expected total cost is ? sets (enter your response as a whole number).

Score: 0 of 1 pt 38 of 39 (38 complete) HW Score: 94.05%, 79 of 84 pts X Problem 12.45 Question Help Mr. Beautiful, an organization that sells weight training sets, has an ordering cost of $35 for the BB-1 set (BB-1 stands for Body Beautiful Number 1). The carrying cost for BB-1 is $5 per set per year. To meet demand, Mr. Beautiful orders large quantities of BB-1 5 times a year. The stockout cost for BB-1 is estimated to be $40 per set. Over the past several years, Mr. Beautiful has observed the following demand during the lead time for BB-1: Demand During Lead Time 0.1 0.2 0.2 0.2 0.2