Calculations Shown In Excel file





Exercise 11.1: A product used in a laboratory of the hospital costs $60 to order, and its carrying cost per item per week is one cent. Demand for the item is six hundred units weekly. The lead time is three weeks and the purchase price is $0.60. 
1. What is the economic order quantity for this item? 
2. What is the length of an order cycle? 
3. Calculate the total weekly costs? 
4. What is the investment cost for this item? 
5. If ordering costs increase by 50 percent, how would that affect Economic Order Quantity (EOQ)? 
6. What would be the reorder point for this item if no safety stocks were kept? 
7. What would be the reorder point if one thousand units were kept as safety stock?

Exercise 11.6: SURGERY ASSOCIATES, a local surgery practice group, orders implants from device manufacturers. Order quantities for ten items have been determined based on the past two years of usage. Other relevant information from the practice’s inventory records is depicted in Table EX 11.6. The practice is functional for fifty-two weeks a year. 
1. Perform basic EOQ analysis for each item. 
2. Classify the implant inventory items according to the ABC analysis. 
3. Calculate the yearly inventory management cost. 
4. Determine the investment cost (per cycle) for each item