Alagappa University 2007 Diploma Accounting & Finance COMPUTERISED ACCOUNTING - Question Paper

DAT DIPLOMA EXAMINATION, DECEMBER 2007.
COMPUTERISED ACCOUNTING

Time : 3 hours Maximum : 100 marks

The examiner should choose and provide 1 ques. to every candidate from lot.

1. Create the subsequent cost categories and cost centes.
Cost Category Cost Centre
Travelling expenses Air fare
Train fare
Bus/car fare
Inland Boarding & Lodging
Inland conveyance
Foreign Boarding & Lodging.
Newspaper Newspaper – National
Newspaper – North
Newspaper – East
Newspaper – Local
Newspaper – West
Newspaper – South.
Banners Banners – North
Banners – South
Banners – West
Banners – East
Banners – Local.
Enter the subsequent vouchers and link it with the improper cost centre and cost categories.
Serial No. Date Transactions
1 03 Feb. Payment made Rs. 45,000 by HSBC cheque No. 005620 towards Banner Publicity in Eastern region.
2 06 Feb. Invoice received Rs. 15,777 from Western advertisers (new a/c) for advertisement in English newsprints in Western region.
3 10 March Invoice received from Global Advertisers for all India level advertisement in T.V. Rs. 5,35,000.
4 17 March Payment towards newsprint insertions in all cities in southern region Rs. 42,000 by ANZ Grindlays cheque No. 110426.
5 17 March Paid travelling expenses by ANZ Grindlays cheque No. 110426 for Middle East tour of M.D. and purchase officer details are :
Air fare Rs. 22,000; Boarding & Lodging Rs. 46,000, Conveyance Rs. 15,000.
6 22 March Paid Local Conveyance expenses by cash to office staff Rs. 4,200.
2. Create the subsequent company :
Agni computers deals in both software and hardware. Its corporate office is located at 21, Lenin Sarani, Kolkata. They are not registered under central sales tax. They operate within the country.
Ledger a/c Debit Ledger a/c Credit
Indian bank 50,000 Accumulated Depreciation
Furniture 1,00,000 Furniture 50,000
Motor car 2,50,000 Accumulated Depreciation
AK Sinha & Co. 34,500 Motor car 2,00,000
Ajay Kumar Ghosh (proprietor) Metrics computers
Cash in hand 17,750 (Suppliers) (See Note (c)) 2,35,700
Stock in hand Liability for
(See note (d)) 2,35,550 income tax 14,550
Advance to staff 12,350
Tax deduction
at source 17,500
Additional info :
(a) Create groups and ledgers for sales as under :
Sales, Computer sales, Service charges – installation charges, Annual maintenance charges, Maintenance charges, Software development.
(b) The company has 2 divisions hardware and software. It wants that every income and expenses be specifically attributed to the SW (or) HW division.
(c) The assets are maintained in the books at book values and depreciation is kept in a separate a/c.
(d) All expenses which are of common in nature are allocated to software and hardware division in the ratio of two : one respectively.
3. Create six sundry debtor ledger accounts, namely –
PQR & Co. and LML & Company grouped under New Delhi debtor XYZ Limited and GHI Pvt. Ltd. grouped under Lucknow debtors, Jewellery Mart Pvt. Ltd. grouped under Bangalore debtors. Hue Designs Pvt. Ltd. grouped under Hyderabad debtors.
4. Create the stock items :
ABC and company opening stock position as on first Dec. 2006.
Stock Cost W'house On-site Total Value Retail
Systems¬ P133 750 7 1 8 6000 940
CD-ROM drives-
Gold 8
45
0
2
2
90
60
Software ACE-Database A
175
0
10
10
1750
250
Software King-Database-K
100
0
7
7
700
150
5. Enter the subsequent transactions using voucher entry in the voucher :
No. Date Transactions
1 02 Feb Cash with drawn from HSBC bank Rs. 12,000 cheq. No. 005614
2 04 Feb Paid salary to office staff Rs. 21,000 to factory workers Rs. two 8,000 amount to be credited to HSBC bank a/c
3 04 Feb Paid labour for building construction
Rs. 28,800 by HSBC bank cheq. no. 005616
4 04 Feb Payment made to Shalin Enterprise
Rs. 1,50,000 by HSBC bank cheq. No. 005617.
5 05 Feb Purchased 1000 litres of furnace oil from Nevil & Neil industrial suppliers at prescribed rate.
6 06 Feb Expenses payable cleared Rs. 45,000 by ANZ-Grindlays cheq. No. 110421
7 09 Feb Cash deposited Rs. 10,000 into ANZ Grindlays.
8 11 Feb Purchased 100 no. of higher grade electrodes - 200 mm from Ram industries @ 600 on credit. Carriage inwards Rs. 4,000 extra.
9 20 Feb Publicity expenses paid by cash Rs. 3,700
10 26 Feb Payment made to Ram Industries Rs. 1,70,000 by ANZ Grindlays cheque No. 110423.

Earning:   Approval pending.