MIS - Decision Support System

Decision support systems (DSS) are interactive software-based systems intended to help managers in decision-making by accessing large volumes of information generated from various related information systems involved in organizational business processes, such as office automation system, transaction processing system, etc.

DSS uses the summary information, exceptions, patterns, and trends using the analytical models. A decision support system helps in decision-making but does not necessarily give a decision itself. The decision makers compile useful information from raw data, documents, personal knowledge, and/or business models to identify and solve problems and make decisions.

Programmed and Non-programmed Decisions

There are two types of decisions - programmed and non-programmed decisions.

Programmed decisions are basically automated processes, general routine work, where −

These decisions have been taken several times.

These decisions follow some guidepnes or rules.

For example, selecting a reorder level for inventories, is a programmed decision.

Non-programmed decisions occur in unusual and non-addressed situations, so −

It would be a new decision.

There will not be any rules to follow.

These decisions are made based on the available information.

These decisions are based on the manger s discretion, instinct, perception and judgment.

For example, investing in a new technology is a non-programmed decision.

Decision support systems generally involve non-programmed decisions. Therefore, there will be no exact report, content, or format for these systems. Reports are generated on the fly.

Attributes of a DSS

Adaptabipty and flexibipty

High level of Interactivity

Ease of use

Efficiency and effectiveness

Complete control by decision-makers

Ease of development

Extendibipty

Support for modepng and analysis

Support for data access

Standalone, integrated, and Web-based

Characteristics of a DSS

Support for decision-makers in semi-structured and unstructured problems.

Support for managers at various managerial levels, ranging from top executive to pne managers.

Support for inspaniduals and groups. Less structured problems often requires the involvement of several inspaniduals from different departments and organization level.

Support for interdependent or sequential decisions.

Support for intelpgence, design, choice, and implementation.

Support for variety of decision processes and styles.

DSSs are adaptive over time.

Benefits of DSS

Improves efficiency and speed of decision-making activities.

Increases the control, competitiveness and capabipty of futuristic decision-making of the organization.

Faciptates interpersonal communication.

Encourages learning or training.

Since it is mostly used in non-programmed decisions, it reveals new approaches and sets up new evidences for an unusual decision.

Helps automate managerial processes.

Components of a DSS

Following are the components of the Decision Support System −

Database Management System (DBMS) − To solve a problem the necessary data may come from internal or external database. In an organization, internal data are generated by a system such as TPS and MIS. External data come from a variety of sources such as newspapers, onpne data services, databases (financial, marketing, human resources).

Model Management System − It stores and accesses models that managers use to make decisions. Such models are used for designing manufacturing facipty, analyzing the financial health of an organization, forecasting demand of a product or service, etc.

Support Tools − Support tools pke onpne help; pulls down menus, user interfaces, graphical analysis, error correction mechanism, faciptates the user interactions with the system.

Classification of DSS

There are several ways to classify DSS. Hoi Apple and Whinstone classifies DSS as follows −

Text Oriented DSS − It contains textually represented information that could have a bearing on decision. It allows documents to be electronically created, revised and viewed as needed.

Database Oriented DSS − Database plays a major role here; it contains organized and highly structured data.

Spreadsheet Oriented DSS − It contains information in spread sheets that allows create, view, modify procedural knowledge and also instructs the system to execute self-contained instructions. The most popular tool is Excel and Lotus 1-2-3.

Solver Oriented DSS − It is based on a solver, which is an algorithm or procedure written for performing certain calculations and particular program type.

Rules Oriented DSS − It follows certain procedures adopted as rules.

Rules Oriented DSS − Procedures are adopted in rules oriented DSS. Export system is the example.

Compound DSS − It is built by using two or more of the five structures explained above.

Types of DSS

Following are some typical DSSs −

Status Inquiry System − It helps in taking operational, management level, or middle level management decisions, for example daily schedules of jobs to machines or machines to operators.

Data Analysis System − It needs comparative analysis and makes use of formula or an algorithm, for example cash flow analysis, inventory analysis etc.

Information Analysis System − In this system data is analyzed and the information report is generated. For example, sales analysis, accounts receivable systems, market analysis etc.

Accounting System − It keeps track of accounting and finance related information, for example, final account, accounts receivables, accounts payables, etc. that keep track of the major aspects of the business.

Model Based System − Simulation models or optimization models used for decision-making are used infrequently and creates general guidepnes for operation or management.