PR Ltd. sells two types of pen, ball pen and gel pen. Currently, the company is expecting to sell 6,000 units of ball pen along with 3,600 units of…
CA Intermediate · Cost and Management Accounting · RTP · May 2025
PR Ltd. sells two types of pen, ball pen and gel pen. Currently, the company is expecting to sell 6,000 units of ball pen along with 3,600 units of gel pen in the coming month. Other information as forecasted is provided below: Particulars Ball pen Gel pen Selling price (per unit) 150 100 Variable cost (per unit) 90 60 Contribution (per unit) 60 40 Fixed Costs
Suggested Answer and Working Notes:
(i) Economic order quantity (EOQ) as calculated by the company's managing director EOQ = √(2AO/C) Where: A = annual inventory requirement = 2,50,000 drumsO = ordering cost per order = 100C = carrying cost per unit per annum = 180 + (10% of 200) = 180 +20 = 200 EOQ = √(2 × 2,50,000 drums × 100 / 200) EOQ = √(5,00,00,000 / 200) EOQ = √2,50,000 EOQ = 500 units (ii) Comparison of total cost considering purchasing manager's bonus and supplier quantity discounts Particulars At EOQ of 500 units (₹) If considered quantity discount at 1000 units (₹) Ordering Cost [(2,50,000 units/500 units) × 100] 50,000 [(2,50,000 units/1000 units) × 100] 25,000 Carrying Cost {500 units/ 2 x [(180 + (10% of 200)]} 50,000 {1,000 units/ 2 x [(180 + (10% of 199.60)]} 99,980 Purchasing manager's bonus 10% of (₹ 2,00,000 - 1,00,000) 1,00,000 10% of (₹ 2,00,000 - 1,24,980) 1,24,980 Annual inventory cost 2,50,000 units x 200 5,00,00,000 2,50,000 units x 199.60 4,99,00,000 Total Cost 5,01,10,000 5,00,32,482 In above comparison, the potential savings from purchasing in bulk outweigh the higher carrying costs associated with holding more inventory. Thus, Catalist Ltd. may look forward to the quantity discount offered at 1,000 units.
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...