Question

In: Finance

Brooke Army Medical Center dispenses 250,000 bottles of brand name pharmaceutical annually. The optimal safety stock...

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.

a. What is the economic order quantity?

b. What is the maximum inventory for this medication?

c. What is the center's average inventory of bottles of this medication?

d. How often must the center order (in days)?

ANSWER

Ordering costs

F

$175

Annual usage in units

S

250,000

Annual carrying costs

C

30%

Purchase price per bottle

P

$10.00

Days per year

W

360

Safety stock

SF

1,000

Solutions

Expert Solution

Economic Order Quantity =(2*Annual Demand*Cost of placing 1 order/Cost of handing per unit per year)^(1/2)
Annual Demand           250,000
Cost of placing 1 order $         175.00
Storage cost $             3.00 10*30%
Solution to 1
Putting all these factors in EOQ formula =(2*250000*175/3)^(1/2)
Economic Order quantity               5,401
Total No of orders =250000/5400.61724867322                46
So total of 46 orders will be placed
Solution to 2
Safety stock           1,000
Order received           5,401
maximum inventory           6,401
Solution to 3
Average Inventory =5400.62/2           2,701
Safety stock           1,000
Average inventory carried           3,701
Annual ordering cost Total no of orders * order cost per unit
=46*175 $ 8,100.93
Annual holding cost
=3701*3 $11,101.50
Total Cost =8100.93+11101.5 $19,202.43
Solution to 4
No of days in year 365
Lead days 0
Safety stock 1000
Average daily use= Annual demand/No of days
Average daily use= =250000/365
Average daily use= 685
Reorder point= (Average daily usage rate * Lead time) + Safety stock
Reorder point= =(685*0) + 1000
Reorder point= 1000

Related Solutions

Brooke Army Medical Center dispenses 250,000 bottles of brand name pharmaceutical annually. The optimal safety stock...
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? Please show work in Excel!
Ascension Health dispenses 325,000 bottles of brand name pharmaceutical annually. The optimal safety
Ascension Health dispenses 325,000 bottles of brand name pharmaceutical annually. The optimal safety stock (which is on hand initially) is 5,000 bottles. Each bottle costs the center $10, inventory carrying costs are 25%, and the cost of placing an order with its supplier is $200. What is the economic order quantity? Format is x,xxx (number only) What is the maximum inventory for this medication? Format is x,xxx.How often must the center order (in days)? Format is xx days or x...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT