Ani Ltd. uses 6 kg. of Material 'EXE' to produce 1 finished unit of Product 'EME'. The current demand of Product ‘EME' is 16,000 units quarterly. 1…
CA Intermediate · Cost and Management Accounting · RTP · January 2025
Ani Ltd. uses 6 kg. of Material 'EXE' to produce 1 finished unit of Product 'EME'. The current demand of Product ‘EME' is 16,000 units quarterly. 1 kg. of Material ‘EXE' costs - 40. The cost relating to quotations, documentation works, employee cost directly attributable to the procurement of material, every-time the order is made, is 2,000. The cost of fund invested in inventories, cost of storage, insurance cost, etc. is estimated to be 15% per annum of average inventory. You are required the following: (i) CALCULATE the Economic Order Quantity for Material ‘ΈΧΕ΄. (ii) COMMENT, should Ani Ltd. accept an offer of 2.5% discount by the supplier of Material 'EXE', if supply of the annual requirement of the Material is made in 4 equal installments?
Suggested Answer and Working Notes:
Annual demand of material 'EXE' = 16,000 units (per quarter) x 4 (No. of Quarter in a year) x 6 kg. (for every finished product) = 3,84,000 kg. (i) Calculation of Economic Order Quantity (EOQ) for material 'EXE' EOQ = (2 x Annual demand x ordering cost) / (Carrying cost per unit per annum) = (2 x 3,84,000 kg. x 2,000) / (40x 15%) = 16,000 kg. (ii) Evaluation of Cost under different options of 'order quantity'. Particulars When EOQ is ordered When discount of 2.5% is accepted and supply is in 4 equal installments Order size 16,000 kg. 96,000 kg. No. of orders 24 (3,84,000 kg. / 16,000 kg.) 4 (3,84,000 kg. / 96,000 kg.) Purchase Cost per kg. 40 39 {40 - (40x 2.5%)} Total Purchase Cost (A) 1,53,60,000 (3,84,000 kg. x 40) 1,49,76,000 (3,84,000 kg. x 39) Ordering Cost (B) 48,000 (24 orders x 2,000) 8,000 (4 orders x 2,000) Carrying Cost (C) 48,000 (16,000 kg. / 2 x 15% x 40) 2,80,800 (96,000 kg. / 2 x 15% x 39) Total Cost (A + B + C) 1,54,56,000 1,52,64,800 COMMENT – The total cost is lower if Ani Ltd. accept an offer of 2.5% discount by the supplier, when supply of the annual requirement of material 'EXE' is made in 4 equal installments.
Topics: Material Cost
Related Questions in this Topic
- M/s Esha Materials Private Limited produces a product which names "ESS". The consumption of raw material for the product...
- Vaibhav Industries Ltd. uses chemical-A in one of its finished products. The chemical-A is purchased from a vendor outsi...
- Himalayan Bakers Pvt. Ltd., a mid-sized bakery chain headquartered in Dehradun, produces its signature product "Multigra...
- Aarav Industrial Resins Pvt. Ltd., headquartered in Ghaziabad, is engaged in manufacturing specialty chemicals used in t...
- Hari Udyog is a small-scale manufacturing unit producing a single product X using two raw materials PK and BK in the inp...