We read your photo as:

The following balances were extracted from the books of Bala Ventures for the year ended 31st December 2023: You are required to prepare Departmental, Trading, Profit and Loss Account for the year ended 31st December 2023. (Note: Total Column is not required)

Accounting

ScanSolve AI Answer

Answer

161,060\textbf{161,060}

87,850\textbf{87,850}

Here is the Departmental Trading, Profit and Loss Account for Bala Ventures for the year ended 31st December 2023.

First, we apportion the expenses based on the additional information:

1. Apportionment of Expenses

  • Purchases Ratio: Electronics : Clothing = Le 300,000 : Le 200,000 = 3 : 2
  • Sales Ratio: Electronics : Clothing = Le 600,000 : Le 400,000 = 3 : 2
  • Floor Area Ratio: Electronics : Clothing = 35\frac{3}{5} : 25\frac{2}{5} = 3 : 2
  • Equal Ratio: Electronics : Clothing = 1 : 1
ExpenseTotal (Le)BasisElectronics (Le)Clothing (Le)
Carriage inwards1,500Purchases (3:2)1,500×35=9001,500 \times \frac{3}{5} = 9001,500×25=6001,500 \times \frac{2}{5} = 600
Discounts received2,500Purchases (3:2)2,500×35=1,5002,500 \times \frac{3}{5} = 1,5002,500×25=1,0002,500 \times \frac{2}{5} = 1,000
Carriage outwards10,250Sales (3:2)10,250×35=6,15010,250 \times \frac{3}{5} = 6,15010,250×25=4,10010,250 \times \frac{2}{5} = 4,100
Advertising8,400Sales (3:2)8,400×35=5,0408,400 \times \frac{3}{5} = 5,0408,400×25=3,3608,400 \times \frac{2}{5} = 3,360
Selling expenses12,000Sales (3:2)12,000×35=7,20012,000 \times \frac{3}{5} = 7,20012,000×25=4,80012,000 \times \frac{2}{5} = 4,800
Discounts allowed4,300Sales (3:2)4,300×35=2,5804,300 \times \frac{3}{5} = 2,5804,300×25=1,7204,300 \times \frac{2}{5} = 1,720
Electricity45,000Floor Area (3:2)45,000×35=27,00045,000 \times \frac{3}{5} = 27,00045,000×25=18,00045,000 \times \frac{2}{5} = 18,000
Cleaning60,000Floor Area (3:2)60,000×35=36,00060,000 \times \frac{3}{5} = 36,00060,000×25=24,00060,000 \times \frac{2}{5} = 24,000
Salaries23,000Equal (1:1)23,000×12=11,50023,000 \times \frac{1}{2} = 11,50023,000×12=11,50023,000 \times \frac{1}{2} = 11,500
Rates14,200Equal (1:1)14,200×12=7,10014,200 \times \frac{1}{2} = 7,10014,200×12=7,10014,200 \times \frac{1}{2} = 7,100
Repairs7,320Equal (1:1)7,320×12=3,6607,320 \times \frac{1}{2} = 3,6607,320×12=3,6607,320 \times \frac{1}{2} = 3,660
Sundry expenses16,800Equal (1:1)16,800×12=8,40016,800 \times \frac{1}{2} = 8,40016,800×12=8,40016,800 \times \frac{1}{2} = 8,400
Stationery25,820Equal (1:1)25,820×12=12,91025,820 \times \frac{1}{2} = 12,91025,820×12=12,91025,820 \times \frac{1}{2} = 12,910

2. Departmental Trading, Profit and Loss Account

Departmental Trading, Profit and Loss AccountElectronics (Le)Clothing (Le)for the year ended 31st December 2023Trading AccountOpening Stock (1st Jan 2023)30,00025,000Purchases300,000200,000Carriage Inwards900600Cost of Goods Available for Sale330,900225,600Less: Closing Stock (31st Dec 2023)(18,000)(12,000)Cost of Goods Sold312,900213,600Sales600,000400,000Gross Profit c/d287,100186,400Total600,000400,000Profit and Loss AccountGross Profit b/d287,100186,400Add: Discounts Received1,5001,000Total Income288,600187,400Less: ExpensesCarriage Outwards6,1504,100Advertising5,0403,360Selling Expenses7,2004,800Discounts Allowed2,5801,720Electricity27,00018,000Cleaning36,00024,000Salaries11,50011,500Rates7,1007,100Repairs3,6603,660Sundry Expenses8,4008,400Stationery12,91012,910Total Expenses127,54099,550Net Profit161,06087,850Total288,600187,400\begin{array}{|l|r|r|} \hline \textbf{Departmental Trading, Profit and Loss Account} & \textbf{Electronics (Le)} & \textbf{Clothing (Le)} \\ \textbf{for the year ended 31st December 2023} & & \\ \hline \textbf{Trading Account} & & \\ \text{Opening Stock (1st Jan 2023)} & 30,000 & 25,000 \\ \text{Purchases} & 300,000 & 200,000 \\ \text{Carriage Inwards} & 900 & 600 \\ \text{Cost of Goods Available for Sale} & \textbf{330,900} & \textbf{225,600} \\ \text{Less: Closing Stock (31st Dec 2023)} & (18,000) & (12,000) \\ \text{Cost of Goods Sold} & \textbf{312,900} & \textbf{213,600} \\ & & \\ \text{Sales} & 600,000 & 400,000 \\ \text{Gross Profit c/d} & \textbf{287,100} & \textbf{186,400} \\ \hline \textbf{Total} & \textbf{600,000} & \textbf{400,000} \\ \hline & & \\ \textbf{Profit and Loss Account} & & \\ \text{Gross Profit b/d} & 287,100 & 186,400 \\ \text{Add: Discounts Received} & 1,500 & 1,000 \\ \text{Total Income} & \textbf{288,600} & \textbf{187,400} \\ & & \\ \text{Less: Expenses} & & \\ \text{Carriage Outwards} & 6,150 & 4,100 \\ \text{Advertising} & 5,040 & 3,360 \\ \text{Selling Expenses} & 7,200 & 4,800 \\ \text{Discounts Allowed} & 2,580 & 1,720 \\ \text{Electricity} & 27,000 & 18,000 \\ \text{Cleaning} & 36,000 & 24,000 \\ \text{Salaries} & 11,500 & 11,500 \\ \text{Rates} & 7,100 & 7,100 \\ \text{Repairs} & 3,660 & 3,660 \\ \text{Sundry Expenses} & 8,400 & 8,400 \\ \text{Stationery} & 12,910 & 12,910 \\ \text{Total Expenses} & \textbf{127,540} & \textbf{99,550} \\ & & \\ \text{Net Profit} & \boxed{\textbf{161,060}} & \boxed{\textbf{87,850}} \\ \hline \textbf{Total} & \textbf{288,600} & \textbf{187,400} \\ \hline \end{array}
Was this helpful?

Try one yourself

A new problem that tests the same skill.

Still stuck on this one?

Ask a follow-up, and the answer starts from this question.

Got a different question?Ask your own question
Handwritten step-by-step solution preview

Handwritten Step-by-Step Solution

Get this as a handwritten image on WhatsApp — like a tutor wrote it for you.

Try on WhatsApp