NBA 6470 - Advanced Spreadsheet Modeling

Spring. 1.5 credits.

L. Robinson.

The goal of this hands-on lab course, taught in the Parker Center, is to develop proficiency with Excel’s quantitative tools of Solver (for optimization) and @Risk (for simulation). Building on their brief introduction in the Managing Operations core course, students use these advanced tools to analyze problems and cases in finance, marketing, and operations. Although the bulk of this course is devoted to case analysis, occasional lectures introduce some advanced features of these two powerful modeling tools, including integer and nonlinear programming and sensitivity analysis within optimization, and correlated random variables, scenario analysis, and valid statistical analysis within simulation.