Wednesday, August 15, 2007

Assignment Sollution ( MCS-035 )


Session-1

Create the necessary Ledger and Groups to maintain the accounts as follows:
(Maintain Company as “Accounts only”)
Balance Sheet for the Year Ending 31-03-02
Test1 (User’s name)




Details of Creditors bill wise:

Yahoo India
i) Bill No: Yahoo/001/390
Rs. 25000
Dated 01-10-01
ii) Bill No: Yahoo/001/391
Rs. 45000
Dated 01-11-01

Gama India
i) Bill No: Gama/002/400
Rs. 17250
Dated 02-09-01
ii) On Account:
Rs. 12750


Square India
i) Bill No: Square/003/500
Rs. 20000
Dated 02-12-01

Details of Debtors bill wise:

BNP Traders
i) Bill No: Bnp/001/401
Rs. 25000
Dated 01-01-02
ii) Bill No: Bnp/001/402
Rs. 15000
Dated 31-03-02

Electronic India
i) Bill No: Elec/002/301
Rs. 30000
Dated 02-02-02


Smart India
i) Bill No: Smart/003/401
Rs. 10000
Dated 02-08-01
ii) Bill No: Smart/003/402
Rs. 35,000
Dated 02-10-01
iii) On Account
Rs. 15,000


Set the credit days for all debtors is 45 days.


Session 2
Open the Test1 Company and now onwards maintain the Company as “Accounts with Inventory”. Go to Company Feature (F11) > turn on the option “Allow Integrate with Accounts”. Put the details of the following products




Note: After putting the opening balances of products see the final accounts.


Session 3

Open “Test 1” Company and pass the following Transactions:
1. General expenses has been paid Rs. 2500 in cash dated 01-04-02
2. Outstanding salary paid Rs. 8000 dated on 02-04-02 from UTI, cheque no. 740521
3. Stationary paid Rs. 1200 dated on 02-04-2 by cash (Category: stationary, Centre: Paper, Pencil, Rubber; amount will be equally distributed among the centers)
4. Rs. 20,000 paid to Yahoo India against their Bill No. Alfa/001/390 by cheque issued from UTI on 01-05-02 cheque no. 740522
5. Smart India paid Rs. 50,000 for their Bill Nos, Smart/003/401, Smart/003/402 respectively and rest from on account balance on 01-05-02 cheque deposited into SBI Bank (Cheque No. 239309)
6. Machinery has been purchased Rs. 35000 from ABC Ltd. Dated on 02-05-02, Bill no. Abc/004/001
7. Cash withdrawn from SBI Rs. 10,000 dated on 02-05-02 cheque no. 150934.
8. Amount paid Rs. 28,000 to Gama Ltd. against their full dues through SBI cheque no. 150935 dated on 01-06-02
9. Cash deposited into UTI Rs. 13000 dated on 01-06-02.
10. Full amount paid to SquareLtd. with a discount @ 5% dated on 02-06-02.
11. General expenses paid Rs. 1200 from cash dated on 02-07-02 (category: Mis. Exp., Center: Postage, Tiffin divide the amount 40% and 60% respectively).
12. Furniture purchased from Raj & Raj. Rs. 15500 with sales tax @ 10% and freight Rs. 230 on 02-07-02 Bill no. Raj/005/001
13. Rs. 27500 received from Electronic India against their full dues and deposited into UTI on 02-07-02; cheque no: 450987.
14. Paid Rs. 48500 to Yahoo India against Bill no. Alfa/001/390 and Alfa/001/391 through cheques of UTI Rs. 39500 (ch. No: 740523) and SBI Rs. 9000 (ch no.: 150936), rest part of the bill will be treated as discount on 02-07-02.

Session-4

Open the Test 1 Company and enter the following transactions:

Turn off Cost Centre allocation from Sales and Purchase account.

1. Placed a purchase order to TVS & Co. for 15 pcs. Keyboard (Group: Hardware, Category: Input/Output) on 02-07-02: Order no: Tvs/02-03/001
Note: Use “Allow 0 valued entries in Voucher” from Company Feature (F11)
2. Received 10 pcs. Keyboard from TVS & Co. against the order (Tvs/02-03/001) on 01-08-02, Challan no. Tvs/ch/001 store at Malda godown.
3. Received another challan against it order Tvs/02-03/001 for the ret goods from TVS & Co. on 02-08-02 and store it at same godown. Challan no. Tvs/ch/002.
4. Received an invoice against challan nos. Tvs/ch/001 & Tvs/ch/002, with rate @ 750 including W.B.S.T. @ 10% on 01-09-02 bill no. Tvs/006/001
5. Purchased 10 pcs Mouse (Group: Hardware Category: Input/Output) @ Rs. 2.30 from TC Ltd. and get another 2 pieces as free samples on 01-09-02, keep it within Malda godown (Bill No.- Tc/007/001)
6. Returned 5 Pcs. Keyboard to TVS Co. on 02-09-02. (Against Bill no. Tvs/006/001, Debit note no. Tvs/006-ret/001)
Note: W.B.S.T @ 10% will be adjusted with return
7. On 02-09-02 the full dues paid to TVS & Co. with 5% discount.

Session-5

Do the following entries:
1. Sales order received from Milind Agency for 8 pcs. Keyboard on 02-09-02; Order no. Mil/02-03/001
2. Opened a new Bank A/c, City Bank A/c with Rs. 10000 on 01-09-02.
3. 5 Pcs Keyboard delivered from Malda godown to Milind Agency against order no. Mil/02-03/001 on 01-10-02 (challan no. Mil/ch/001).
4. The rest goods against order no Mil/02-03/001 delivered from the same godown on the next day (challan no. Mil/ch/002).
5. Earned 4% interest on IDBI investment for last six months on 01-10-02.
6. Furniture purchased for office use on 01-10-02 of Rs. 5000 from Furnishes & Co. (Bill no. Fur/008/001).
7. Returned 2 pcs Keyboard by Milind Agency from their first challan due to manufacturing defect on 01-10-02 (Ref. no. Mil/004-ret/001) (Use Rejection In). Immediately send the Keyboards to TVS & Co. for future replacement.
Note: Use Stock Journal to give the effect as Stock Outward.
8. Send a bill (Bill no. Mil/004/001) against the pending challans Mil/ch/001 & Mil/ch/002 @ 900 each with the following billing terms on 02-11-02
Trade Discount 2%
Sales Tax 10%
Delivery Charge Rs. 120
9. Paid advertisement bill Rs. 1000 from new City bank (ch. No. 920531) on 01-12-02.
10. Received from Milind Agency 50% due amount against the bill no. Mil/004/001 through cheque (ch. No. 110234) on 01-12-02 and deposited to City bank on the same day.
11. Transfer 12 pcs Mouse from Malda godown to Saithia godown with current stock rate on 01-12-02.
Session-6
Prepare the following Voucher Classes only for sales voucher:
1. Name of voucher sales: Sales-WBST @ 5%
Allow 95% of sale value to Sales A/c and 5% of sale value to Sales Tax A/c.
2. Name of voucher class: Sales- WBST @ 4% Sur@ 1%
Allow 100% of Sale value to Sales A/c
Additional charges will be as follows:
Sale Tax- @4% on total sales
Surcharge- @1% as Surcharge
Freight (Sale)- Rs. 5 based on quantity.
3. Name of Voucher class: Sales-No tax
No additional charges will be added.
4. Do the following entries appropriate Voucher Class
i. Sold 3 Pcs. Floppy Drive @1200, 10 Pcs Picture Tube @ 2500 to Pinak & Co. with Sales Tax 4%, Surcharge 1% and Freight Rs. 5 per quantity from Malda godown on 01-12-02 (Bill no. Pnk/005/001, order/challan is not required).
ii. Sold 500 Ltr Pepsi (300 ml) @22 including Sales Tax 5% to Cola House on 01-12-02 from Saithia godown (Bill no. Cola/006/001).
iii. Sold 800 Ltr Cock (1.5 ltr) @23 to Pine & Co. on 01-12-02 from Malda godown. (Bill no.Pine/007/001)
iv. 300 Ltr Cock (1.5 ltr) distributed as free among school students to get the market on 01-12-02 from Malda godown.
v. BNP Traders paid Rs. 39000 for full settlement of their dues through cheque (Ch. No. 230897) on 01-12-02 and the cheque deposited into SBI on the next day.
vi. Paid Rs. 35000 to ABC Ltd. against Bill no. ABC/004/001 from SBI (ch no. 150937) on 01-12-02.
vii. Raj & Raj charged 5% interest p.a. on their due amount on 01-12-02.
viii. Cola house returned 100 Ltd. Pepsi (300 ml) at Saithia godown on 02-12-02 (Bill no. Cola/006-ret/001), sales tax will be adjusted accordingly.

Session-7

1. Purchased the following items from Gama Ltd. with WBST @ 5% on 01-01-03 and stored into Saithia godown (Bill no. Gama/002/401):




1. Produce 8 Pcs Radio and store to Malda godown Aditional cost: Labor charges Rs. 100 per Radio, Power Rs. 210, Carriage Rs. 120.
Note: Make all payment entries for Additional cost from cash.
2. Salary paid to Mr. Aniket (employee) Rs. 6000 for the month of December 2002, through SBI (ch. No. 150938) dated on 01-01-03.
3. Received Rs. 20000 from Pinak & Co. on full settlement through cheque (ch. No. 450258) on 02-01-03 and deposit the amount to SBI.
4. Paid Rs. 43000 to Gama Ltd. through cheque issued from SBI (ch no. 150939) to clear all dues on 02-02-03.
5. Received 2 Pcs. Keyboard at Malda godown from TVS & Co. as replacement on 01-02-03.
6. Rs. 8800 received from Cola House on 01-02-03.
7. Sold 5 Pcs. Radio to Sony & Co. at 5% profit on the manufacturing price including WBST @5% (Bill no: Sony/008/001).
8. Sony & Co. paid a cheque (ch no. 458023) on full settlement and discount allowed by Rs. 500 duly deposited into UTI on 02-02-03.

End of April Month send Bank Statement of UTI



Session-8

Do the following using Optional voucher mode and check all possible effects using Scenario:

Company wants to check the written down value of the existing assets right now without affecting the account. [charge depreciation @ 40% p.a.]
If a sale occurs for 5 CD of Tally 6.3 with a 10% profit margin, then show what will be the effect on Gross Profit? But don’t give the effect on the Books of Accounts.
Show the Scenario result at the end of March 2003 before providing the salary of Rs. 25000 from UTI for the month of March 2003.
Make two Price Levels for (i) Retailer and (ii) Wholesaler. [Turn on “Set/Modify other Company Features?” from Company Features (F1), then go for the option “Use Multiple Price Levels for Invoicing”]
Set the following ranges of pepsi (300 ml) for Retailer:

Sold of 60 Ltr Pepsi (200 ml) to Pepsi House (Wholesaler) based on Price Levels on 02-02-03 (Bill no. Pep/009/001).

No comments:

 

Subscribe in a reader

Add to Technorati Favorites