SVS Limited manufactures a single product 'A1'. The company has estimated its quarter-wise sales for the next year as follows: Quarter I II III IV…
CA Intermediate · Cost and Management Accounting · PYQS · September 2025
SVS Limited manufactures a single product 'A1'. The company has estimated its quarter-wise sales for the next year as follows: Quarter I II III IV Sales (Units) 72,000 90,000 99,000 1,08,000 In the beginning of the year, the opening stock of finished goods is 14,400 units and the company expects to maintain the closing stock of finished goods at 29,400 units at the end of the year. The production pattern in each quarter is based on 80% of the sales of the current quarter and 20% of the sales of the next quarter. The company maintains this 20% of sales of next quarter as closing stock of current quarter. The opening stock of raw materials in the beginning of the year is 24,000 kgs and the closing stock at the end of the year is required to be maintained at 12,000 kgs. Each unit of finished output requires 2 kgs of raw material. The production time required to produce one unit of product 'A1' is 5 hours. During the production, the product uses two machines as under: Product Machine A Machine B Total A1 2 hours 3 hours 5 hours Machine A requires 100 hours of maintenance after a use of 5000 hours and Machine B requires 100 hours of maintenance after use of 3000 hours. Required: (i) Prepare quarter-wise Production Budget (in units) and the Raw Material Consumption budget (in quantity) for the next year. (ii) Calculate total machine hours including maintenance time required during the year for Machine A and Machine B to manufacture product 'A1'.
Suggested Answer and Working Notes:
(i) Production Budget (in units) Quarters Units Total Units I II III IV Sales 72,000 90,000 99,000 1,08,000 3,69,000 Production in current quarter (80% of the sale of current quarter) 57,600 72,000 79,200 86,400 Production for next quarter (20% of the sale of next quarter) 18,000 19,800 21,600 29,400 Total production 75,600 91,800 1,00,800 1,15,800 3,84,000 Raw material consumption budget in quantity Quarters I II III IV Total Units to be produced in each quarter: (A) 75,600 91,800 1,00,800 1,15,800 3,84,000 Raw material consumption p.u. (kg.): (B) 2 2 2 2 Total raw material consumption (Kg.): (A × B) 1,51,200 1,83,600 2,01,600 2,31,600 7,68,000 (ii) Machine A Machine B Units to be produced 3,84,000 3,84,000 Machine hours per unit 2 3 Total Hours 7,68,000 11,52,000 Maintenance Hours (Total Hours / 5000 * 100 for A; Total Hours / 3000 * 100 for B) 15,360 38,400 Total machine hours including maintenance 7,83,360 11,90,400
Topics: Budgets and Budgetary Control
Related Questions in this Topic
- (a) You have been asked to install a costing system in a manufacturing company. What practical difficulties will you exp...
- Apex Mobility Systems Ltd. manufactures smart airport luggage carts used in major international airports. The company op...
- ABC Ltd., a mid-sized manufacturing company, has been facing frequent cost overruns and profit fluctuations over the pas...
- The following figures are extracted from the books of a company: Budgeted overheads ₹ 20,000 (Fixed ₹ 12,000, Variable ...
- A business manufactures a single product and is preparing its production budget for the year ahead. It is estimated that...