# Mb0048 Solved Assignment In Excel

MB0048 –Operation ResearchQ1. a. Explain how and why Operation Research methods have been valuable in aidingexecutive decisions.b. Discuss the usefulness of Operation Research in decision making process and the role of computers in this field.Ans.

Churchman, Aackoff and Aruoff defined Operations Research as:

“

the application of scientificmethods, techniques and tools to operation of a system with optimum solutions to the problems

”,

where

‘optimum’

refers to the best possible alternative.The objective of Operations Research is

to provide a scientific basis to the decision-makers for solving problems involving interaction of various components of the organisation. You canachieve this by employing a team of scientists from different disciplines, to work together for finding the best possible solution in the interest of the organisation as a whole.

The solution thusobtained is known as an optimal decision.You can also define Operations Research as

“

The use of scientific methods to provide criteria for decisions regarding man, machine, and systems involving repetitive operations

”.OR

“OperationTechniques is a bunch of mathematical techniques.”

b. “Operation Research is an aid for the executive in making his decisions based onscientific methods analysis”. Discuss the above statement in brief.Ans.

“Operation Research is an aid for the executive in making his decisions based on scientificmethods analysis”.

Discussion:-

Any problem, simple or complicated, can use OR techniques to find the best possible solution.This section will explain the scope of OR by seeing its application in various fields of everydaylife.i)

In Defense Operations:

In modern warfare, the defense operations are carried out by threemajor independent components namely Air Force, Army and Navy. The activities in each of these components can be further divided in four sub-components namely: administration,intelligence, operations and training and supply. The applications of modern warfare techniquesin each of the components of military organisations require expertise knowledge in respectivefields. Furthermore, each component works to drive maximum gains from its operations andthere is always a possibility that the strategy beneficial to one component may be unfeasible for another component. Thus in

Spring 2013

Master of Business Administration- MBA Semester 1MB0048

–

Operations Research- 4 Credits(Book ID: B1631) Assignment Set - 1 (60 Marks)

Note: Assignment Set -1 must be written within 6-8 pages. Answer all questions.Q1.

Explain the scope of Operations Research. What are the features of OperationsResearch?

10 marks

Q2.

Six Operators are to be assigned to five jobs with the cost of assignment in Rs. givenin the matrix below. Determine the optimal assignment. Which operator will have noassignment?

Operators

Jobs

1

2

3

4

5

1

6 2 5 2 6

2

2 5 8 7 7

3

7 8 6 9 8

4

6 2 3 4 5

5

9 3 8 9 7

6

4 7 4 6 8

10 marks

Q3.

a. Explain the Monte Carlo Simulation. b. A Company produces 150 cars. But the production rate varies with the distribution.

Production Rate

147 148 149 150 151 152 153

Probability

0.05 0.10 0.15 0.20 0.30 0.15 0.05At present the track will hold 150 cars. Using the following random numbersdetermine the average number of cars waiting for shipment in the company andaverage number of empty space in the truck. Random Numbers 82, 54, 50, 96, 85,34, 30, 02, 64, 47.

5 +5 = 10marks(200 - 250words each)

Q4.

Explain the Characteristics and Constituents of a Queuing System.

10 marks(300 - 350wordseach)

Research?

ForCompleteSolvedSMU Assignment @1500 to 2000 RsEmail:mba8182@gmail.comPh:+91 -9873669404

http://www.smuassignments.net/

## 0 thoughts on “Mb0048 Solved Assignment In Excel”