Question: A local surgery practice group orders implants from device manufacturers. Order quantities for 1 0 items have been determined based on the past two years

A local surgery practice group orders implants from device manufacturers. Order quantities for 10 items have been determined based on the past two years of usage. Other relevant information from the practices inventory records is in Implants.xlsx. Assume the practice is open 52 weeks a year.
Item No. Annual Demand Item Price Annual Carrying Rate Ordering Cost Item Carrying Cost
1104 $2,225.000.12 $6.00267
2260 $5,000.000.1 $5.00500
3728 $3,550.000.08 $12.00284
41248 $1,205.000.12 $28.00145
5104 $11,100.000.02 $18.00222
61040 $1,500.000.2 $32.00300
7780 $1,900.000.11 $50.00209
8884 $3,700.000.09 $12.00333
9780 $6,400.000.02 $35.00128
10520 $2,700.000.05 $12.00135
a) Perform an EOQ analysis for each item.
b) Classify the implant inventory items according to the A-B-C analysis.
c) What is the yearly inventory management cost?
d) What is the investment cost (per cycle) for each item?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!