Ask Question / Post resume

Post a reply to the thread: www.universityofcalicut.info IT Applications in Commerce Model Practical Paper : University of Calicut

Your Message

Your Username:

Click here to log in

Notes:-
1) You can copy and paste your full resume in the box below.
2) Or you can ask your question. We try to answer, as far as possible.

Title:

[QUOTE=ijt.dolora@gmail.com;269216][B][U]Name of the Organaisation [/U][/B]:University of Calicut (universityofcalicut.info)
[B][U]Type of Announcement [/U][/B]: IT Applications in Commerce Model Practical Paper 
[B][U]Home page [/U][/B]:[URL]http://www.universityofcalicut.info/[/URL]
[CENTER][B]M. Com Degree Examination[/B]
[B]Practical examination[/B]
[/CENTER]
1. Information about Sunrise Ltd ‘s capacity and expenses for the next year is given below 
Prepare a flexible budget with the help of a spreadsheet showing cost and profit at
90% and 70% capacity utilization levels
Sales @80% capacity (units ) 640000.
Selling price per unit Rs 120
Direct material Rs 20/unit
Direct labour Rs 25/unit
Direct expenses Rs 10/unit
Fixed production overheads rs 40000 Per month
Fixed administrative Overheads Rs 80000 Per month
Fixed selling and distribution overheads rs 120000 per month
Variable production over heads 5% of sales
Variable Administration Overheads 3% of sales
Variable selling Overheads 2% of sales

2.A company’s monthly requirement of A raw material ZX123 is 1800Kg . The cost of processing order is Rs 20 and carrying cost is 10% p a. the price of the material is Rs 200
per Kg. Using spread sheet 1. Find EOQ 2.Show graphically how EOQ minimizes overheads .

3.Construct a sales database in RDBMS containing product Table, Sales table and customer table. Product table contains product particulars. Sales table contains sales particulars and customer table contains customer details. Add data to the tables and extract the following information through queries
1.Sales made during the month of January
2.Sales of a a particular product during the month of January
3.Sales exceeding Rs 1,00,000 showing product and customer particulars

[B][U]Download Question paper Get here [/U][/B]: [URL]http://www.universityofcalicut.info/syl/MODELQUESTIONPAPERITpracticals.pdf[/URL][/QUOTE]

All times are GMT +5.5. The time now is 07:10 PM.