Question

ASSIGNMENT 5 a noa29) Departmental Account 1. XYZ Company has 3 departments : Electrical, Furniture & Telecommunication. 2. Select Maintain Project Titles option, use special codes to represent the 3 departments as shown below: Department Project Code ELECTRICAL ELEC FURNITURE FUR nebude TELECOMMUNICATION TEL ac 3. Enter the following January transactions for each department: Sales Book-Jan 10 (Batch 1) Date Description ELEC FUR TEL 10/01/2010 Sales to Santronic 5,000.00 8,000.00 5,500.00 15/01/2010 Sales to United Co. 10,000.00 4,500.00 6,000.00 30/01/2010 Sales to Sentosa Co. 7,500.00 5,500.00 7,500.00 Purchases Book-Jan 10 (Batch 2) Date Description ELEC FUR TEL 20/01/2010 Purchases from 2,000.00 3,500.00 2,500.00 Wisma S/B 25/01/2010 Purchases from 6,500.00 3,500.00 Kee & Son 4,500.00 Bank Book - Jan 10 (Batch 3) Date Description 30/01/2010 Paid Salary 30/01/2010 Paid Insurance 30/01/2010 Paid Rental ELEC 2,500.00 2,400.00 1,500.00 FUR 2,600.00 2,000.00 1,500.00 TEL 3,000.00 1,800.00 1,500.00

Use UBS！

Answer 1

XYZ Company

Departmental Trading and Profit & Loss Account

for the month ended January, 2XXX Dr. Cr.   

Descriptions	Electrical	Furniture	Telecom	Total	Descriptions	Electrical	Furniture	Telecom	Total
To Opening Stock A/c	10000	6500	5000	21500	By Sales(Refer Note 2)	22500	18000	19000	59500
To Purchases A/c(Refer Note 1)	8500	7000	7000	22500	By Closing Stock A/c	11500	7500	8000	27000
To Gross Profit c/f	15500	12000	15000	42500
Total	34000	25500	27000	86500	Total	34000	25500	27000	86500
To Salary A/c	2500	2600	3000	8100	By Gross Profit b/f	15500	12000	15000	42500
To Insurence Expenses A/c	2400	2000	1800	6200
To Rental Expenses A/c	1500	1500	1500	4500
To General Profit & Loss A/c (Net profits transferred)	9100	5900	8700	23700
Total	15500	12000	15000	42500	Total	15500	12000	15000	42500

General Profit & Loss Account (Consolidated)

For the month ended January,2XXX

Descriptions	Amount	Amount	Descriptions	Amount	Amount
			By Departmental Profit & Loss A/c
To Reserve &Surplus (Transferred)		23700	Electrical	9100
			Furniture	5900
			Telecommunication	8700
					23700
Total		23700	Total		23700

Note:-

1.Calculation of total purchase :-

Electrical Furniture Telecommunication

From Wisma B/S 2000 3500 2500

From kee Sons 6500 3500 4500

Total Purchased 8500 7000   7000

2.Calculation of total Sales:-

Electrical Furniture Telecommunication

To Santronic 5000 8000 5500

To United Co. 10000 4500 6000

To Sentosa Co. 7500 5500 7500

Total Sales 22500 18000 19000