Answer :
Certainly! Let's prepare the departmental Trading and Profit & Loss Account taking into consideration the closing stock at 10% of sales.
### Trading Account for the Year Ending
#### TV Department:
1. Opening Stock: 60,000
2. Purchases: 10,000
3. Sales: 120,000
4. Closing Stock: 10% of 120,000 = 12,000
Cost of Goods Sold (COGS):
[tex]\[ \text{COGS} = \text{Opening Stock} + \text{Purchases} - \text{Closing Stock} \][/tex]
[tex]\[ \text{COGS} = 60,000 + 10,000 - 12,000 = 58,000 \][/tex]
Gross Profit:
[tex]\[ \text{Gross Profit} = \text{Sales} - \text{COGS} \][/tex]
[tex]\[ \text{Gross Profit} = 120,000 - 58,000 = 62,000 \][/tex]
#### Cap Top Department:
1. Opening Stock: 10,000
2. Purchases: 75,000
3. Sales: 100,000
4. Closing Stock: 10% of 100,000 = 10,000
Cost of Goods Sold (COGS):
[tex]\[ \text{COGS} = \text{Opening Stock} + \text{Purchases} - \text{Closing Stock} \][/tex]
[tex]\[ \text{COGS} = 10,000 + 75,000 - 10,000 = 75,000 \][/tex]
Gross Profit:
[tex]\[ \text{Gross Profit} = \text{Sales} - \text{COGS} \][/tex]
[tex]\[ \text{Gross Profit} = 100,000 - 75,000 = 25,000 \][/tex]
#### Music System Department:
1. Opening Stock: 30,000
2. Purchases: 70,000
3. Sales: 60,000
4. Closing Stock: 10% of 60,000 = 6,000
Cost of Goods Sold (COGS):
[tex]\[ \text{COGS} = \text{Opening Stock} + \text{Purchases} - \text{Closing Stock} \][/tex]
[tex]\[ \text{COGS} = 30,000 + 70,000 - 6,000 = 94,000 \][/tex]
Gross Profit:
[tex]\[ \text{Gross Profit} = \text{Sales} - \text{COGS} \][/tex]
[tex]\[ \text{Gross Profit} = 60,000 - 94,000 = -34,000 \][/tex]
### Profit & Loss Account for the Year Ending
#### TV Department:
1. Gross Profit: 62,000
2. Direct Expenses: 20,200
3. Indirect Expenses: 6,000
Total Expenses:
[tex]\[ \text{Total Expenses} = \text{Direct Expenses} + \text{Indirect Expenses} \][/tex]
[tex]\[ \text{Total Expenses} = 20,200 + 6,000 = 26,200 \][/tex]
Net Profit:
[tex]\[ \text{Net Profit} = \text{Gross Profit} - \text{Total Expenses} \][/tex]
[tex]\[ \text{Net Profit} = 62,000 - 26,200 = 35,800 \][/tex]
#### Cap Top Department:
1. Gross Profit: 25,000
2. Direct Expenses: 14,500
3. Indirect Expenses: 5,000
Total Expenses:
[tex]\[ \text{Total Expenses} = \text{Direct Expenses} + \text{Indirect Expenses} \][/tex]
[tex]\[ \text{Total Expenses} = 14,500 + 5,000 = 19,500 \][/tex]
Net Profit:
[tex]\[ \text{Net Profit} = \text{Gross Profit} - \text{Total Expenses} \][/tex]
[tex]\[ \text{Net Profit} = 25,000 - 19,500 = 5,500 \][/tex]
#### Music System Department:
1. Gross Profit: -34,000
2. Direct Expenses: 7,100
3. Indirect Expenses: 3,000
Total Expenses:
[tex]\[ \text{Total Expenses} = \text{Direct Expenses} + \text{Indirect Expenses} \][/tex]
[tex]\[ \text{Total Expenses} = 7,100 + 3,000 = 10,100 \][/tex]
Net Profit:
[tex]\[ \text{Net Profit} = \text{Gross Profit} - \text{Total Expenses} \][/tex]
[tex]\[ \text{Net Profit} = -34,000 - 10,100 = -44,100 \][/tex]
### Summary:
- Closing Stock: {'TV': 12,000, 'Cap_top': 10,000, 'Music_System': 6,000}
- COGS: {'TV': 58,000, 'Cap_top': 75,000, 'Music_System': 94,000}
- Gross Profit: {'TV': 62,000, 'Cap_top': 25,000, 'Music_System': -34,000}
- Total Expenses: {'TV': 26,200, 'Cap_top': 19,500, 'Music_System': 10,100}
- Net Profit: {'TV': 35,800, 'Cap_top': 5,500, 'Music_System': -44,100}
In conclusion, the departmental results are as follows:
- TV: Net Profit of 35,800
- Cap Top: Net Profit of 5,500
- Music System: Net Loss of 44,100
### Trading Account for the Year Ending
#### TV Department:
1. Opening Stock: 60,000
2. Purchases: 10,000
3. Sales: 120,000
4. Closing Stock: 10% of 120,000 = 12,000
Cost of Goods Sold (COGS):
[tex]\[ \text{COGS} = \text{Opening Stock} + \text{Purchases} - \text{Closing Stock} \][/tex]
[tex]\[ \text{COGS} = 60,000 + 10,000 - 12,000 = 58,000 \][/tex]
Gross Profit:
[tex]\[ \text{Gross Profit} = \text{Sales} - \text{COGS} \][/tex]
[tex]\[ \text{Gross Profit} = 120,000 - 58,000 = 62,000 \][/tex]
#### Cap Top Department:
1. Opening Stock: 10,000
2. Purchases: 75,000
3. Sales: 100,000
4. Closing Stock: 10% of 100,000 = 10,000
Cost of Goods Sold (COGS):
[tex]\[ \text{COGS} = \text{Opening Stock} + \text{Purchases} - \text{Closing Stock} \][/tex]
[tex]\[ \text{COGS} = 10,000 + 75,000 - 10,000 = 75,000 \][/tex]
Gross Profit:
[tex]\[ \text{Gross Profit} = \text{Sales} - \text{COGS} \][/tex]
[tex]\[ \text{Gross Profit} = 100,000 - 75,000 = 25,000 \][/tex]
#### Music System Department:
1. Opening Stock: 30,000
2. Purchases: 70,000
3. Sales: 60,000
4. Closing Stock: 10% of 60,000 = 6,000
Cost of Goods Sold (COGS):
[tex]\[ \text{COGS} = \text{Opening Stock} + \text{Purchases} - \text{Closing Stock} \][/tex]
[tex]\[ \text{COGS} = 30,000 + 70,000 - 6,000 = 94,000 \][/tex]
Gross Profit:
[tex]\[ \text{Gross Profit} = \text{Sales} - \text{COGS} \][/tex]
[tex]\[ \text{Gross Profit} = 60,000 - 94,000 = -34,000 \][/tex]
### Profit & Loss Account for the Year Ending
#### TV Department:
1. Gross Profit: 62,000
2. Direct Expenses: 20,200
3. Indirect Expenses: 6,000
Total Expenses:
[tex]\[ \text{Total Expenses} = \text{Direct Expenses} + \text{Indirect Expenses} \][/tex]
[tex]\[ \text{Total Expenses} = 20,200 + 6,000 = 26,200 \][/tex]
Net Profit:
[tex]\[ \text{Net Profit} = \text{Gross Profit} - \text{Total Expenses} \][/tex]
[tex]\[ \text{Net Profit} = 62,000 - 26,200 = 35,800 \][/tex]
#### Cap Top Department:
1. Gross Profit: 25,000
2. Direct Expenses: 14,500
3. Indirect Expenses: 5,000
Total Expenses:
[tex]\[ \text{Total Expenses} = \text{Direct Expenses} + \text{Indirect Expenses} \][/tex]
[tex]\[ \text{Total Expenses} = 14,500 + 5,000 = 19,500 \][/tex]
Net Profit:
[tex]\[ \text{Net Profit} = \text{Gross Profit} - \text{Total Expenses} \][/tex]
[tex]\[ \text{Net Profit} = 25,000 - 19,500 = 5,500 \][/tex]
#### Music System Department:
1. Gross Profit: -34,000
2. Direct Expenses: 7,100
3. Indirect Expenses: 3,000
Total Expenses:
[tex]\[ \text{Total Expenses} = \text{Direct Expenses} + \text{Indirect Expenses} \][/tex]
[tex]\[ \text{Total Expenses} = 7,100 + 3,000 = 10,100 \][/tex]
Net Profit:
[tex]\[ \text{Net Profit} = \text{Gross Profit} - \text{Total Expenses} \][/tex]
[tex]\[ \text{Net Profit} = -34,000 - 10,100 = -44,100 \][/tex]
### Summary:
- Closing Stock: {'TV': 12,000, 'Cap_top': 10,000, 'Music_System': 6,000}
- COGS: {'TV': 58,000, 'Cap_top': 75,000, 'Music_System': 94,000}
- Gross Profit: {'TV': 62,000, 'Cap_top': 25,000, 'Music_System': -34,000}
- Total Expenses: {'TV': 26,200, 'Cap_top': 19,500, 'Music_System': 10,100}
- Net Profit: {'TV': 35,800, 'Cap_top': 5,500, 'Music_System': -44,100}
In conclusion, the departmental results are as follows:
- TV: Net Profit of 35,800
- Cap Top: Net Profit of 5,500
- Music System: Net Loss of 44,100