This chapter begins by summarizing the phases of the decision-making process and the types of decisions that are made. Next, you learn about a decision support system (DSS), its components and its capabilities, and see how it can benefit an organization. In addition, you learn about other management support systems used in decision making: executive information systems (EISs), group support systems (GSSs), and geographic information systems (GISs). This chapter concludes with an overview of guidelines for designing a management support system.
In a typical organization, decisions fall into one of these categories:
● Structured decisions—Structured decisions, or programmable tasks, can be automated because a well-defined standard operating procedure exists for these types of decisions. Record keeping, payroll, and simple inventory problems are examples of structured tasks. Information technologies are a major support tool for making structured decisions.
● Semistructured decisions—Semistructured decisions are not quite as well defined by standard operating procedures, but they include a structured aspect that benefits from information retrieval, ana- lytical models, and information systems technology. For example, preparing budgets has a structured aspect in calculating percentages of available funds for each department. Semistructured decisions are often used in sales forecasting, budget prepa- ration, capital acquisition analysis, and computer configuration.
For example, a manager might want to give raises to employees to boost morale and increase employee retention but has been asked to reduce the total cost of production. These two objectives conflict, at least in the short run. Artificial intelligence applications (discussed in Chapter 13) might be helpful in the future for handling qualitative decisions. Exhibit 12.1 shows organizational levels (operational, tactical, and strategic) and types of decisions. Different types of information systems have been developed to support certain aspects and types of decisions. Collectively, these systems are called management support systems (MSSs), and each type is designed with its own goals and objectives, as discussed in this chapter.
Unstructured decisions—Unstructured decisions are typically one-time decisions, with no standard operating procedure pertaining to them. The decision maker’s intuition plays the most important role, as information technology offers little support for these decisions. Areas involving unstructured decisions include research and development, hiring and firing, and introducing a new product.
Semistructured and unstructured decisions are challenging because they involve multiple criteria, and often users have to choose between conflicting objectives.
Unstructured decisions are typically one-time decisions, with no standard operating procedure pertaining to them.
Management support systems (MSSs) are the different types of information systems that have been developed to support certain aspects and types of decisions. Each type of MSS is designed with unique goals and objectives.
In the intelligence phase, a decision maker examines the organization’s environment for conditions that need decisions. Data is collected from a variety of sources (internal and external) and processed. From this information, the decision maker can discover ways to approach the problem.
12-1a Phases of the Decision-Making Process
Herbert Simon, winner of the 1978 Nobel Prize in economics, defines three phases in the decision-making process: intelligence, design, and choice.1 A fourth phase, implementation, can be added. The following sections explain these phases.
Intelligence Phase
In the intelligence phase, a decision maker (a marketing manager, for example) examines the organization’s environment for conditions that need decisions. Data is collected from a variety of sources (internal and external) and processed. From this information, the decision maker can discover ways to approach the problem. This phase has three parts: First, you determine what the reality is— identify what is really going on in order to help define the problem. Second, you get a better understanding of the problem by collecting data and information about it. Third, you gather data and information needed to define alternatives for solving the problem. As an example, say an organization has noticed a decrease in total sales over the past 6 months. To pin- point the cause of the problem, the organization can collect data from customers, the marketplace, and the competition. After the data has been processed, analysis can suggest possible remedies. Information technologies, particularly database management systems, can help in this analysis. In addition, many third-party vendors, such as Nielsen and Dow Jones, specialize in collecting data about the marketplace, the competition, and the general status of the economy. The information they collect can support the intelligence phase of decision making.
Design Phase
In the design phase, the objective is to define criteria for the decision, generate alternatives for meeting the criteria, and define associations between the criteria and the alternatives. Criteria are goals and objectives that decision makers establish in order to achieve certain performance levels. For example, the criterion in the previous example of decreased sales might simply be to increase sales. To make this criterion more specific, you can state it as “Increase sales by 3 percent each month for the next 3 months.” Next, the following alternatives could be generated:
● Assign more salespeople to the target market.
● Retrain and motivate current salespeople.
● Reassign current salespeople.
● Revamp the product to adjust to consumers’ changing tastes and needs.
● Develop a new advertising campaign.
● Reallocate existing advertising to other media.
Defining associations between alternatives and criteria involves understanding how each alternative affects the criteria. For example, how would increasing the sales force increase sales? By how much does the sales force need to be increased to achieve a 3 percent increase in sales? Generally, information technology does not support this phase of decision making very much, but group support systems and electronic meeting systems, discussed later in this chapter, can be useful. Expert systems (covered in Chapter 13) are helpful in generating alternatives, too.
Choice Phase
The choice phase is usually straightforward. From the practical alternatives, the best and most effective course of action is chosen. It starts with analyzing each alternative and its relationship to the criteria to deter- mine whether it is feasible. For instance, for each sales-person added, how are sales expected to increase? Will this result be economically beneficial? After a thorough analysis, the choice phase ends with decision makers recommending the best alternative. For the problem of decreased sales, the organization decided to use the first alternative, assigning more salespeople to the target market. A decision support system (DSS) can be particularly useful in this phase. DSSs are discussed later in the chapter, but these systems help sort through possible solutions to choose the best one for the organization. Typically, they include tools for calculating cost–benefit ratios, among others. For example, say an organization is deciding which of three transportation systems to use for shipping its products to retail outlets. A DSS can assess cost factors and determine which transportation system minimizes costs and maximizes profits. Generally, information technologies are more useful in the intelligence and choice phases than in the design phase.
Implementation Phase
In the implementation phase, the organization devises a plan for carrying out the alternative selected in the choice phase and obtains the resources to implement the plan. In others words, ideas are converted into actions. Information technologies, particularly DSSs, can also be useful in this phase. A DSS can do a follow-up assessment on how well a solution is performing. In the previous example of selecting a transportation system, a DSS might reveal that the system the organization chose is not performing as well as expected and suggest an alternative.
DECISION SUPPORT SYSTEMS
For the purposes of this book, a decision support system (DSS) is an interactive information system consisting of hardware, software, data, and models (mathematical and statistical) designed to assist decision makers in an organization. The emphasis is on semistructured and unstructured tasks. A DSS should meet the following requirements:
● Be interactive.
● Incorporate the human element as well as hardware and software.
● Use both internal and external data.
● Include mathematical and statistical models.
● Support decision makers at all organizational levels.
● Emphasize semistructured and unstructured tasks.
12-2a Components of a Decision Support System
A DSS, shown in Exhibit 12.2, includes three major components: a database, a model base, and a user interface. In addition, a fourth component, the DSS engine, manages and coordinates these major components. The database component includes both internal and external data, and a database management system (DBMS) is used for creating, modifying, and maintaining the database. This component enables a DSS to perform data analysis operations.
The model base component includes mathematical and statistical models that, along with the database, enable a DSS to analyze information. A model base management system (MBMS) performs tasks similar to a DBMS in accessing, maintaining, and updating models in the model base. For example, an MBMS might include tools for conducting what-if analysis so a forecasting model can generate reports showing how forecasts vary, depending on certain factors.
Finally, the user interface component is how users access the DSS, such as when querying the database or model base, for help in making decisions. From the end user’s point of view, the interface is the most important part of a DSS and must be as flexible and user friendly as possible. Because most DSS users are senior executives with little computer training, user friendliness is essential in these systems.
DSS Capabilities
DSSs include the following types of features to support decision making:
● What-if analysis—This shows the effect of a change in one variable, answering questions such as “If labor costs increase by 4 percent, how is the final cost of a product affected?” and “If the advertising budget increases by 2 percent, what is the effect on total sales?”
Goal seeking—This is the reverse of what-if analysis. It asks what has to be done to achieve a particular goal—for example, how much to charge for a product in order to generate $200,000 profit, or how much to advertise a product to increase total sales to $50,000,000.
Sensitivity analysis—This enables you to apply different variables, such as determining the maximum price you could pay for raw materials and still make a profit, or determining how much the interest rate has to go down for you to be able to afford a $100,000 house with a monthly payment of $700.
Exception reporting analysis—This monitors the performance of variables that are outside a defined range, such as pinpointing the region that generated the highest total sales or the production center that went over budget.
A typical DSS has many more capabilities, such as graphical analysis, forecasting, simulation, statistical analysis, and modeling analysis.
Roles in the DSS Environment
To design, implement, and use a DSS, several roles are involved. These include the user, managerial designer, technical designer, and model builder.
Users comprise the most important category because they are the ones using the DSS; therefore, the system’s success depends on how well it meets their needs. Users can include department or organizational units in addition to people.
A managerial designer defines the management issues in designing and using a DSS. These issues do not involve the technological aspects of the system; they are related to management’s goals and needs. This person specifies data requirements, what models are needed, how these models might be used, and how users want to view the results (graph- ics, text, and so forth). This role addresses questions such as the following:
What type of data should be collected, and from what sources?
● How recent should the collected data be?
● How should the data be organized?
● How should the data be updated?
● What should the balance between aggregated (lump sum) and disaggregated (itemized) data be? The technical designer focuses on how the DSS is implemented and usually addresses the following questions:
● How should the data be stored (centralized, decen- tralized, or distributed)?
● What type of file structure should be used (sequential, random, or indexed sequential)?
● What type of user access should be used? Menu driven, such as QBE? Or command line, such as SQL?
● What type of response time is required?
● What types of security measures should be installed?
The technical designer might be a computer speciallist or a consultant from outside the company and may use a commercial DSS package or write the system’s code from scratch.
A model builder is the liaison between users and designers. For example, during the design phase, the model builder might explain users’ needs to the managerial designer or technical designer. Later, during the implementation phase, this person might explain the output of a regression analysis to users, describing the assumptions underlying the model, its limitations, and its strengths. The model builder is responsible for sup- plying information on what the model does, what data inputs it accepts, how the model’s output should be interpreted, and what assumptions go into creating and using the model. Typically, requirements for what the model should do come from the managerial designer, implementation of the model is carried out by the technical designer, and specifications for the model come from the model builder. The model builder can also suggest new or different applications of a DSS.
Costs and Benefits of Decision Support Systems
Some DSSs can be developed from resources already available in the organization, which can reduce costs, but many require new hardware and software. Before making this investment, organizations should weigh the costs and benefits of using a DSS. Costs and benefits can be difficult to assess, however, because these systems are focused on effectiveness rather than efficiency. In addition, a DSS facilitates improvements but does not necessarily cause them. For example, how do you assign a monetary value to facilitating communication or expediting problem solving?
Peter G. Keen, a former MIT professor, conducted an interesting study on how organizations use DSSs and concluded that the decision to build a DSS seems to be based on value rather than cost. He outlined the benefits of a DSS as follows:4
● Increase in the number of alternatives examined
● Fast response to unexpected situations
● Ability to make one-of-a-kind decisions
● New insights and learning
● Improved communication
● Improved control over operations, such as controlling the cost of production
● Cost savings from being able to make better decisions and analyze several scenarios (what-ifs) in a short period
● Better decisions
● More effective teamwork
● Time savings
● Better use of data resources
As this study indicates, most of the benefits are intangible and difficult to assess. However, they can be quantified to a degree, although the quantification might vary, depending on the person doing the calculations. You can quantify the benefit of saving time, for instance, by measuring the two hours a manager wasted looking for information that a DSS could have made available immediately. Of course, you would probably also notice that a manager who did not have to waste this much time is less frustrated and more productive, but quantifying these results is harder, or at least requires more work, such as conducting interviews or surveys.
The benefit of improving communication and interactions between management and employees is perhaps the most difficult to quantify, but it is one of the most important.5 DSSs can, and are, improving how decision makers view themselves, their jobs, and the way they spend time. Therefore, improving communication and expediting learning are among the main objectives of a DSS.
A DSS is said to have achieved its goals if employees find it useful in doing their jobs. For example, a portfolio manager who uses a financial DSS to analyze different scenarios would certainly find the ease of analyzing a variety of variables, such as the interest rate and economic forecasts, to be useful. The manager can try different values for these variables quickly and easily to determine which variable has the greatest effect and decide which portfolio will be the most profitable. In addition, some DSSs result in saving on clerical costs, and others improve the decision- making process. The information box on the next page describes the DSS applications at Family Dollar, a retail merchandise chain.
Executive information systems (EISs), a branch of DSSs, are interactive information systems that give executives easy access to internal and external data and typically include “drill-down” features (explained in Chapter 3) and a digital dashboard for examining and analyzing information. (Although some experts consider executive support systems and executive management systems variations of EISs, this book considers them to fall under the term EIS.)
Ease of use plays an important role in the success of an EIS. Because most EIS users are not computer experts, simplicity of the system is crucial, and EIS designers should focus on simplicity when developing a user interface. Typically, GUIs are used, but adding features such as multimedia, virtual reality, and voice input and output can increase ease of use.
Another important factor in an effective EIS is access to both internal and external data so executives can spot trends, make forecasts, and conduct different types of analyses. For an EIS to be useful, it should also collect data related to an organization’s “critical success factors”—issues that make or break a business. In banks, interest rates are considered a critical success factor; for car manufacturers, location of dealerships might be a critical success factor. An EIS should be designed to provide information related to an organization’s critical success factors.
Most EISs include a digital dashboard, which integrates information from multiple sources and pre- sents it in a unified, understandable format, often as charts and graphs. Digital dashboards and scorecards offer up-to-the minute snapshots of information and assist decision makers in identifying trends and potential problems. Many digital dashboards are Web based, such as the one included in Microsoft SharePoint. Exhibit 12.3 shows an example of a digital dashboard.
The following are some important characteristics of an EIS:
● Tailored to meet management’s information needs
● Can extract, compress, filter, and track critical data
● Provides online status access, trend analysis, and exception reporting
● Offers information in graphical, tabular, and text formats
● Includes statistical analysis techniques for summarizing and structuring data
● Retrieves data in a wide range of platforms and data formats
● Contains customized application-development tools
● Supports electronic communication, such as e-mail and video conferencing
Reasons for Using EISs
An EIS can put a wealth of analytical and decision-making tools at managers’ fingertips and includes graphical representations of data that helps executives make critical decisions. In addition, executives can use EISs to share information with others more quickly and easily. Managers can use these tools to improve the efficiency and effective- ness of decision making in the following ways:
● Increase managers’ productivity by providing fast and easy access to relevant information.
● Convert information into other formats, such as bar charts or graphs, to help managers analyze different business scenarios and see the effect of certain decisions on the organization.
● Spot trends and report exceptions, such as gathering data on profitability and production costs at a manufacturing plant to determine whether closing the plant is more beneficial than keeping it open.
Avoiding Failure in Design and Use of EISs
As with other management support systems, effective design and implementation of an EIS requires top- management support, user involvement, and the right technologies. The following factors can lead to a failed EIS:
The corporate culture is not ready, there is organizational resistance to the project, or the project is viewed as unimportant.
● Management loses interest or is not committed to the project.
● Objectives and information requirements cannot be defined clearly, or the system does not meet its objectives.
● The system’s objectives are not linked to factors critical to the organization’s success.
● The project’s costs cannot be justified.
● Developing applications takes too much time, or the system is too complicated.
● Vendor support has been discontinued.
● Some of today’s senior executives missed the computer revolution and might feel uncomfortable using computers. Ongoing education and increasing computer awareness should solve this problem.
● Executives’ busy schedules and frequent travel make long training sessions difficult, do not allow much uninterrupted time for system use, and often prevent daily use of an EIS. The result is that senior executives are unlikely to use systems that need considerable training and regular use to learn. A user-friendly interface can encourage executives to use an EIS more often, however.
● Some EISs do not contain the information that senior executives need because there is a lack of understand- ing about what executives’ work involves. Designers must determine what types of information executives need before designing a system.
12-3c EIS Packages and Tools
EISs are generally designed with two or three components: an administrative module for managing data access, a builder module for developers to configure data mapping and screen sequencing, and a runtime module for using the system. Sometimes, administrative and builder modules are combined into one module. Some EIS packages provide a data storage system, and some simply package data and route it to a database, usually on a LAN. Most EIS packages come with a stan- dard graphical user interface (GUI).
Generally, managers perform six tasks for which an EIS is useful: tracking performance, flagging exceptions, ranking, comparing, spotting trends, and investigating/exploring. Most EIS packages provide tools for these tasks, such as displaying summaries of data in report or chart format and sequencing screens to produce slide shows. Exception or variance reportng is another useful technique that managers use to flag data that is unusual or out of normal boundaries. Both unusual and periodic events can be defined to trigger visual cues or activate intelligent agents to perform a specific task. Intelligent agents, covered in Chapter 13, are “smart” programs that carry out repeti- tive tasks and can be programmed to make decisions based on specified conditions. Widely used EIS pack- ages include SAS Business Intelligence (www.sas.com /technologies/bi), Datawatch (www.datawatch.com), and Cognos PowerPlay (www-01.ibm.com/software/data /cognos/products/series7/powerplay).
Group support systems (GSSs) assist decision makers working in groups. These systems use computer and communication technologies to formulate, process, and implement a decision-making task and can be considered a kind of intervention technology that helps overcome the limitations of group interactions.
The information box on the next page describes the EIS applications at Hyundai Motor Company.
12-4 GROUP SUPPORT SYSTEMS
In today’s business environment, decision makers often work in groups, so you hear the terms group computing or collaborative computing used often. All major software vendors are competing to enter this market or increase their market share in this fast-growing field. In this collaborative environment, there has been an increase in group support systems (GSSs), which are intended to assist decision makers working in groups. DSSs are usually designed to be used by a particular decision maker; a GSS is designed to be used by more than one decision maker. These systems use computer and communication technologies to formulate, process, and implement a decision-making task and can be considered a kind of intervention technology that helps overcome the limitations of group interactions. The intervention aspect of a GSS reduces communication barriers and introduces order and efficiency into situations that are inherently unsystematic and inefficient, such as group meetings and brainstorming sessions. A GSS, with the help of a human facilitator, enhances decision making by providing a clear focus for group discussion, minimizing politicking, and focusing attention on critical issues. The success of a GSS depends on the following:
● Matching the GSS’s level and sophistication to the group’s size and the scope of the task
● Providing supportive management (especially at the CEO level) that is willing to “champion” using a GSS in the organization
Related technologies for group support, such as electronic meeting systems (EMSs), groupware, computer-mediated communication (CMC), computer- supported cooperative work (CSCW), and e-collabo- ration, are not considered full-function GSSs because they do not have decision-making tools, but they are less expensive and include communication and problem- solving mechanisms for effective team management.
GSSs are useful for committees, review panels, board meetings, task forces, and decision-making sessions that require input from several decision makers. They can be used to find a new plant location, introduce a new product or advertising campaign, participate in an international bid, brainstorm alternatives, and other tasks. In addition to all the capabilities of a DSS, a GSS should include communication features so decision makers in many different locations can still work together to participate in the decision-making process.
Groupware
The goal of groupware is to assist groups in communicating, collaborating, and coordinating their activities. It is intended more for teamwork than for decision support. For the purposes of this book, groupware is a collection of applications that supports decision makers by providing access to a shared environment and information. A shared environment can consist of an e-mail message, a memo, a single file, or even an entire database.
Groupware is software that helps a group of decision makers work with the same application, regardless of their locations. Groupware tools include e-mail, chat applications, video conferencing, and database sharing. IBM Lotus Notes, Microsoft SharePoint (see the information box on Microsoft Office SharePoint Server above), and Novell GroupWise are common examples of groupware, the capabilities of which include the following:
· Audio and video conferencing
· Automated appointment books
· Brainstorming
· Database access
· E-mail
· Online chat
· Scheduling
· To-do lists
· Workflow automation
LANs, WANs, and MANs, discussed in Chapter 6, are the network foundations for groupware. Although e-mail is not the same thing as groupware, it provides the main functions of groupware: transmitting text messages across a network. The information box on the next page introduces an application of groupware in the healthcare industry.
The Internet has become an important part of group- ware. The most important advantage of a Web-based GSS is being able to use open network standards, meaning the GSS can be used on any operating system or type of workstation. The most notable disadvantages are speed limitations (because the Internet is often slower than a company’s proprietary network) and security issues. Some examples of Web-based GSS tools are Microsoft Office SharePoint Server and IBM Lotus Domino. Another type of software used for e-collaboration is an electronic meeting system, such as Microsoft Live Meeting, Metastorm, and IBM FileNet.
The second information box on the next page high- lights the major components of Google Apps for Work as a comprehensive tool for remote collaboration.
Electronic Meeting Systems
Electronic meeting systems enable decision makers in different locations to participate in a group decision- making process. There are various types, but they all have the following features:
● Real-time computer conferencing—This allows a group of people to interact via their workstations and share files, such as documents and images. The conference often includes an audio link, but there is no video capability.
● Video teleconferencing—The closest thing to a face- to-face meeting, this requires special equipment and sometimes trained operators. Video cameras are used to transmit live pictures and sounds, which makes video teleconferencing more effective than phone conferenc- ing but also more expensive. The main drawback is that participants cannot share text and graphics.
● Desktop conferencing—This combines the advantages of video teleconferencing and real-time computer con- ferencing. With desktop conferencing, participants can have multiple video windows open at one time. They also have interfaces to a conference installed on their
Electronic meeting systems enable decision makers in different locations to participate in a group decision-making process.
workstations, so these systems are easier for employ- ees to use. The information box below highlights new generations of electronic meeting systems.
12-4c Advantages and Disadvantages of GSSs Advantages of GSSs include the following:
● Because decision makers do not have to travel as much (which includes paying for planes, hotels, and meals), costs as well as stress levels are reduced.
● Because decision makers are not traveling long dis- tances, they have more time to talk with one another and solve problems.
● Shyness is not as much of an issue in GSS sessions as it is in face-to-face meetings.
● Increasing collaboration improves the effectiveness of decision makers.
Disadvantages of GSSs include the following:
● Lack of the human touch—Gestures, handshakes, eye contact, and other nonverbal cues can be lost, which can hinder the effectiveness of meetings. New devel- opments in virtual reality technologies (discussed in Chapter 14) could solve this problem, however.
● Unnecessary meetings—Because arranging a GSS ses- sion is easy, there is a tendency to schedule more meet- ings than are necessary, which wastes time and energy.
● Audio and video conferencing Automated appointment books Brainstorming
New Generations of Electronic Meeting Systems
Increasingly, consumers and businesspersons are using computers and mobile devices for one-to-one video calls. Group video calls are also on the rise. To use this technology, there are several options available, and they are either free or very inexpensive. Here are some popular examples:
Microsoft’s Skype - Offers individual video calls for free; group video calling requires a plan that costs about $10 a month. The maximum number of participants is 10.
Apple’s FaceTime - Available free of charge on Apple’s iPhone, iMac, iPad, and iPod Touch.
Tango Video Calls - Allows video chats among different devices, including Windows phones, Android and iOS phones, tablets, and PCs.23
Google’s Hangouts— Allows video chat for up to nine people with Hangouts on Google
ooVoo from ooVoo LLC - Allows up to 12 participants in group video chats that are free. The service is available on the Internet using PCs, Macs, iPhones, and other smartphones and tablets.
Zoom.us from Zoom Video Communications - Allows high-definition group video chat for up to 15 participants. It works over wired and Wi-Fi Internet connections or cellular 3G and 4G networks.
Security problems—GSS sessions have the same security problems as other data communication systems, so there is the possibility of private organizational information falling into the hands of unauthorized people. Tight security measures for accessing GSS sessions and transferring data are essential.