From the following information provided, you are required to calculate the working capital requirement for the year for the company. Present your calculation in a Tabular Form: (i) Annual Sales ₹46.80 lakhs; 78,000 units

CS Professional · Financial, Treasury and Forex Management · PYQS · June 2019
From the following information provided, you are required to calculate the working capital requirement for the year for the company. Present your calculation in a Tabular Form: (i) Annual Sales ₹46.80 lakhs; 78,000 units; 25% Cash Sales and balance on credit (ii) Raw Material Cost: 60% of sales value (iii) Labour Cost: ₹6 per unit (iv) Variable Overheads: ₹1 per unit (v) Fixed Overheads: ₹5,00,000 (including ₹1,10,000 as depreciation) (vi) Budgeted stock levels: Raw Materials: 3 weeks; Work-in-progress: 1 week (Material 100%, Labour and Overheads 50%); Finished goods: 2 weeks (vii) Finished goods will be valued at total cost. (viii) Debtors are allowed credit for 4 weeks. (ix) Creditors allow 4 weeks credit. (x) Wages are paid bimonthly i.e. by the 3rd week and by the 5th week for the 1st & 2nd weeks and the 3rd & 4th weeks respectively. (xi) Time lag in payment of overheads: 2 weeks (xii) Cash-in-hand required: ₹50,000 (xiii) It is assumed that production is carried on evenly throughout the year and wages and overheads accrue similarly. (xiv) Calculation to be based on 52 weeks in a year.

Answer & Explanation:

Statement of Costs and price per units Amount in ₹ Selling Price: ₹46,80,000 / 78,000 units 60 Raw materials: 60% of ₹60 36 Labour Cost 6 Variable Overheads 1 Fixed Overheads excluding depreciation (₹5,00,000 - ₹1,10,000) / 78,000 units 5 Total Cost excluding depreciation 48 Statement showing Working Capital Requirement Particulars Duration (weeks) Total (units) Cost per unit (₹) Total Cost (₹) Current Assets Raw Material 3 4500¹ 36 1,62,000 Work in progress 1 1500 42² 63,000 Finished Goods 2 3000 48 1,44,000 Debtors 4 4500³ 48 2,16,000 Cash In Hand 50,000 Total (A) 6,35,000 Current Liabilities Wages Due 2 3000 6 18,000 Creditors 4 6000⁴ 36 2,16,000 Overheads due 2 3000 6 18,000 Total (B) 2,52,000 Net Working Capital (A-B) 3,83,000 Notes: Element of Cost in units/week = 78,000 units / 52 weeks = 1,500 units/week Raw Material = 1500 units x 3 week = 4500 units Work in Progress: (Raw material) 100% = ₹36 Labour and Overhead (50%) = ₹6 + ₹1 + ₹5 = ₹12 * 50% = ₹6 Total WIP cost per unit = ₹36 + ₹6 = ₹42 Debtors: 78,000 units × 0.75 × 4/52 = 4500 units Creditors (R.M) 78,000 units x 4/52 = 6000 units Since, the wages are paid bimonthly, wages due will be for 2 weeks. Note: The profits are ignored while calculating the working Capital Requirements and it is calculated on cash cost basis. However, it may be calculated on 'Total Approach' Basis subject to the mentioning of assumption as footnote.

Topics: Working Capital Management

Open in Interactive Practice Hub · Full Practice Hub · Chapter Weightage · More in this subject

Related Questions in this Topic