The below information for Lever Ltd is provided on annual basis: Sales at 3 months credit 48,00,000 Materials consumed (suppliers extend 2 months…
CA Intermediate · Financial Management and Strategic Management · MTP · May 2024
The below information for Lever Ltd is provided on annual basis: Sales at 3 months credit 48,00,000 Materials consumed (suppliers extend 2 months credit) 12,00,000 Wages paid (one month lag in payment) 9,60,000 Cash manufacturing expenses (paid on month in arrear) 12,00,000 Administrative expense (one month lag in payment) 3,60,000 Sales promotion expense (paid monthly in advance) 1,20,000 The Company sells its products at a gross profit of 20%. The Company keeps two months stock of raw materials and two months stock of finished goods. Depreciation is considered as a part of cost of production. Cash balance is retained at 1,00,000, Assuming a 15% margin, COMPUTE the working capital requirements of the Company on cash cost basis. Ignore work-in progress.
Suggested Answer and Working Notes:
Working Notes: (i) Computation of Annual Cash Cost of Production Material consumed 12,00,000 Wages 9,60,000 Manufacturing expenses 12,00,000 Total cash cost of production 33,60,000 (ii) Computation of Annual Cash Cost of Sales: Total Cash cost of production as in (i) above 33,60,000 Administrative Expenses 3,60,000 Sales promotion expenses 1,20,000 Total cash cost of sales 38,40,000 Add: Gross Profit @ 20% on sales (25% on cost of sales) 9,60,000 Sales Value 48,00,000 Statement of Working Capital requirements (cash cost basis) (₹) (₹) A. Current Assets Inventory: - Raw materials 12,00,000 × 2 months / 12 months = 2,00,000 - Finished Goods 33,60,000 × 2 months / 12 months = 5,60,000 Receivables (Debtors) 38,40,000 × 3 months / 12 months = 9,60,000 Sales Promotion expenses paid in advance 1,20,000 × 1 month / 12 months = 10,000 Cash balance 1,00,000 18,30,000 B. Current Liabilities: Payables: - Creditors for materials 12,00,000 × 2 months / 12 months = 2,00,000 Wages outstanding 9,60,000 × 1 month / 12 months = 80,000 Manufacturing expenses outstanding 12,00,000 × 1 month / 12 months = 1,00,000 Administrative expenses outstanding 3,60,000 × 1 month / 12 months = 30,000 4,10,000 Net working capital (A - B) 14,20,000 Add: Safety margin @ 15% 2,13,000 Total Working Capital requirements 16,33,000
Topics: Part-A: Financial Management
Related Questions in this Topic
- Distinguish between Strategic Planning and Operational Planning.
- Cura-Stents India Ltd., a manufacturer of high-precision cardiac stents, follows stringent international quality and ste...
- EcoBuild Materials Ltd. manufactures specialised construction materials. One of its business divisions has been evaluate...
- Elite Motors Ltd., a luxury automobile manufacturer, exclusively targets ultra-high-net-worth individuals by offering pr...
- Write a short note on the key strategic drivers of an organization.