Business Analytics: Spreadsheet Optimization and Simulation
GSM QM 880
The modeling process illustrated throughout the course will significantly improve students? abilities to structure complex problems and derive insights about the value of alternatives. You will develop the skills to formulate and analyze a wide range of models that can aid in managerial decision-making in the functional areas of business. These areas include finance (capital budgeting, cash planning, portfolio optimization, valuing options, hedging investments), marketing (pricing, sales force allocation, planning advertising budgets) and operations (production planning, workforce scheduling, facility location, project management). The course will be taught almost entirely by example, using problems from the main functional areas of business. This course is not for people who want a general introduction to or review of Excel. This course is for students who are already comfortable using Excel and would like to use it to create optimization and simulation models.
FALL 2016 Schedule
|F1||Fox||HAR 314||W 6:00 pm-9:00 pm|
SPRG 2017 Schedule
|F1||TBA||HAR||T 6:30 pm-9:30 pm|
Note: this course was also offered during Summer Term