Course Schedule - Fall Term II 2008
MBA 605 Advanced Quantitative Methods for Management
Stout home MBA 605 home Syllabus Lecture notes Schedule
|
# |
Date |
Subject |
Preparation assignment |
Homework due tonight |
|
1 |
21 Oct |
Course introduction
How do you make decisions? Decision-making chart
Read: "Taco Bell Finds Recipe for Success", OR/MS Today, October 1997 (found in Oct 97 "OR/MS Today" under "Practice Lesson" column) Download and review Excel tutorial.
Complete Up to Speed with Excel 2007 Begin work on Car Loan exercise #1 |
Review syllabus | |
|
2 |
23 Oct |
Course introduction
How do you make decisions? Decision-making chart
Read: "Taco Bell Finds Recipe for Success", OR/MS Today, October 1997 (found in Oct 97 "OR/MS Today" under "Practice Lesson" column) Download and review Excel tutorial.
Review Excel exercise 1
Data presentation and analysis Reiff Manufacturing
Complete Excel tutorial Excel fundamentals Using
absolute/relative references Data tables |
Review
Appendix B, "Useful Excel Commands"
|
Excel exercise #1 |
|
3 |
28 Oct |
Excel exercise 2; discuss check box, TVM functions, nested functions, and LOOKUP and IF functions.
Breakeven analysis - develop spreadsheet model
|
Review problem solving processes Read chapter 1 - review textbook spreadsheet examples and "Goal Seek" command. |
Excel exercise #2 Submit problem 1-19 before leaving class tonight |
|
4 |
30 Oct |
Linear programming introduction Lego production problem Problem formulation Linear programming – graphical solution Linear programming - spreadsheet solution |
Read chapter 2 | Problem: 1-26 Use both Goal Seek and Data Tables to find your solutions. Copy, insert, and print "Goal Seek" and "Data Table" dialog boxes containing cell references on your spreadsheet. |
|
5 |
4 Nov |
Linear programming - set up, special situations, answer report Begin linear programming applications Manufacturing - Reiff make or buy Marketing Finance |
Read chapter 3. |
Problems: 2-13, 2-18 Solve Lego production problem graphically using the corner point method. Solve the Lego production problem in a spreadsheet using Solver (print values and formula views). |
|
6 |
6 Nov |
Continue linear programming applications |
Problems: Problems: 3-2, 3-7, 3-9, 3-14 | |
|
7 |
11 Nov |
Veteran's Day Holiday
Linear programming - sensitivity analysis |
Read chapter 4. Read chapter 5 Scan chapter 6 |
|
|
8 |
13 Nov |
Exam 1 - Excel fundamentals, data gathering, decision-making, linear programming concepts, applications, and sensitivity analysis | Review chapter 1, appendix B, Excel Tutorial and chapters 2 - 6. |
Problems:
3-18, 3-25, 3-33, 4-10
|
|
9 |
18 Nov |
Review exam 1 results Binomial distribution Poisson distribution Bayes problem |
Review appendix A. |
|
|
10 |
20 Nov |
Continuous probability distributions Distribution expected value, variance, and standard deviation Uniform distribution Normal distribution Exponential distribution Excel probability distribution functionsData gathering - histograms |
Review appendix A |
Problems: A-14, A-16,
A-20, A-30 (by hand), A-31 (by Excel) Journal article critique due |
|
11 |
25 Nov |
Project management Network models/CPM/PERT Microsoft Project |
Read chapter 7. | Problems: A-34, A-35, A-38, A-40, A-41 |
| Thanksgiving holiday | ||||
| 12 | 2 Dec |
Decision analysis Utility theory |
Read chapter 8. | Problems: 7-13, 7-18, 7-27, 7-30 (by hand) |
|
13 |
4 Dec |
Queuing
models and waiting lines Simulation |
Read
chapter 9. Read chapter 10. |
Problems: 8-14, 8-15, 8-30 |
|
14 |
9 Dec |
Simulation Regression analysis |
Read chapter 11. |
Problems:
9-10, 9-12 Problems: 10-17, 10-35 |
|
15 |
11 Dec |
Forecasting Regression analysis |
Problems: 11-13, 11-16, 11-35 | |
|
16 |
16 Dec |
Final examination |