Use UBS

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 es A/C Type 4. Create the following stock account. Account No Description SA 3100/000 Stock BS 6000/000 Opening Stock OS 6020/000 Closing Stock CS F J J Cavitogido 0) Maintain the following stock code and stock values (1) Code Remarks BS AIC OS AIC CS A/C 1 ELEC 3100/000 6000/000 6020/000 2 FUR 3100/000 6000/000 6020/000 3 TEL 3100/000 6000/000 6020/000 ELEC 10,000.00 FUR 6,500.00 TEL 5,000.00 Opening Stock at Jan 2010 Closing Stock at Jan 2010 11,500.00 7,500.00 8,000.00 5. View and print each department Profit and Loss Account 6. View and print columnised Profit and Loss Account (Consolidated Account) for all the three departments