In: Finance
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 |
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 | |||