Intro to Business › Section M · Technology and information › Topic M.3

Management information systems

A supermarket checkout, a monthly sales report and a chief executive's dashboard all draw on the same records but serve very different needs. Management information systems are the family of systems that turn a firm's daily transactions into the information each level of management needs.

What an MIS is

Individuals use spreadsheets and word processors for their own tasks. Managing a whole firm's information is a larger job, handled by its management information system (MIS): the people, hardware, software, data and procedures that capture what the business does and turn it into what managers need to plan, control and decide. An MIS is not one program but a set of linked systems. When you pay at a till, book a hotel room online or stream a song, an information system records the transaction and passes the data to everyone who needs it.

Three levels of decisions

Different managers make different decisions, and each kind of system serves a level. Operational decisions are day-to-day and routine, such as how much stock to reorder today or which staff to schedule tomorrow; they need detailed, current data. Tactical decisions, made by middle managers, cover months, such as a regional sales plan or a department budget; they need summaries and comparisons. Strategic decisions, made by top managers, shape the firm for years, such as entering a new country or acquiring a rival; they need broad trends and external information. Transaction systems mostly feed the first level, and support systems the other two.

Transaction processing systems

A firm's information systems start with its transaction processing system (TPS), which records the routine transactions of daily business: sales, payments, orders, deliveries, deposits and payroll. A TPS collects data from internal and external sources, checks it, processes it and stores it in the firm's databases, which become its central information resource. They automate back-office work and give basic operational information quickly, such as today's sales. Everything else in the MIS depends on them, so their data must be accurate: errors at this stage flow into every report built on top.

Batch or real-time processing

A TPS updates its database in one of two ways. Batch processing collects transactions over a period and processes them together, for example every night. It uses computing resources efficiently and suits jobs needed only periodically, such as payroll. Online, or real-time, processing handles each transaction as it happens, so the data are always current. Airline seat bookings and bank card payments must work this way, because two customers must never buy the same seat or spend the same money twice. Real-time processing costs more, so firms weigh the value of current data against the cost, often mixing both: real-time stock levels, overnight accounting.

Management support systems and data warehouses

Management support systems (MSS) use the firm's stored data to perform higher-level analysis for decisions. Many rely on a data warehouse, which combines data from many operational databases across the firm into one central store designed for analysis, so managers see the whole picture instead of isolated pieces. A data mart is a smaller subset of a warehouse that covers one area, such as marketing or finance, organised for quick analysis. Firms use warehouses to analyse customers, detect fraud, compare product lines and forecast demand. Today many warehouses run on cloud services rather than the firm's own machines.

Information-reporting systems

The first level of an MSS is the information-reporting system, which uses data collected by the TPS to produce reports. Scheduled reports appear regularly: a weekly payroll report for the payroll team, or a monthly summary of labour costs by department for a senior manager, compared with last year. Exception reports list only the cases that fail a standard, so attention goes where it is needed. On-demand reports are produced when a manager asks a specific question, such as sales by region and customer type. Many firms now show such reports as live dashboards that update automatically as transactions arrive.

Worked example: an exception report

A wholesaler's policy is to chase any customer account more than 60 days overdue. Its records show five accounts: A owes 1,200 dollars, 15 days overdue; B owes 4,500 dollars, 75 days; C owes 800 dollars, 62 days; D owes 2,300 dollars, 30 days; E owes 3,100 dollars, 95 days. 1. Apply the rule: B, C and E exceed 60 days. 2. Their total: \(4{,}500 + 800 + 3{,}100 = 8{,}400\) dollars. 3. Share of all overdue money: \(8{,}400 \div 11{,}900 \approx 71\%\). 4. The exception report lists only B, C and E, sorted by days overdue. Check: collectors now focus on three accounts holding most of the money at risk, instead of reading every account.

Decision support systems

A decision support system (DSS) lets a manager explore a choice with an interactive model of how part of the business works. It draws on the firm's data but focuses on one problem, answering what-if questions: what happens to profit if we raise the price, open a shift or lose a big customer? The simplest DSS is a spreadsheet model in which a manager changes inputs and watches the results. More advanced systems use forecasting and optimisation, for example to plan delivery routes or set stock levels, and predictive analytics estimates likely outcomes from past patterns.

Worked example: a what-if model

A café sells 5,000 coffees a month at 4 dollars each. Each cup costs 1.50 dollars in ingredients, and monthly fixed costs are 8,000 dollars. Profit = cups × (price − cost per cup) − fixed costs. 1. Today: \(5{,}000 \times 2.50 - 8{,}000 = 4{,}500\) dollars. 2. What if the price rises to 4.50 dollars and sales fall 10%, to 4,500 cups? \(4{,}500 \times 3.00 - 8{,}000 = 5{,}500\) dollars. 3. What if the price falls to 3.50 dollars and sales rise 20%, to 6,000 cups? \(6{,}000 \times 2.00 - 8{,}000 = 4{,}000\) dollars. Check: the model only tests the assumptions it is given; the 10% and 20% responses are estimates the manager must judge.

Executive and expert systems

An executive information system (EIS) is tailored to a senior executive, presenting key measures, comparisons with competitors and economic trends for strategic decisions, usually as a dashboard. An expert system captures rules supplied by human experts, so non-experts can get similar advice: for example, a system that schedules aircraft and crews or checks insurance claims against rules. Expert systems are an early form of artificial intelligence. Many firms now also use machine learning, which finds patterns in large amounts of data rather than following hand-written rules. Office automation systems, such as email, calendars and shared documents, support communication across all levels.

Common mistakes to avoid

First, thinking an MIS is a single piece of software; it is a set of linked systems, people and procedures. Second, assuming real-time processing is always better; batch processing is cheaper and suits periodic jobs such as payroll. Third, confusing a data warehouse, which combines many databases for analysis, with a data mart, which covers one area. Fourth, treating DSS output as fact, when it depends on assumptions the manager supplies. Fifth, ignoring data quality at the TPS level, because every report and model inherits its errors.

Key takeaways

A management information system collects a firm's data and produces information for operational, tactical and strategic decisions. Transaction processing systems record daily transactions, by batch or real-time processing. Management support systems use stored data for analysis, often through data warehouses and data marts. Information-reporting systems produce scheduled, exception and on-demand reports, increasingly as dashboards. Decision support systems answer what-if questions with interactive models. Executive information systems serve senior managers, expert systems apply experts' rules, and machine learning finds patterns in data. Every level depends on accurate transaction data.

Flashcards

Flashcard

MIS

People, hardware, software, data and procedures producing information for managers

A set of linked systems.

Test your understanding

Question 1 of 5

A shop sells 2,000 units a month at 10 dollars; each costs 4 dollars and fixed costs are 9,000 dollars. If the price rises to 12 dollars and sales fall 15%, what is monthly profit?

Question 2 of 5

Which job is best suited to batch processing?

Question 3 of 5

What is an exception report?

Question 4 of 5

A supermarket's tills record every item scanned and update stock and sales records. Which kind of system is this?

Question 5 of 5

What is a data mart?

← Previous topicNext topic →