Analytical Problem Solving with Spreadsheets
- Winter 20
Analytical Problem Solving with Spreadsheets --- Exploring possible courses of action and making informed decisions supported by data is important for managers. This course enables students to formulate, solve, and interpret spreadsheet models under certainty, uncertainty, constraints, and multiple criteria in order to explore solution alternatives and help make informed decisions in a variety of business problems. The students will learn good spreadsheet structuring and design practices through in-class, hands-on exercises, homework assignments, case studies, and projects taken from a variety of business contexts with an emphasis on service operations. Spreadsheet solvers and tools will be used for linear, integer, nonlinear and simulation models.