Question

A small manufacturing firm produces one product. The budgeted sales for the month of January 2021

are for 10,000 units as a selling price of Sh. 2,000 per unit. Other details are as follows;
1. Two components of input are used in the production of one unit of output.
Component (Input) Number Unit cost of each component
X 5 20
W 3 10
2. Stocks at the beginning of the month are budgeted as follows;
4000 units of finished goods at a unit cost of sh. 1,050 per unit.
Component X: 16,000 units at a cost of Sh. 20.
Component W: 9,600 units at a cost of Sh. 10.
3. Production of each unit requires the following labour hours.
Department Hours per Unit Labour rate per hour
Production 4 100
Finishing 4 140
4. Factory overhead is absorbed into units cost on the basis of direct labour hours. The budgeted
factory overhead for the month is Sh. 1,920,000.
5.The administration, selling and distribution overhead for the month is budgeted at Sh.5,500,000.
6.The company plans a reduction of 50% in quantity of finished stock at the end of the month and
an increase of 30% in the quantity of each input component.
Required:
a)For the month of January 2021
i. Production quantity budget (3 marks)
ii. Materials quantity and purchase budget (4 marks)
iii. Direct Labor budget (3 marks)
b)The budgeted profit and loss account (5 marks)

Answer 1

Answer:a) Budgeted Production Quantity:Budgeted Sales = 10,000 unitsAdd: Desired Closing Stock = (10,000/2) = 5,000 unitsTotal Units Required = 15,000 unitsLess: Opening Stock = 4,000 unitsUnits to be produced = 11,000 unitsi. Production Quantity Budget = 11,000 unitsii. Materials Quantity and Purchase Budget:Component X:Units Required = (11,000 x 5) = 55,000 unitsAdd: Desired Closing Stock = (16,000 x 1.3) = 20,800 unitsTotal Units Required = 75,800 unitsLess: Opening Stock = 16,000 unitsUnits to be purchased = 59,800 unitsTotal Cost = (59,800 x 20) = Sh. 1,196,000Component W:Units Required = (11,000 x 3) = 33,000 unitsAdd: Desired Closing Stock = (9,600 x 1.3) = 12,480 unitsTotal Units Required = 45,480 unitsLess: Opening Stock = 9,600 unitsUnits to be purchased = 35,880 unitsTotal Cost = (35,880 x 10) = Sh. 358,800iii. Direct Labor Budget:Department Production Finishing Total

Hours 44,000 44,000 88,000

Rate 100 140

Total Cost = (44,000 x 100) + (44,000 x 140) = Sh. 15,840,000b) Budgeted Profit and Loss Account:Sales Revenue = (10,000 x 2,000) = Sh. 20,000,000Less: Cost of Goods Sold:Direct Materials = (1,196,000 + 358,800) = Sh. 1,554,800Direct Labor = Sh. 15,840,000Factory Overhead = Sh. 1,920,000Total Cost of Goods Sold = Sh. 19,314,800Gross Profit = (Sales Revenue - Cost of Goods Sold) = Sh. 685,200Less: Selling and Distribution Overhead = Sh. 5,500,000Net Loss = (Selling and Distribution Overhead - Gross Profit) = Sh. 4,814,800

Step-by-step explanation: