Online-Academy
Look, Read, Understand, Apply

MIS-DSS-ESS

Management Information System

A Management Information System (MIS) is a computer-based system that collects, stores, processes, and provides information needed for managerial decision-making. It converts raw data from an organization's operations into meaningful information that managers use to plan, control, and evaluate activities. MIS is used by the middle level managers to ease their tasks and activities.

A Management Information System provides the right information to the right people at the right time. The reports generated by MIS help managers monitor performance, solve problems, plan future strategies, and make informed decisions.

Managers use MIS to perform several functions. Functions like:
  1. Data Collection: Gathers data from internal sources (sales, production, HR, finance) and sometimes external sources.
  2. Data Processing: Summarizes, sorts, compares, and analyzes data.
  3. Information Storage: Maintains databases for easy retrieval.
  4. Information Distribution: Sends processed information to managers at different levels.
Different Types of Reports are Produced by MIS

1. Scheduled (Routine) Reports

These are generated regularly — daily, weekly, monthly. Examples:
  1. Daily sales report showing number of units sold at each branch.
  2. Monthly production report summarizing output by department.
  3. Weekly attendance report for employees.
  4. Number of client visits each day.
  5. Purpose: To monitor ongoing operations.

2. On-Demand (Ad Hoc) Reports

Prepared only when a manager requests specific information. Examples:
  1. A manager asks for sales performance of product X in the last quarter.
  2. A custom report on employee overtime hours for Month of January.
  3. A report analyzing cost increases for a particular supplier.
  4. A customer asks for his/her share purchase history.
  5. Purpose: Supports specific decision-making situations.

3. Exception Reports

Highlight only unusual or abnormal conditions — 'exceptions' that need immediate attention. Examples:
  1. A report listing inventory items below safety stock levels.
  2. A report showing customers whose payments are past due by more than 60 days.
  3. A budget exception report showing departments exceeding spending limits.
  4. Purpose: Helps managers focus on problems quickly.

4. Summary (Key Performance) Reports

These condense detailed data into high-level information. Examples:
  1. Executive dashboard summarizing revenue, profit, and expenses.
  2. Monthly performance summary for each branch or region.
  3. Quarterly financial summary for top management.
  4. Purpose: For strategic planning and top-level decisions.

Decision Support System

A Decision Support System (DSS) is a computer-based system that helps managers make complex, non-routine decisions. It uses models, analytical tools, and data to support decision-making where judgment, evaluation, and insights are needed. A DSS is especially useful when problems are semi-structured, complex, or involve uncertainty.

A Decision Support System enhances decision-making by providing powerful analytical tools. Through what-if analysis, scenario analysis, goal seek, and optimization, managers can evaluate alternatives, predict outcomes, achieve targets, and find optimal solutions—all of which support better strategic and operational decisions.

Major Features of a DSS

  1. Flexible and interactive
  2. Uses analytical and mathematical models
  3. Helps compare alternatives
  4. Supports—but does not replace—managerial judgment

Analytical Tools Used in DSS

1. What-If Analysis

Examines how changes in one or more input variables affect outcomes.
Purpose: "To see what happens if…?"
Example: A company predicts profits for next year.

  • What if raw material costs increase by 10% what will be profit?
  • What if sales volume decreases by 5%, will profit also decreases by 5%?
By changing the input, the DSS recalculates outputs to show the impact.

2. Scenario Analysis

Evaluates several different combinations of variables to study alternative future states. Purpose:To analyze best case, worst case, and most likely scenarios.

Example:

A hotel planning for the next tourist season might use three scenarios:

  • Best case: High demand, low competition.
  • Worst case: Low demand, economic downturn.
  • Most likely: Moderate demand and average competition.
    • Each scenario gives different projections of revenue and occupancy.

    3. Goal Seek Analysis

    Starts with a desired outcome and works backward to determine the necessary input to achieve that result. In other words Find the input value needed to reach a target.

    Example:

    A manager wants $500,000 profit next year. Goal Seek can determine:

    • How many units must be sold?
    • What should the price be?
    • What cost reduction is needed?
    The DSS calculates the required input values to meet the goal.

    4. Optimization Analysis

    Finds the best possible solution under given constraints. Uses mathematical optimization models like linear programming. It is used to maximize or minimize something (profit, output, cost, time).

    Example:

    A factory wants to maximize profit with limited resources:

    • Raw materials available
    • Machine hours
    • Labor capacity
    Optimization analysis determines the best combination of products to produce to achieve maximum profit.

    Executive Information System (EIS)

    An Executive Information System (EIS) is a specialized computer-based system designed to support top-level executives by providing easy access to internal and external information relevant to strategic goals. It gives summarized, high-level information and uses dashboards, charts, and trend reports to help executives make strategic decisions.

    An Executive Information System provides high-level, summarized, and real-time information to senior executives for strategic decision-making. It performs tasks such as monitoring performance, analyzing trends, supporting strategic planning, scanning the environment, and presenting information visually and quickly.

    Major Features of an EIS
    • User-friendly interface (simple menus, dashboards, graphs).
    • Access to critical data: financial performance, market trends, competitor information.
    • Real-time and summarized information.
    • Drill-down capability (executives can move from summary to detailed data).
    • Trend analysis and forecasting.
    • External environment scanning (news, industry reports).

    Examples of Executive Information Systems

    • Corporate Dashboard for a CEO: Showing revenue, profits, market share, customer satisfaction, stock prices.
    • Bank Executive Dashboard: Displays loan performance, interest rate trends, branch profitability, and risk indicators.
    • Hospital EIS: For hospital administrators showing patient admissions, bed occupancy, average treatment cost, and staff utilization.
    • Retail Chain EIS: Summaries of total sales, top-performing stores, inventory status, and competitor pricing trends.
    • Manufacturing Company EIS: Provides information on production efficiency, supply chain risks, global raw material prices, and long-term demand forecasts.
    Tasks / Functions of an Executive Information System (EIS)
    1. Monitoring Organizational Performance: Organization define several key performance indicators. EIS helps to track key performance indicators (KPIs) such as profit margins, market share, customer retention. Helps executives compare actual performance with targets.

      Example: A CEO views monthly revenue vs. yearly target.

    2. Identifying Trends and Opportunities: Provides long-term trend analysis (sales trends, global market changes). Helps identify new opportunities or potential threats.

      Example An airline executive sees rising travel demand in a new region from trend graphs.

    3. Supporting Strategic Planning: Helps in formulating long-term strategies by analyzing external and internal data.

      Example: A telecom executive uses forecasts to plan 5-year investment in 6G infrastructure.

    4. Environmental Scanning: Monitors external factors such as competition, government policies, market conditions, and global economic indicators.

      Example: A multinational tracks currency changes, commodity prices, and competitor expansions.

    5. Providing Quick, Easy Access to Information: Presents information visually through dashboards, charts, gauges, and scorecards. Reduces the need for complex reports.

      Example: An executive sees a color-coded dashboard:

      1. Green: Sales on target
      2. Yellow: Inventory slightly low
      3. Red: Profit margin declining
    6. Drill-Down and Exception Reporting Allows executives to click on a summary to view deeper details. Quickly shows exceptions or problem areas.

      Example: Drilling down from "low profit" -> to a specific region -> to a specific product.

    7. Communicating and Sharing Information Helps executives share strategic insights with managers through visual reports and dashboards.

      Example: A CFO shares a financial dashboard with department heads before a board meeting.

    Dashboard (Simple Definition)

    A dashboard is a screen or page that shows important information in one place, usually using charts, numbers, and indicators so you can understand things quickly at a glance. Example: A car dashboard shows speed, fuel level, and warnings. In business: A dashboard can show sales, profits, customers, etc.

    Scoreboard (Simple Definition)

    A scoreboard is a display that shows scores or results, usually to track performance in real time. Example: In sports, a scoreboard shows team scores and time. In business or studies: It shows targets vs. actual results (like goals achieved).