USING EXCEL
Brooke Army Medical Center dispenses 250,000 bottles of brand name pharmaceutical annually. The optimal safety stock (which is on hand initially) is 1,000 bottles. Each bottle costs the center $10, inventory carrying costs are 30 percent, and the cost of placing an order with its supplier is $175. Orders can be placed only in multiples of 100 units.
a. What is the economic order quantity?
b. How many orders will be placed annually?