0 or 2 credits
Spring 2025 Lecture Distance Learning Upper Division
Covers up-to-date and practical spreadsheet modeling tools, which can be applied to a wide variety of business problems in finance, marketing, and operations. Consists of simulation modeling techniques to analyze risk and uncertainties in business environment, optimization techniques to determine the best managerial actions under internally- and/or externally-imposed constraints, and real-world examples and cases to demonstrate broad applications of spreadsheet modeling and simulations in manufacturing and service operations, supply chain systems, yield management, asset dynamics, option pricing, etc.
Learning Outcomes1Identify the most likely description of the uncertainty in future business with data analysis techniques, such as Pivot Table, PivotChart, fitting probabilities to data, etc.
2Use deterministic and stochastic optimization techniques to determine the best managerial actions under internally- and/or externally-imposed constraints.
3Analyze the risk and uncertainty in business environment and process with simulation modeling techniques.
4Review and criticize peer's participation in and contribution to group work.
Prerequisites
Restrictions
Attachments
made by Purdue students.