The Milling Corp. has developed a new type of widget. The local distributor expe
ID: 2651762 • Letter: T
Question
The Milling Corp. has developed a new type of widget. The local distributor expects to increase his sales by 25% over the past year due to this new development. Last year's sales were $180,000 at a selling price of $115 per unit. A safety stock of 50 units has eliminated stockouts. The manager would like to cut costs as much as possible and comes to you for advice.
Warehouse Space $3.50 per unit
Material Handling $1.50 per unit
Insurance Premium $1.50 per unit
Total Ordering Cost $100 per order
a) What is the economic order quantity?
b) What is the amount of average inventory?
c) How many orders will be made per year?
d) What is the total cost of this inventory decision?
Explanation / Answer
1 C=Carrying cost per unit per year 100 F=Fixed cost per order 6.5 D=Demand in units per year 180000 EOQ=153 2 Total Cost per unit 107 Total Inventory cost 19,170,000 3 Sales after 25% 225,000 Total order 2,250 Total sales/Order cost 4 Total Cost per unit 107 Total Cost 23,957,175 Total unit sold (Minus 50) 224,950