Management Information System
Prof. Kunal Kanti Ghosh
Vinod Gupta School of Management
Indian Institute of Technology, Kharagpur
Week – 10
Module – 02
Lecture - 47
Decision Support Systems
Hi, welcome back to our 2nd module of the 10th week related to our course on Management Information Systems! In this module, we are going to discuss about ‘Decision Support Systems’. We will be basically covering certain introductory concepts related to ‘decision support systems (DSS)’. And, we will also mention the essential differences between MIS and decision support system (DSS).
(Refer Slide Time: 01:30)
So, what is decision support system? Decision support systems are primarily man computer interactive systems, which aid management in making decisions. So, there is an interaction between man and computer. So, in decision support systems we combine computers ability to process databases and models with manager’s ability to draw on his experience and exercise his judgment.
So, manager’s ability to draw on experience and judgment is combined with the computer’s ability to process database and models in any decision support system.
(Refer Slide Time: 03:10)
So, basically the scope of this discussion in this module is limited to the role played by decision support systems in solving managerial decision problems, we will talk something about the basic components of a DSS. And, we will talk about the basic steps involved in design of a DSS.
(Refer Slide Time: 03:57)
Now, before we go into the details of decision support systems. We need to know, what are the different types of managerial decision problems? And, first of all what is decision making? So, decision making basically refers to choosing one among the several alternatives
that exist to solve a particular problem that the managers are facing. The managers they try to find out the best alternative among the possible alternatives, but sometimes and in most cases, they are more bothered about finding an effective solution rather than finding an efficient solution.
We will talk about the difference between an effective solution and efficient solution slightly later. The managerial decision problems can be classified into structured, unstructured, and semi structured problems. And, the category into which a decision problem false will depend on how well, it is objectives can be defined and whether there exists well established procedures for solving such kind of problems.
Problems where there is well defined objective as well as well established procedures exist for solving those problem are known as structured decision problems. So, structured decision problems are those where we have a very well defined objective or well defined objectives. And, well established solution procedures for solving them; ok.
(Refer Slide Time: 07:38)
And unstructured problems, unstructured decision problems are those where the objectives are vague and there exists no well-established solutions’ techniques; they are unstructured decision problems; so, problems with vague objectives and with no well-established solution techniques, for example, new products development.
New products to be manufactured in a portfolio of new product completely unstructured one, but look at the inventory replenishment problem in an organization, here the objective is very well defined and the procedure is well set. Whenever the stock level of any product falls below a pre specified quantity, which is known as the reorder level a new order has to be generated and placed onto the solution, placed onto the suppliers, in terms of purchase orders.
And, the quantity, which is specified as order quantity, there are various well, established procedures for computing that. Semi structured problems lie in between structured decision problems and unstructured ones. Sometimes semi structured problems combine the features of both, in semi structured problems, we may have a well-defined objective, but there exists no established solution procedures for solving them, or sometimes there exists several solution procedures.
But, the objective cannot be set rightly, very difficult to set specific objectives for the problem at hand. And, it is those class of problems that is the semi structured problems, which are candidates for getting solved through decision support systems. So, DSS is primarily meant for solving semi structured problems.
(Refer Slide Time: 11:01)
You see the structured problems where the objective is very specific and established well solution procedures are there. May be completely delegated to the computer whereas, the unstructured problems. For example, generation of a strategy, there computer is of no help,
new products that need to be manufactured or developed, completely unstructured and this kind of problems need to be solved by the manager alone.
The semi structured problem that lie between the structured and unstructured ones cannot be solved wholly by a computer or by a manager alone. They require an interaction between the manager and the computer. And, hence there is a need for a man computer team to interact with each other to generate solution for this class of problems. And, it is therefore, in handling the semi structured problems, decision support systems are widely used, where the emphasis is on generating effective solutions rather than trying to find out efficient solutions.
(Refer Slide Time: 13:26)
Let us now talk about the different phases of a decision making process. Primarily there are 3 phases; the intelligence phase, the design phase, and the choice phase. In the intelligence phase the decision maker or the manager, scans the overall business environment, or the surrounding environment, which influences the business, processes raw data, and then identify a particular problem or identify the problem areas.
In the design phase what we see is that for the problems that have been identified in the intelligence phase. Managers try to find out or formulate various alternatives to solve that problem. So, these various alternatives that exist are analysed in detail during the design phase. And, in the choice phase a selection is made from the proposed alternatives and the chosen alternative is implemented. We need to know these phases because that will help us in the design of decision support systems.
(Refer Slide Time: 15:29)
If, we look at the problem solving process in a decision support systems, we find that mainly the process is iterative as well as interactive. What happens is that, the computer provides some output to the manager based on the different inputs that the manager has already provided.
The manager then interprets those output. After, his interpretation he may provide new input to the system, or he may modify the existing data, or the manager might ask new questions as part of the output that should be generated from the system. So, in here the computers major tools are the models. These models may be both simple and sophisticated whereas, the manager uses mostly his experience and judgment.
So, right in the beginning we said that it is an interaction between the manager and the computer. Is not only interactive, it is iterative, because the process may have to be repeated several times in order to get an effective solution which is satisfactory for the management group.
(Refer Slide Time: 17:58)
The models that are used in decision support systems, consists of finding out relationships between major elements of the systems that we are going to study. And, such relationships that we are studying usually involve a certain degree of generalization. The output of the models will be an approximation of the behaviour of the real system. And, these models will be valid only if certain assumptions about the real system are satisfied.
(Refer Slide Time: 19:12)
Let us talk about the difference between management information system and decision support system. DSS designer views effectiveness as more important than efficiency.
Effectiveness involves identifying, what should be done and ensuring that the chosen criteria is a relevant one. That means, in an effective solution, we first question that whether the chosen objective is the right one or not, whether the manager is doing the right job that is the first thing.
Choosing the right objective is the most important thing in trying to find out an effective solution. Having chosen the right objective or a relevant objective, then we try to find out a satisfying solution for the same. Whereas, efficiency involves some kind of an optimization approach, finding the best solution approach, involving minimization of time, cost, or minimization of effort, in performing a specified activity. In DSS, the computer is used not to replace the decision maker, but to enhance the manager’s decision making abilities.
(Refer Slide Time: 21:48)
In decision support system the manager plays a very active role, using his or her experience and judgment wherever necessary, and controls as well as directs the computer in it is tasks. Because, in various iterations sometimes new inputs are being provided by the managers sometimes there are modification of data.
(Refer Slide Time: 22:30)
Not all DSS need to include models in order to be effective. Models are important components of DSS, but there are many simple decision support systems wherein the models are not necessary. Decision support systems can be simple data retrieval facilities and yet they may be highly useful in aiding decision making.
(Refer Slide Time: 23:07)
So, when we talk about the range of capabilities of a decision support system, we can list them as retrieving information from the database, providing mechanisms for ad HOC data analysis that can be also a DSS. DSS can provide pre specified aggregation of data and
generate various forms of reports. DSS can estimate the consequences of proposed decisions or it can propose various decisions new rules by analysing the data.
(Refer Slide Time: 24:05)
So, the need for decision support systems arises particularly in cases, where the problem is semi structured. Means the parameters of the problem may not be clearly defined and in semi structured problem another important thing happens is that the parameters governing the problems are firmed up as one proceeds, through the solution process.
DSS is also used widely in cases, where the inputs for a given problem are dynamic in nature. That means, the inputs that are required for solving the problem are not fixed, this data change from time over time this pattern of data changes, for example, incorporation of new customer or change in demand from the customer.
(Refer Slide Time: 25:42)
So, whenever the demand changes a fresh set of input comes in. Decision support systems rely more heavily on modelling than management information systems. Sometimes the models may be very simple, simple mathematical analytical models. We can use a spreadsheet to perform, what if or other kinds of such analysis through a spreadsheet. So, what are those ‘what-if’ type of analysis, that we perform every day on a daily basis through excel.
‘What-if’ analysis works in the forward direction from some given condition or assumed conditions. It allows the manager to vary or change certain input values or test results to determine or predict outcomes whenever some changes occur in the input values of those inputs.
(Refer Slide Time: 27:19)
For example, here we have given 2 examples what happens? If we raise prices of a product by 10 percent or increase the advertising budget by rupees say 10 lakhs, what happens to the profit or what happens to the total revenue? If the price is increased by 10 percent or advertising budget is raised by 10 lakhs. So, sensitivity analysis models ask, what if questions repeatedly to predict a range of outcomes.
(Refer Slide Time: 28:29)
When one or more input variables are changed multiple times? Backward sensitivity analysis helps decision makers with goal seeking. For example, if the user wants to sell one million
product units next year, how much he or she should reduce the price of the product? So, the goal is specified. Now, you try to see what should be the values for the input variables. This also can be accomplished through the use of simple spreadsheet models, using that goal seek function.
(Refer Slide Time: 29:15)
Multi-dimensional data analysis and OLAP tools are also some of the key business intelligence techniques that are of late deployed in decision support systems. And multi-dimensional analysis through excel spreadsheets take the help of this pivot table, pivot analysis. Managers they use this pivot table to identify and understand patterns in business information that may be useful for solving semi structured problems.
(Refer Slide Time: 30:11)
In the past, much of this modelling was done with spreadsheets and small standalone databases. But, today these capabilities are incorporated into large enterprise business intelligence systems, where they are able to analyse data from large corporate databases.
(Refer Slide Time: 30:45)
There are many other problem areas for which decision support systems have been reported to have been successfully employed. For example, some of these problems are when the managers they have to take decisions related to merger of different companies. So, problems
related to acquisition and merger of companies are mostly semi structured and lot of decision support systems have been deployed for solving such kind of problems.
Budget planning, portfolio management in banks, corporate planning, as well as capacity planning in production are some of the examples, where decision support systems have been successfully deployed and have found lot of popularity.
(Refer Slide Time: 32:00)
So, these are the references that I have used for preparing this module.
And, thank you all for your patience!
Log in to save your progress and obtain a certificate in Alison’s free Diploma in Information Systems: Emerging Technologies and Globalization online course
Sign up to save your progress and obtain a certificate in Alison’s free Diploma in Information Systems: Emerging Technologies and Globalization online course
Please enter you email address and we will mail you a link to reset your password.