Theory question 109
Departmental AccountsThe following balances were extracted from the books of Bala Ventures for the year ended 31st December 2023.
Department — Amount (Le)
Stock – 1st January, 2023: Electronics 30,000; Clothing 25,000
Sales: Electronics 600,000; Clothing 400,000
Purchases: Electronics 300,000; Clothing 200,000
Carriage inwards 1,500
Carriage outwards 10,250
Advertising 8,400
Selling expenses 12,000
Salaries 23,000
Rates 14,200
Repairs 7,320
Electricity 45,000
Cleaning 60,000
Discounts allowed 4,300
Discounts received 2,500
Sundry expenses 16,800
Stationery 25,820
Stock – 31st December 2023: Electronics 18,000; Clothing 12,000
Additional information:
Expenses are to be apportioned between the departments as follows: (i) Proportionate to purchases: carriage inwards, discounts received. (ii) Proportionate to sales: carriage outwards; advertising; selling expenses; discounts allowed. (iii) Total floor area occupied by electronics department is 3/5 and clothing department is 2/5. (iv) Electricity and cleaning expenses are to be apportioned on the basis of floor area occupied. (v) Other expenses are to be apportioned equally.
You are required to prepare Departmental, Trading, Profit and Loss Account for the year ended 31st December, 2023. (Note: Total Column is not required)
Show the model answer
Purchases, sales and floor area all split 3:2 (Electronics : Clothing); salaries, rates, repairs, sundry expenses and stationery split equally.
Trading (Le) — Electronics | Clothing:
Opening stock 30,000 | 25,000; Purchases 300,000 | 200,000; Carriage inwards 900 | 600; Less closing stock 18,000 | 12,000; Cost of sales 312,900 | 213,600
Sales 600,000 | 400,000; Gross profit 287,100 | 186,400
Add discounts received 1,500 | 1,000 = 288,600 | 187,400
Expenses — Electronics | Clothing:
Carriage outwards 6,150 | 4,100; Advertising 5,040 | 3,360; Selling expenses 7,200 | 4,800; Discounts allowed 2,580 | 1,720; Electricity 27,000 | 18,000; Cleaning 36,000 | 24,000; Salaries 11,500 | 11,500; Rates 7,100 | 7,100; Repairs 3,660 | 3,660; Sundry expenses 8,400 | 8,400; Stationery 12,910 | 12,910
Total expenses 127,540 | 99,550
Net profit: Electronics Le 161,060; Clothing Le 87,850
Apportion each expense first in a working table, then build the two columns side by side.