C/C++ | Java | Advance Java | J2EE | Data Structure | Visual Basic | Oracle | SQL Server | Software Testing | CCNA | CCNP | CCIE | MCITP | Hardware | Networking | HTML / CSS | JavaScript / XML | Dreamweaver | Ethical Hacking | PHP & My SQL | VB.Net | ASP.Net | C#.Net | SQL Server | MS-CIT | English Speaking | Specialized Courses | Foreign Education | Personality Development | Auto CAD 2D | Auto CAD 3D | STAAD Pro | REVIT | ARCHI CAD | 3D Studio Max | Uni-Graphics NX | Ansys | Pro-E / Creo | CATIA | CAD CAM | MS-Word | Excel | Powerpoint | Access | Internet and Email | Animation | Photoshop | Corel Draw | Illustrator | Premiere | Flash | 2D Max / 3D Max | Maya 2D / 3D Maya | Pinnacle | Graphics Design | Basic Advance Accounting | Costing & Auditing | Import and Export | Taxation | Tally 9.0 ERP | OCA / OCP | BCA | BCCA | MCA | MCM | Polytechnic | Distance Learning | Industrial Accounting | Share Market | SEO | Digital Marketing | Autocad Electrical
Contact information:
ATLANTA COMPUTER INSTITUTE
SECOND FLOOR,
SHIVAJI COMPLEX,
NEAR COFFEE HOUSE AND BANK OF BARODA, WEST HIGH COURT ROAD,  DHARAMPETH,
NAGPUR  -10, MAHARASHTRA, INDIA. 
NAGPUR
Mobile: 90281 57794
               9595 321479
Tel: 0712-2557946

ATLANTA COMPUTER INSTITUTE
SECOND FLOOR, SELOKAR BHAVAN
Opp. SANGAM SWEETS, NEAR  PETROL PUMP
MEDICAL SQUARE,
NAGPUR -09, MAHARASHTRA, INDIA. 
NAGPUR
Mobile: 99701 98839
                9595 321479
Tel: 0712-2701833
Email: atlantaworld@gmail.com
www.atlantacomputer.in

University Syllabus Course and Classes For MCM Part 1 Semester 1 Fundamentals of Information Technology

Atlanta Computer Institute Nagpur conducts Tuition Classes for MCM Part 1 First semester MCM Part 1 second semester MCM Part 2 third semester and MCM Part 2 fourth semester  for all universities in India . The Following syllabus is of Nagpur University.  Final Year Projects Training is also given to  MCM Students.

MCM Master of Computer Management

 MCM Part - I

Semester- 1

Paper-I :

Fundamental of Information Technology

Unit - I
Computers: Introduction to computers, Characteristics of computer, Evolution of computer, Generations of computer, Basic organization of computer system (Block Diagram), Functioning of computer, Concept of system. Number system: non-positional number systems, Positional number systems, Conversion from one number system to another, Fraction numbers. Computer codes: BCD, EBCDIC, ASCII, Unicode, Collating sequence. Computer arithmetic: Need of binary, Binary arithmetic.

Unit - II
Processor & memory: Central processing unit (CPU), Components of CPU (CU, ALU, Instruction set, Registers, Processor speed, Type of processor), Main memory, Types of
memory. Secondary storage devices: Sequential & direct access devices, Magnetic tapes, Magnetic disks, Optical disks, Memory storage devices, Mass storage devices, Data backup, On-line, Near line and Off-line storage, Hierarchical storage devices(HSS), Input-output devices.

Unit - III
Computer software: Define software, Types of software, Logical system architecture, Firmware, Middleware, Acquiring software, Software development life cycle (SDLC), Software engineering, CASE tools. System implementation & operation: Software testing & debugging (Types of program errors, Testing a program, Debugging a program for syntax errors & logical errors, Difference between testing & debugging), Software documentation, Software deployment, System evaluation, Software maintenance. Business data processing: Meaning of data processing, Data storage hierarchy, Standard methods of organizing data, File management system, Database management system.

Unit - IV
Data communication and computer networks: Basic elements of a communication system, Data transmission modes, Data transmission speed, Data transmission media, Digital & analog data transmission, Data transmission services, Multiplexing techniques, Switching techniques, Routing techniques, Network topologies, Types of network, Communication protocols, Network interface card (NIC), OSI model, Ernet working tools,
Wireless Networks. Multimedia: What is multimedia, Multimedia components, Multimedia applications, and media center computer. Classification of computers: Notebook computers (Laptops), Personal computer (PCs), Workstations, Mainframe systems, Super computers, Client & server computers, Handheld computers (Tablet PC, PDA/Pocket PC, Smartphone). MCM Syllabus RTMNU

Text Book:
1. P. K. Sinha & Priti Sinha, Computer Fundamentals, BPB Publication.

Reference Books:
1. Madhulika Jain, Shashank Jain, Satish Jain, Information Technology Concepts, BPB Publication.
2. B. Ram, Computer Fundamentals (Architecture & organization), New Age International Publisher.
3. Turban, Rainer, Potter, Introduction to Information Technology, Wiley India Edition.

4. Peter Norton, Introduction to Computers, McGraw-Hill Education.
5. S. Jaiswal, I.T. Today, Encyclopedia.

Practical List of Fundamental of Information Technology

A1. Use a contemporary letter template of MS-WORD and provide information about
launching of new products of a company.
Also write down the steps to perform above in MS-WORD.
A2. Use a professional letter template of MS-WORD and write an application to the
principal for two days leave.
Also write down the steps to perform above in MS-WORD.

A3. Using Mail Merge of MS-WORD, write a letter to the students of MCM-I to submit
their Original Documents (Mark Sheet, Migration Certificate, TC etc) along with their balance fees up to 10th March 2008 in the office of the college during office timings morning 8:00 AM to 5:00 PM.
Also write down the steps to perform above in MS-WORD.

A4. Using Mail Merge of MS-WORD, write a letter to your friends, invite them on your
Birth Day Party on 10th March 2008 at the Venue- B04, Amar Apartment,
Narendranagar, Nagpur-440021
Also write down the steps to perform above in MS-WORD.

A5. Using Mail Merge of MS-WORD, write a letter to all the selected candidate for
their final interview on 10th March 2008 at the Centre Point College, 7 Nawab
Layout, Tilaknagar, Nagpur-10 at 11:00 AM along with all original documents and
2 passport size photographs.
Also write down the steps to perform above in MS-WORD.

A6. Draw and Analyze the DFD of Book Issuing System of College Library in MS-
PowerPoint.
Also write down the steps to perform above in MS-POWERPOINT.
A7. Draw and Analyze the DFD of Hotel Management System in MS-PowerPoint.
Also write down the steps to perform above in MS-POWERPOINT.
A8. Draw and Analyze the DFD of Examination Management System in MS-
PowerPoint.
Also write down the steps to perform above in MS-POWERPOINT.
MCM Syllabus RTMNU Page 2 of 72

A9. Create a Mark-Sheet of MCM-Part I using MS-Excel. Mark-Sheet format should
be as per below. Fill the information about 10 students.

Roll
No. Name
of
Stude
nt IT
(100) ICP
(100) IOS
(100) C
(100) MIS&
SA
(100) Practical
-I
(100) Practical-II
(100) Total
Marks
(Out of
700) %
ag
e
1
Draw a pie chart for above Mark-sheet
Also write down the steps to perform above operation in MS-EXCEL.
A10. Create a Employee Payment Sheet using MS-Excel. Employee Payment Slip
format should be as per below. Fill the information about 10 employees.

Sr.No. Name of
Employee Basic Salary HRA
5% TA
7% DA
9% Gross_Salar
y
1
Total salary
Draw a bar chart for above Employee Payment Sheet
Also write down the steps to perform above operation in MS-EXCEL.
A11. Create the following Product sheet in MS-EXCEL and perform the operation
given below:

Sr.N
o. Product Name Company
Name Country Quantity Rate
1 Butter Amul India ltd India 20 Rs.19.00
2 Milkmaid Amul India ltd India 10 Rs.35.00
3 Tea Hindustan
Lever ltd Malaysia 15 Rs.40.00
4 Biscuits Parle ltd India 32 Rs.12.00
5 Papad Haldiram ltd India 12 Rs.10.00
6 Chocolate Cadbury ltd Australia 150 Rs.15.00
7 Paneer Amul India ltd India 23 Rs.25.00
8 Bournvita Cadbury ltd Australia 20 Rs.45.00
9 Poppins Parle ltd India 27 Rs.6.00
10 Sauce Amul India ltd India 16 Rs.21.00
a) Sort by Product Name, by company name, by country in ascending
order.
b) Sort by Country in descending order.
Also write down the steps to perform above operation in MS-EXCEL.

A12. Create the following Product sheet in MS-EXCEL and perform the operation
given below:
Sr.N Product Name Company Country Quantity Rate
o. Name
1 Butter Amul India ltd India 20 Rs.19.00
2 Milkmaid Amul India ltd India 10 Rs.35.00
3 Tea Hindustan Malaysia 15 Rs.40.00
Lever ltd
4 Biscuits Parle ltd India 32 Rs.12.00
5 Papad Haldiram ltd India 12 Rs.10.00
6 Chocolate Cadbury ltd Australia 150 Rs.15.00
7 Paneer Amul India ltd India 23 Rs.25.00
8 Bournvita Cadbury ltd Australia 20 Rs.45.00
9 Poppins Parle ltd India 27 Rs.6.00
10 Sauce Amul India ltd India 16 Rs.21.00
a) List only those records whose country =‖India‖.
b) List only those records whose company name=‖Amul‖.
Also write down the steps to perform above operation in MS-EXCEL.
MCM Syllabus RTMNU

A13. Create the following Product sheet in MS-EXCEL and perform the operation
given below:

Sr.No. Product Name Company
Name Country Quantity Rate
1 Butter Amul India ltd India 20 Rs.19.00
2 Milkmaid Amul India ltd India 10 Rs.35.00
3 Tea Hindustan
Lever ltd Malaysia 15 Rs.40.00
4 Biscuits Parle ltd India 32 Rs.12.00
5 Papad Haldiram ltd India 12 Rs.10.00
6 Chocolate Cadbury ltd Australia 150 Rs.15.00
7 Paneer Amul India ltd India 23 Rs.25.00
8 Bournvita Cadbury ltd Australia 20 Rs.45.00
9 Poppins Parle ltd India 27 Rs.6.00
10 Sauce Amul India ltd India 16 Rs.21.00
a) List the records whose quantity is >= 10 and <= 100.
b) List the records whose rate is >= Rs. 35.00.
Also write down the steps to perform above operation in MS-EXCEL.
A14. By the help of following information prepare cost sheet for the month of March
1980: Rs.
1. Stock (1-3-1980)
a) Raw Materials 25,000
b) Finished goods 17,360
2. Stock (31-3-1980)
a) Raw Materials 26,250
b) Finished goods 15,750
3. Raw material purchased 21,900
4. Work-in-progress (1-3-80) 8,220
5. Work-in-progress (31-3-80) 9,100
6. Sale of finished goods 72,310
7. Direct wages 17,150
8. Unproductive Wages 830
9. Factory Expenses 8,340
10. Office and management expenses 3,160
11. Selling and distribution expenses 4,210
Prepare cost sheet and find out following information:
1) Total Cost 2) Cost of goods sold 3) Profit on sold out goods
Also write down the steps to perform above operation in MS-EXCEL.
A15. Following information is received from the books of a factory:
1. Closing stock of raw materials 25,150
2. Closing stock of finished goods 14,650
3. Raw materials purchased 20,800
4. Work in progress (1-1-78) 8,220
5. Work in progress (31-12-78) 8,000
6. Opening stock of raw material 24,000
7. Opening stock of finished goods 16,200
8. Sale of finished goods 62,800
9. Office expenses 2,150
10. Selling and Distribution expenses 4,000
11. Direct wages 16,000
12. Factory expenses 9,000
Prepare cost sheet and find out the following items:
1) Cost of materials consumed 2) Production Cost 3) Cost of goods sold
4) Net profit.
Also write down the steps to perform above operation in MS-EXCEL.
MCM Syllabus RTMNU

A16. By the help of following information prepare a statement of cost and in that
statement indicate prime cost, works cost, office cost (production cost) and cost
of goods sold, for the half year ending 30th June, 1978. Production 500 units.
1. Material consumed 30,000
2. Direct Wages 40,000
3. Direct Expenses 4,000
4. Works on Cost Expenses
a) Unproductive wages 9,000
b) Factory lighting and heating 11,000
c) Factory rent, rates and insurance 3,000
d) Factory Director‘s fees
e) Depreciation of machinery 1,500
f) Factory stationery 375
g) Factory cleaning 400
h) Depreciation of loose tools 900
i) Indirect material 500
j) Estimating expenses 500
5. Office expenses (Office overhead)
a) Director fees 3,000
b) Office printing and stationery 750
c) Legal Expenses 500
d) Depreciation of office building 800
e) Bank fee 75
f) Salary of office employees 5,000
6. Selling and Distribution expenses
a) Selling commission 1,000
b) Rent of warehouse 1,800
c) Bad debt 150
d) Advertisement 500
e) Depreciation and maintenance of delivery vans 700
Also write down the steps to perform above operation in MS-EXCEL.
A17. Prepare cost sheet by the help of following information and find out (i) Prime cost
(ii) Factory cost (iii) Total Cost; (iv) Net Profit.
1.Raw Material purchased 66,000
2.Direct wages 52,500
3.Indirect wages 2,750
4.Stock of Raw Materials (1-9-83) 75,000
5.Stock of Raw material (30-9-83) 91,500
6.Stock of finished goods (1-9-83) 54,000
7.Stock of finished goods (30-9-83) 31,000
8.Stock of work in progress (1st Sep.83) 28,000
MCM Syllabus RTMNU Page 5 of 72
9.Stock of work in progress (30th sept.83) 35,000
10.Sales 2,11,000
11.Rent, rates and electric of factory 15,000
12.Depreciation of machinery 3,500
13.Carriage inward 1,500
14.Sundry factory exp. 10,000
15.Travelling wages and commission 6,500
16.Office rent and rates 2,500
17.Sundry Office expenses 6,500
18.Advertisement 3,500
19.Carriage outward exp.(exp. on sale) 2,500
Also write down the steps to perform above operation in MS-EXCEL.
A18. By the help of following information prepare cost sheet for the year 1976.
1.Opening Stock (1-1-1976)
a) of Raw Materials 22,000
b) of Unfinished goods 5,000
c) of Finished goods 10,000
2.Closing Stock: (31-12-76)
a) of Raw Materials 2,350
b) of Unfinished goods 3,000
c) of Finished goods 2,000
3.Direct Wages 30,000
4.Direct Expenses 10,000
5.Material Purchased 70,500
6.Carriage Inward 2,000
7.Factory on cost 70,000
8.Factory Supervision 8,800
9.Office Rent 6,000
10.Factory Rent 9,000
11.Rent of sales department 6,000
12.Lighting bill (out of this 30% of factory,
20% of sales dept. and balance for office) 10,000
13.Advertisement 6,000
14.Salary of Manager (30% of Factory,
40% of Sales dept. and balance for office) 37,000
15.Profit 10% on total cost.
Also write down the steps to perform above operation in MS-EXCEL.
A19. Following information is available from the books of Zenith manufacturing
company as on 31st Dec. 1974.
1.Salary of Drawing room staff 6,500
2.Salary of distribution department 12,600
3.Outward carriage expenses 4,300
4.Cash discount 2,900
5.Inward carriage exp. on purchase 7,150
6.Bad debts written off 6,500
7.Machine repairing 4,450
8.Rent, taxes and insurance (Factory) 8,500
9.Rent, taxes and insurance (office) 2,000
10.Sales 4,61,100
11.Stock of Raw material (31-12-73) 62,800
12.Stock of Raw material (31-12-74) 48,000
13.Material Purchased 1,85,000
14.Travelling Expenses 2,100
15.Salary and Commission of travelling agent 7,700
16.Productive wages 1,26,000
17.Depreciation of machinery & equipment 6,500
18.Depreciation of office furniture 300
19.Director fee 6,000
20.Gas and Water (Factory) 1,200
21.Gas and Water (Office) 400
22.Salary of manager (3/4 for factory & 1/4 for office) 10,000
23.General Expenses 3,400
24.Income tax 1,500
25.Dividend 1,000
Prepare cost sheet and indicate the following items:-
1) Materials Consumed (2) Prime cost (3) Factory on cost and factory cost(4) General and selling overhead (5) Total cost (6) Net profit (7) Percentage of factory on cost to wages (8) percentage of general overhead to factory cost.
Also write down the steps to perform above operation in MS-EXCEL.
MCM Syllabus RTMNU
A20. From the given information prepare Flexible budget for the capacity 70%, 80% &
100 % & show the results.
The sales for the above capacity would be 50,00,000/-, 60,00,000/-, 85,00,000 respectively. Fixed expenses will be constant at all capacities. Semi variable will be constant between 55% to 75% capacity.
It will be increased by 10% between the capacity 75% to 90% & will be increased
by 20% between the capacity 90% & 100%. Following exp are on the capcity of
60%.
Particulars Rs.
Semi variable exp:
Maintenance & repairs 1,25,000
Labour 5,00,000
Sales dept. Expenses 1,50,000
Other overheads 1,25,000
9,00,000
Variable Cost :
Material 12,00,000
Labour 13,00,000
Other Expenses 2,00,000
27,00,000
Fixed Cost :
Wages & salaries 4,20,000
Rent & Taxes 2,80,000
Depreciation 3,50,000
Other overheads 4,50,000
15,00,000
Total Cost 51,00,000
Also write down the steps to perform above operation in MS-EXCEL.

A21. The following data is taken from the manufacturing record of a company for 1/2
year period.
Fixed expenses:
Wages & salaries 84,000
Rent, rates & taxes 56,000
Depreciation 70,000
Sundry administration Exp. 89,000
2,99,000
MCM Syllabus RTMNU Page 7 of 72
Semi-variable exp : (at 50% capacity)
Maintenance & Repairs 25,000
Indirect Labour 99,000
Sales Department salaries 29,000
Sundry administration exp. 26,000
1,79,000
Variable Exp. (at 50% capacities)
Materials 2,40,000
Labour 2,56,000
Other expenses 38,000
5,34,000
Assume that the fixed expenses remain constant for all levels of production. Semi- Variable expenses remain constant between 45% & 65% of capacity. Increasing by 10% between 65% & 80% capacity & by 20% between 80% & 100% of capacity. Sales at various levels are :-
Capacity Rs.
60% 10,00,000
75% 12,00,000
90% 15,00,000
100% 17,00,000.
Prepare Flexible budget for the above capacity.
Also write down the steps to perform above operation in MS-EXCEL.

A22. The following budget is prepared for 10,000 units. Per unit cost will be as under :-
Particualrs P.U. (Rs.)
Material 60
Wages 55
Fixed cost (2,00,000) 20
Variable expenses 5
Selling expenses (10% fixed) 15
Administration exp. (90,000) 9
Distribution exp. (20% fixed) 15
Prepare budget for 7,500 & 6,500 units.
Also write down the steps to perform above operation in MS-EXCEL.

A23. The following figures are available from sales & cost forecast of M/s ALANKAR &
Co. for the year ended 31st.Dec. 1990 at 50% (5,000 units) capacity. Prepare a profit forecast statement through flexible budget at 60%, 75%, 90% & 100% capacity assuming that
1) The fixed expenses remain constant for all levels of production & sales.
2) Selling price between 50% & 75% capacity is Rs. 25/- per unit.
3) Semi variable expenses will remain unchanged at 50% & 65% capacity but will
increase by 10% between 65% to 80% capacity & by 30% between 80% & 100%
capacity.
4) At 90% level (capacity) material Cost increase by 5% & Selling Price is reduced by 5%.
5) At 100% level both material & labour cost increase by 10% & selling Price is reduced by 8%.
6) Semi variable expenses are Rs. 50,000 /-
7) Fixed expenses are Rs. 50,000/-
8) Variable expenses are : Material Rs. 5 p.u.
Labour Rs. 2 p.u.
Direct Exp. Rs. 1 p.u.
Also write down the steps to perform above operation in MS-EXCEL.
MCM Syllabus RTMNU

A24. Prepare Flexible budget & find out overhead rate.
Particulars 50% 60% 70%
Rs. Rs. Rs.
Variable Overheads
A) Material --- 60,000 ---
B) Labour --- 24,000 ---
Semi-Variable Exp.
1) Electric (20% fixed) --- 15,000 ---
2) Repairs & Maint.
(20% variable) --- 7,500 ---
Fixed Expenses
a) Depreciation --- 20,000 ---
b) Rent & tax --- 2,250 ---
c) Insurance --- 2,500 ---
d) Salary --- 15,000 ---
e) Indirect wages --- 8,000 ---
Budgeted Direct labour hours --- 30,000 ---
Also write down the steps to perform above operation in MS-EXCEL.
A25. Estimated cash balance on 1st may 1990 Rs. 2,50,000 From the following
information Prepare Cash budget for the month of may, June, July 90.
Month Sales Purchase Wages Manu. Office Selling
Exp. Exp. Exp.
March 50,000 30,000 6,000 5,000 4,000 3,000
April 56,000 32,000 6,500 5,500 4,000 3,000
May 60,000 35,000 7,000 6,000 4,000 3,500
June 80,000 40,000 9,000 7,500 4,000 4,500
July 90,000 40,000 9,500 8,000 4,000 4,500
Adjustments :-
a) Out of total sale 20% sales in cash & balance will be collected in the next
month.
b) Suppliers allowed the credit period of 2 months.
c) Wages and all other exp. will be paid in the following months.
d) Dividends to share holders & Bonus to employees will be paid in the month of may Rs. 10,000 & Rs. 15,000 Respectively.
e) An order of machine is given, the cost of which is Rs. 80,000, Machine will be received in the month of June & payment will be done in same month.
f) Income tax will be paid Rs. 25,000/- in the month of July.
Also write down the steps to perform above operation in MS-EXCEL.
A26. From the following information Prepare Cash budget for the 3 months ending
30th June.
MonthSales Materials Wages Overheads
Jan 60,000 40,000 11,000 6,200
Feb. 56,000 48,000 11,600 6,600
Mar. 64,000 50,000 12,000 6,800
Apr. 80,000 56,000 12,400 7,200
May 84,000 62,000 13,000 8,600
June 76,000 50,000 14,000 8,000
a) Payment of material & overheads will be done in the following month.
b) Payment of wages will be done in the same month.
c) Terms & conditions of sales as under :- Half amount of credit sales will be recovered in following months & balance amount will be recovered in the next month of the following month.
d) Dividend on Preference shares Rs. 30,000/- will be paid on 1st may.
e) The amount of share call each Rs. 25,000/- will be received on 1st April & of 1st June each.
f) Machines costing Rs. 10,000/- will be established in the month of January but payment will be done in the month of June.
g) The selling commission 5% will be paid in the following months of actual sales.
h) On 1st April Expected Cash balances Rs. 20,000/-
Also write down the steps to perform above operation in MS-EXCEL.
MCM Syllabus RTMNU

A27. From the following information Prepare Cash budget for 3 months commencing
from 1st June. On 1st June Cash balance is Rs. 1,00,000/-
Month Sales Purchase Wages Manu. Exp Selling & Admn. exp.
April 80,000 41,000 5,600 3,900 10,000
May 76,500 40,500 5,400 4200 1400
June 78500 38500 5400 5100 15000
July 90,000 37,000 4,800 5,100 17000
Aug. 95,500 35,000 4,700 6,000 13000
Additional Information :-
1) Commission on sales 5% will be paid after 2 months of the sales. ( This commission is in addition of Selling Exp.)
2) Machine Costing Rs. 65,000/- will be purchased in the month of April but payment will be done in the month of August.
3) Dividend of last year Rs. 15,000/- will be paid in the month of July.
4) Lag time allowed to customers for the payment is 2 months, and 2 months credit period allowed from suppliers.
Also write down the steps to perform above operation in MS-EXCEL.

A28. Budgeted information given as under :-
Month Sales Purchases Wages Manu. Office Selling
Exp. Exp. Exp.
Mar. 50,000 30,000 5,000 1,000 1,000 6,000
April 60,000 35,000 6,000 4,000 2,000 7,000
May 70,000 37,000 7,000 2,000 3,000 8,000
June 80,000 42,000 8,000 4,000 3,000 9,000
July 90,000 60,000 9,000 3,000 2,000 15,000
Aug 1,00,000 70,000 11,000 4,000 1,000 20,000
Additional Information :-
1) Cash balance on 1st may Rs. 80,000/-
2) 20% sales in cash & out of total Credit sales 50% amount Recovered in the following month & balances 50% in the next month of the following month.
3) Suppliers allowed a credit period of 2 months.
4) Lag time for wages 1/2 month.
5) Delay in payment of office expenses 1 month.
6) Delay in payment of manufacturing exp. 1 month.
7)Amount of shares call money willbe received in the months of may Rs. 50,000/-
8) Payment of tax will be done in July Rs. 80,000/-.
9) Machine will be purchased in June Rs. 20,000/-.
MCM Syllabus RTMNU Page 10 of 72
Prepare Cash Budget for May, June, & July.
Also write down the steps to perform above operation in MS-EXCEL.

A29. A newly established Company wants to prepare Cash budget for four months
ending on 30th June.
Month Sales Materials Wages Overheads Selling&Admn. Exp
Jan 20,000 20,000 4,000 3,200 800
Feb. 22,000 14,000 4,400 3,300 900
Mar. 24,000 14,000 4,600 3,300 800
Apr. 26,000 12,000 4,600 3,400 900
May 28,000 12,000 4,800 3,500 900
June 30,000 16,000 4,800 3,600 1,000
Adjustment :-
1) Expected Cash balance on 1st March Rs. 10,000/-.
2) A machinery is Purchased for Rs. 30,000/- payment will be done in two equal instalments March & April.
3) Selling Commission 5% on total sales & this commission will be paid in the following months of actual sales.
4) Amount of 2nd call will be received in the month of march Rs. 10,000/- & Amount of share premium Rs. 2,000/- will be received with 2nd call.
5) Period allowed to customer for payment is1 month.
6) Remaining all other exp. will be paid in the following months.
7) The delay in the payment of wages 1/2 month.
8) You may presume that 50% sales are in cash.
9) Suppliers allowed period of 2 months for payment.
Also write down the steps to perform above operation in MS-EXCEL.
A30.By the help of following information prepare cost sheet for the month of March 1980:
1. Stock (1-3-1980)
a) Raw Materials 25,000
b) Finished goods 17,360
2. Stock (31-3-1980)
a) Raw Materials 26,250
b) Finished goods 15,750
3. Raw material purchased 21,900
4. Work-in-progress (1-3-80) 8,220
5. Work-in-progress (31-3-80) 9,100
6. Sale of finished goods 72,310
7. Direct wages 17,150
8. Unproductive Wages 830
9. Factory Expenses 8,340
10. Office and management expenses 3,160
11. Selling and distribution expenses 4,210
Prepare cost sheet and find out following information:
1) Total Cost 2) Cost of goods sold 3) Profit on sold out goods
Also write down the steps to perform above operation in MS-EXCEL.



New MCM Syllabus Semester Pattern  From 2016 - 17

Theory

1.  Fundamental of Information Technology 

2.  Programming in C & OOPs Concept

3.  Introduction to Operating Systems 

4.  Computerized Accounting ( Tally ERP 9  ) 

Practical

1. Practical-I : Programming in C & Operating Systems

2. Practical-II : Tally ( ERP 9 ) & MS-Office 

MCM Semester 2

Theory

1.  Management Information Systems

2.   Core Java 

3.  Quantitative Techniques & Operation Research

4.  E-Commerce and Web Designing 

Practical

1. Practical-I : Core Java 

2. Practical-II : HTML, JavaScript 

MCM Part-II

MCM Semester 3

 (A) Theory

1.   Advanced Database Management System 

2. Principles & Techniques of Management

3.  Electives

               ( i )     PHP & My-SQL

              ( ii )     VB.Net 

              ( iii )     C#.Net

                    

4.  Research Methodology

 (B) Practical

1. Practical-I : SQL & PL/SQL 

2. Practical-II : Electives 

MCM Semester 4

 (A) Theory

1.   ASP.Net 

2.    Electives : (i) Advanced Java

                            (ii) Android Programming

                            (iii) Python

3.  Electives :   ( i ) Big Data & Hadoop  

                             ( ii ) Software Engineering   

                            ( iii )Strategic Management

(B) Practical

1. Practical-I : ASP.Net 

2. Practical-II : Electives 

(C)  Project

1. PROJECT 

 

BCA Bachelor Of Computer Application, BCCA, Bachelor of Commerce & Computer Application BE IT/CS, Information technology/Computer Science MCA, Master of Computer Application MCM, Master of Computer Management Diploma , Polytechnic Others,

Basic Programming

C / C++ ,

Testing

Software Testing,

Hardware & Networking

CCNA, MCSE, Hardware, Networking
Join our newsletter:
Course Offers
Dot Net Courses Java Coaching Classes Autocad and CAD Training Institute Web Design and Development Courses
Advance Accounting Classes Short Term Computer Course Design and Animation Courses Job Oriented Courses Professional Courses Nagpur University Syllabus and Classes for BCCA BCA MCM MCA BE Poly Diploma BSc MSc BCom BA
Short Term Courses

Programming & Database

C / C++
Java
Advance Java
J2EE
Data Structure
Visual Basic
Oracle
     SQL Server
Android

Testing

     Software Testing
ISTQB

Hardware & Networking

CCNA
MCSE
Hardware
    Networking
CCNP
     CCIE

Web Designing

HTML / CSS
JavaScript / XML
Dreamweaver
Frontpage
     PHP & My SQL
Joomla
     Wordpress

.Net

VB.Net
ASP.Net
C#.Net
SQL Server

Basic Courses

MS-CIT
English Speaking
Interview SkillS
Personality Development

AutoCAD

AutoCAD
STAAD Pro
REVIT
ARCHI CAD
3D Studio Max
Uni-Graphics
Ansys
Pro-E
     CATIA
Autocad Electrical
     CAD CAM
     CNC

Computer Application

MS-Word
Excel
Powerpoint
Access
     Internet and Email
MS-Office

Animation & Multimedia

Photoshop
Corel Draw
Illustrator
Premiere
     Flash
InDesign
2D Max / 3D Max
Maya 2D / 3D Maya
     Pinnacle
     Graphic Design
Advance Animation

Advance Accounting

Basic Advance Accounting
Costing & Auditing
Import and Export
Direct / In Direct Taxes
Tally 9 ERP
Portfolio Management

 Tuition Classes

      BCCA
      BCA
      MCM
      MCA
      Polytechnic
      BE
     12th

 Certifications

     Adobe
     Microsoft
    Oracle

Ethical Hacking

 Projects

  Embedded Systems

Matlab

     Matlab

 Degree Courses

       College
       Study Abroad

Career Courses

        Career Courses