TMMBA 511: Summer 2004
|
Schedule |
Sat., June 26 1:15-2:45pm Session #1 Spreadsheets |
Skim: Text, Chapter 1 Read: Text, Chapter 2 |
Introduction to Linear Programming Through a hands-on example (using Lego building blocks), we introduce the linear programming model. We will then discuss the use of the Solver feature in Microsoft Excel for modeling and solving such problems. We discuss the benefits and pitfalls of modeling a problem as a linear model. Finally, we examine the process of solving linear programs and basic properties of their solutions. |
Sat., June 26 3:00-4:30pm Session #2 Spreadsheets |
Skim: Text, Chapter 3 Read: Text, Chapter 4 Optional Readings: |
Formulation of Linear Programming Models In this session we learn to recognize the various kinds of managerial problems to which linear programming can be applied. We will formulate linear programs that address problems from a variety of different business areas |
Sat., July 10 8:30-10:00am Session #3 Spreadsheets Solver Table add-in Solver Table Instructions |
Read: Text, Chapter 5 Due: Problem Set #1 |
Sensitivity Analysis We discuss the use of Solver output for performing post-optimality or sensitivity analysis for linear programs. This analysis is useful in testing the robustness of the solutions to a particular model, and also in providing valuable economic information about the problem being analyzed. |
Sat., July 10 10:15-11:45am Session #4 Spreadsheets |
Read: Text, Chapter 9 | Integer Programming In this session we address problems where some or all of the decision variables are required to assume integer values. We discuss when rounding is appropriate and when it is not. We also discuss the application of binary variables to making "yes-or-no" type decisions. |
Sat., July 24 1:15-2:45pm Session #5 Spreadsheets: Walton, Global Oil, Phone |
Skim: Text, Chapter 15 Read: Text, Chapter 16 Due: Problem Set #2 |
Simulation and Crystal Ball In this session we discuss and demonstrate the role of simulation as a tool for analyzing systems involving uncertainty or risk. We discuss the use of the Crystal Ball Excel add-in for performing Monte-Carlo simulation. |
Sat., July 24 3:00-4:30pm Session #6 Spreadsheets: Bidding, Overbooking, New Car, Cash Flow |
Applications of Simulation In this session we continue discussion of Monte-Carlo simulation and the Crystal Ball Excel add-in and its application to various business problems. | |
Thu., July 29 | Final Exam Available | |
Thu., Aug. 5 | Final Exam Due |