NBA 6470

Last Updated

  • Schedule of Classes - October 16, 2017 11:09AM EDT
  • Course Catalog - June 14, 2017 7:15PM EDT

NBA 6470
Advanced Spreadsheet Modeling

Course information provided by the 2016-2017 Catalog.

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.


Prerequisites/Corequisites Prerequisite: NCC 5080 and NBA 6430 or permission of instructor.

When Offered Spring.

View Enrollment Information

Syllabi: none

  •   Seven Week - First. 

  • 1.5 Credits GradeNoAud

  • 15348 NBA 6470   LEC 001

  • Instruction Mode: In Person

    Pre-Req: NBA 6430 Add/Drop Dates: Johnson Students – January 17th – February 8th Non-Johnson Students – February 2nd - February 8th You may add or drop a first-half class after February 8th only with permission of the faculty. A late fee of $100.00 will be charged to your bursar account, for each add or drop transaction. If you are dropping after February 22nd you will also receive a “W” on your transcript in addition to the late fee.

    Department Consent Required (Add)