Decision Support Systems, Business Process Reengineering, and Enterprise AI

Decision Support Systems and Optimization Tools

• Goal Seek Feature in Excel:

  • Used in operations management and core business courses to perform quantitative sensitivity and target analyses.
  • Functionality: Allows users to set a specific target output cell (such as a target profit figure) and automatically adjusts designated input cells (including expected revenues, fixed/variable costs, risk factors, or potential operational losses) to find the precise numerical combination needed to reach that goal.
  • Strategic Application: Helps leadership evaluate strategic choices, such as whether to prioritize revenue growth, cost reduction, or a balanced combination of both.

• Organizational Decision-Making Hierarchy:

  • Strategic Level (Top of Pyramid): Executive Support Systems ($ESS$) / Executive Information Systems ($EIS$).
  • Managerial Level (Middle of Pyramid): Decision Support Systems ($DSS$).
  • Operational Level (Bottom of Pyramid): Transaction Processing Systems ($TPS$).

• Decision Support Systems ($DSS$):

  • Positioned at the middle management layer to assist with semi-structured decision-making.
  • Consolidates and processes data from multiple underlying line-level operational systems, including:
  • Order Processing Systems / Front-desk transaction systems.
  • Inventory Tracking Systems.
  • Manufacturing Data Systems.

• Transaction Processing Systems ($TPS$):

  • Positioned at the operational base to execute routine, day-to-day front-line tasks ("blocking and tackling").
  • Example: Self-service order kiosks at fast-food chains like Taco Bell (where a customer like Alexis places an order for a Baja Blast drink and a $7$-layer burrito).
  • Automatically feeds transactional, inventory, and revenue data upward into middle-management systems.

• Architectural Separation of Information Systems:

  • Enterprise systems are deliberately kept isolated and specialized rather than merged into multi-purpose machines (e.g., avoiding combining a food order kiosk with an $ATM$).
  • Operational & Security Risks of Blending Systems:
  • Data Privacy & Mixing: Prevents sensitive personal banking data from mixing with retail transaction records of corporate parents (such as Yum! Brands, which owns Taco Bell and KFC).
  • Cash Depletion: A customer withdrawing large sums of cash (e.g., \\$5,000 to \\$10,000) could drain store cash reserves, creating liquidity and operational issues.
  • Service Bottlenecks: Non-dining users visiting kiosks solely for cash withdrawals (attracted by low \\$1 $ATM$ fees) create long queues during peak operational hours (such as lunch rushes), blocking paying food customers.
  • Integration Challenge: Maintaining isolated systems creates separate data silos that require upstream synthesis for enterprise reporting.

Executive Support Systems and Data Granularity

• Executive Support Systems ($ESS$) / Executive Information Systems ($EIS$):

  • Designed for top-level executives managing unstructured, long-term, non-routine strategic decisions (e.g., Mergers and Acquisitions / $M\&A$).
  • Feature executive digital dashboards with visual indicators (such as red vs. blue status trend lines or heatmaps) and global geographic tracking to deliver immediate performance overviews.

• Data Granularity Across Pyramid Levels:

  • Operational Level ($TPS$): Requires fine-grained, detailed micro-data (e.g., the exact minute and second a specific batch of french fries was placed into the deep fryer).
  • Managerial Level ($DSS$ / $OLAP$): Employs Online Analytical Processing ($OLAP$) on medium-granularity data to analyze trends and comparative metrics (e.g., comparing daily french fry sales against the same statistical day from the prior year, such as the second Wednesday in September).
  • Strategic Level ($ESS$): Requires highly coarse, aggregated macro-data synthesized across the entire organization (e.g., executive dashboards summarizing the enterprise results of $48,000$ individual fry orders placed across all locations).

• External Data Integration in $ESS$:

  • Strategic systems combine internal metrics with external macro-environmental data feeds, including industry news, stock market updates, and external research services (such as Gartner Group subscriptions).
  • Impact of Generative $AI$ on Industry Research Services:
  • Corporate subscriptions to research groups like Gartner are being cancelled because modern generative $AI$ models synthesize comparable strategic intelligence at approximately $80\%$ of the quality for negligible cost.
  • As a result of this market shift, Gartner's stock price dropped by approximately $\frac{2}{3}$ (a $66.7\%$ decline) over a $2$ to $3$ year span, contrasting with broader stock market growth.

Business Processes and Strategic Alignment

• Core Functional Business Processes:

  • Accounting & Finance: Accounts receivable management, billing, and ensuring steady enterprise revenue collection.
  • Marketing & Sales:
  • Marketing: Outreach campaigns, brand positioning, customer acquisition, and market differentiation.
  • Sales: Direct transactional engagement to convert consumer interest into executed sales.

• Sales Strategy Alignment by Product Margin:

  • Low-Margin, High-Volume Products (e.g., \\$5 Tacos):
  • Supported by mass marketing (broadcast television ads, mobile app pop-up notifications).
  • Direct, in-person sales calls are economically unfeasible due to high labor costs relative to individual product profit margins.
  • High-Margin, Low-Volume Goods (e.g., \\$50,000,000 Commercial Airliners):
  • Aircraft manufacturers (such as Boeing and Airbus) avoid mass consumer advertising during sporting events.
  • Utilize high-touch sales representatives and key account managers who engage directly with airline procurement agents (e.g., Delta Air Lines, American Airlines) at specialized events like the Farnborough Airshow in Great Britain.

• Decomposition of Business Processes:

  • Complex operations are decomposed into detailed micro-processes to ensure procedural compliance and minimize material waste.
  • Fast-Food Process Example: In-N-Out Burger (headquartered in Nashville, originating on the West Coast and expanding into Texas) standardizes an on-site potato peeling, slicing, and frying process using fresh potatoes, avoiding pre-packaged frozen fry bags.

Business Process Frameworks and Modeling Notation

• Order-to-Delivery Process Steps:

  1. Marketing: Create promotional campaigns and check inventory systems to verify advertised items are in stock.
  2. Sales: Process customer order placement, alert production teams, and verify customer credit worthiness (e.g., verifying an airline's financial standing).
  3. Manufacturing: Produce the ordered goods (e.g., assembling an Airbus $A320$ inside a manufacturing hangar over a $1\text{-week}$ cycle).
  4. Fulfillment & Billing: Deliver the physical product, issue customer invoices, and collect payment.
  5. Post-Sale Support: Provide ongoing maintenance and warranty administration (tracked using vehicle identification numbers / $VIN$ or aircraft serial numbers).

• Process Classification:

  • Customer-Facing Processes (Front Office / Front of House):
  • Directly experienced by external clients (e.g., order entry, package tracking, customer service interactions).
  • Brokerage Historical Context: Front-office representatives manually verifying physical trade tickets for equity transactions (e.g., $200$ shares of General Motors executed at fractional prices such as \\$20.15, \\$20.4375, or \\$20.0625, using minimum pre-decimalization tick increments of $\frac{1}{16}$ or $0.0625$).
  • Business-Facing Processes (Back Office / Back of House):
  • Internal operations hidden from external customers, focused on structural efficiency, cost minimization, and volume throughput (e.g., capacity planning, demand forecasting, employee training, raw materials purchasing like aggregate stone from Vulcan Materials in Birmingham).
  • Restaurant Terminology: "Front of House" describes customer dining areas; "Back of House" describes kitchen operations. An "86 list" identifies menu items that are out of stock.

• Business Process Model and Notation (BPMN):

  • Standardized graphical notation used to model operational workflows.
  • Gateway Symbol: Represented visually as a diamond shape. Acts as a conditional decision logic node that splits workflow paths based on dynamic evaluations (e.g., Credit Check Passed? If Yes $\rightarrow$ Approve purchase; If No $\rightarrow$ Route to manager override or high-interest in-house credit assessment).
  • Modern $AI$ platforms can scan BPMN visual diagrams and automatically write functional software application code for the modeled process.

• As-Is vs. To-Be Process Models:

  • As-Is Model: Documents the current, unoptimized operational workflow.
  • To-Be Model: Represents the optimized target process designed by systems analysts to eliminate waste and reduce costs.
  • Burger Ordering Process Optimization Example:
  • As-Is Workflow: Customer approaches cashier $\rightarrow$ Orders burger $\rightarrow$ Cashier asks "Do you want fries?" (Yes/No) $\rightarrow$ Cashier asks "Do you want a drink?" (Yes/No) $\rightarrow$ Customer pays cashier.
  • Streamlined To-Be Workflow: Customer approaches cashier $\rightarrow$ Orders discounted combo meal containing all items $\rightarrow$ Customer pays cashier (reduces overall queuing time).
  • Automated To-Be Workflow: Replace $4$ human cashier registers with $4$ self-service digital kiosks supervised by a single staff member (similar to retail self-checkout lanes).

• Swim Lane Diagrams:

  • Cross-functional flowcharts that divide workflow activities into distinct horizontal or vertical rows ("lanes") corresponding to responsible departments or actors.
  • Workflow progresses from top-left (Customer placing an order) through internal back-office lanes (Inventory, Shipping, Billing) and ends at top-right with product delivery and invoice payment.
  • Top lane represents Front-of-House / Customer interactions; bottom lanes represent Back-of-House / Back-Office activities prioritized for low unit costs and high execution speed.

Enterprise Systems Integration and Process Redesign

• MIS and Business Process Integration Principles:

  • Best Practice: Business Processes drive $MIS$ selection. Information technology must be customized to support existing operational processes.
  • Suboptimal Failure Mode ("Tail Wagging the Dog"): $MIS$ constraints dictate Business Processes, forcing firms to change workflows to match off-the-shelf software limitations.
  • Oil Company Implementation Case: An oil enterprise implemented an $MIS$ software suite designed for fast-food sandwich franchises (like Subway). Because Subway's operational workflows center on pre-packaged chips rather than cooked oil/french fry operations, the software lacked standard frying workflows, causing widespread operational disruption.
  • Service Standard Degradation Example: Adopting software that enforces a mandatory $48\text{-hour}$ customer follow-up window when internal SLAs require a $24\text{-hour}$ response time.

• Unified Modeling Language (UML) Use Case Modeling:

  • Visual system representation mapping interactions between external system actors (drawn as stick figures) and system use cases within a boundary.
  • Example: Student Management Information System where actors (Teacher, Student) interact with system sub-processes (Check Attendance, Update Attendance, Check Grades, Update Grades).

• Levels of Organizational Process Transformation:

  • Operational Level $\rightarrow$ Automation: Digitizing manual tasks to reduce execution costs (e.g., replacing manual ordering desks with self-service touchscreen kiosks).
  • Managerial Level $\rightarrow$ Streamlining: Optimizing processes by removing bottlenecks and eliminating redundancies (unnecessarily repeated tasks). Example: Enforcing strict quality control at the vendor level to avoid redundant inspection upon receiving materials.
  • Strategic Level $\rightarrow$ Business Process Reengineering ($BPR$):
  • Radical, zero-based redesign of core business processes to achieve dramatic improvements in speed, cost, and quality.
  • Pioneer: Developed by Harvard Professor Michael Hammer in the 1990s.
  • Historical Driver: Accelerated during the transition from centralized mainframes issuing monolithic printed dot-matrix reports (e.g., daily $90\text{-page}$ fan-fold paper printouts where an employee utilized only $2$ pages) to distributed client-server personal computer ($PC$) networks.

Real-World Reengineering, Emerging Tech, and Artificial Intelligence

• Business Process Reengineering ($BPR$) Case Studies:

  • Progressive Insurance:
  • Legacy Process: Customer experiences auto accident $\rightarrow$ Drives to physical branch office $\rightarrow$ Files paper claim $\rightarrow$ Office processes paperwork $\rightarrow$ Paper check issued via mail weeks later.
  • Reengineered Process: Centralized phone reporting center in Illinois + mobile response vans dispatched directly to local accident scenes. Claims representatives issue immediate electronic payments on-site within $30\text{-minutes}$ to $3\text{-hours}$, eliminating a $7\text{-week}$ paper check waiting period.
  • Dell Computer Extranet Integration:
  • Reengineered corporate procurement by connecting Dell's internal inventory extranet directly to university and enterprise buyers (such as the University of Alabama at Birmingham / UAB).
  • Provided business clients direct visibility into real-time factory inventory, contract pricing, and discounted overstock batches ($15\%$ off) caused by cancelled orders.

• E-Commerce Logistics and Emerging Fulfillment:

  • Standard E-Commerce Flow: Customer order (via Call Center or Web Portal) $\rightarrow$ Server checks inventory $\rightarrow$ Flag as Backordered if out of stock, or Unpack $\rightarrow$ Process $\rightarrow$ Ship if available.
  • Autonomous Fulfillment: Integration of commercial drone delivery, allowing orders placed at $11:00\text{ AM}$ to be dropped off directly in a customer's backyard by $3:00\text{ PM}$ the same day.

• Artificial Intelligence ($AI$) and Digital Transformation:

  • Digital Transformation: Re-imagining organizational operations and business models through modern computing technologies.
  • Core $AI$ Skills:
  1. Learning: Machine learning algorithms acquiring knowledge from vast datasets.
  2. Reasoning: Dynamic logical deduction and decision-making capabilities.
  3. Self-Correction: Continual performance optimization based on output feedback loops.
  • Enterprise $AI$ Applications:
  • Robotics & Autonomous Transport: Autonomous taxis (e.g., Waymo/Cruise in Dallas) operating with roof-mounted camera arrays without a human driver present in the vehicle.
  • Resource Optimization: Dynamic allocation of critical clinical equipment and staffing in hospital environments.
  • Fraud Detection: Real-time algorithmic analysis of cardholder purchasing behaviors to flag anomalies (e.g., blocking an unauthorized bed purchase in Ontario, Canada).
  • Algorithms & Platform Retention: Step-by-step mathematical formulas embedded in software to process analytics and execute tasks. Social media platforms (such as Twitter/X) utilize recommendation algorithms to construct engagement echo chambers designed to maximize total user session length.