NBA 6470

Last Updated

  • Schedule of Classes - June 15, 2016 6:14PM EDT
  • Course Catalog - June 9, 2016 6:15PM EDT

NBA 6470
Advanced Spreadsheet Modeling

Course information provided by the Courses of Study 2015-2016.

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.

When Offered Spring.

View Enrollment Information

Syllabi: none

  •   Seven Week - First. 

  • 1.5 Credits GradeNoAud

  • 17359 NBA 6470   LEC 001

  • Pre-Req: NBA 6430 Add/Drop Dates: Johnson Students - January 19th at 8:00am to February 10th at Noon. Non-Johnson Students: February 4th at 8:00am to February 10th at 4:00pm. You may add or drop a first-half class after February 10th with permission of the faculty. A late fee of $100.00 will be charged for each add or drop transaction. If you are dropping after February 24th you will also receive a "W" on your transcript in addition to the late fees.

    Department Consent Required (Add)