Morgan Ltd is a retailer of Juice barrels. The company has an annual demand of 74,000 barrels. The barrels cost $20 each. Fresh supplies can be obtained immediately but ordering cost and the cost of carriage inwards are $300 per order. The annual holding cost of holding one barrel in inventory is estimated to be $2. The economic order quantity has been calculated to be 7,000 x 12 barrels.
The suppliers introduce a quantity discount of 3% (.97) on orders of at least 9,000 barrels and 4% on orders of at least 10,000 barrels.
Calculate to determine whether the least cost order quantity is still the EOQ of 7,000 barrels
Solution:
Re-calculate the EOQ by applying a discount:
EOQ =
9000 barrels = 0.97
10,000 barrels and above = 0.96
Use discount of 0.97 for EOQ:
EOQ = units
Derive total costs:
Total costs = Ordering costs + Holding costs + Inventory costs
Ordering costs (1070) =
Ordering costs (9000) =
Ordering costs (10,000) =
Holding costs (1,070) =
Holding costs (9,000) =
Holding costs (10,000) =
Inventory costs (1,070) =
Inventory costs (9,000) =
Inventory costs (10,000) =
Total costs (1) = 20,748 + 21,400 + 1,480,000 = 1,522,148
Total costs (2) = 2,466 + 174,600 + 1,435,600 = 1,612,666
Total costs (3) = 2,220 + 192,000 + 1,420,800 = 1,615,020
The least cost order quantity, the EOQ = 1,070 barrels
Comments