Fourth Edition
| Other Resources |
|
The goal of the course is not to make you Operations Research/Management Science professionals; but rather to help you develop sufficient familiarity of OR/MS to:
We'll attain the last goal with a "hands-on" approach via Excel spreadsheet modeling, which is the tool of choice in the modern work environment. No prior knowledge of Excel is required; you will be taught the skills from class and the text, and gain proficiency by doing the homework problems.
|
| Spreadsheet Modeling and Decision Analysis, Fourth Edition |
Cliff Ragsdale | South-Western |
| Week | Date | Topic | Text Chapters | Homework | Handouts |
|---|---|---|---|---|---|
| Week 1 | Aug 26 | Course Introduction | 1.0 - 1.4 | Homework Set 1 | Handout |
| Aug 28 | Lab 1: Excel Basics | Lab Handout Excel Lab Lab Solution | |||
| Week 2 | Sep 2 | Modeling Process Introduction to Queues |
1.5 - 1.7 13.0 - 13.3 |
HW 1 solns corrected 20 sept |
|
| Sep 4 | Lab 2: Exponential and Poisson Distributions | Lab Handout Excel Lab | |||
| Week 3 | Sep 9 | Queuing Models | 13.0 - 13.6 | Handout | |
| Sep 11 | Lab 3: Queuing Models in Excel | Lab Handout Q.xls | |||
| Week 4 | Sep 16 | Finite Length and Finite Population Queues, General Queuing Models | 13.7 - 13.10 | Sample Exam 1 Handout |
|
| Sep 18 | Lab Project 1: Queueing Systems | Lab Handout | |||
| Week 5 | Sep 23 | Exam 1 | Portfolio Rubric | ||
| Sep 25 | Introduction to Linear Programming | 2.0 - 2.10 | Group Project 1 Homework Set 2 |
Handout | |
| Week 6 | Sep 30 | Linear Programming II: Modeling | 2.11 - 2.12 | Handout | |
| Oct 2 | Lab 4: Linear Programming in Excel | 3.0 - 3.7 | HW 2 solutions Part 1 |
Lab Handout Wapiti Brewing.xls |
|
| Week 7 | Oct 14 | Sensitivity Analysis | 4.0 - 4.6 | Prb3-3.xls Prb3-4.xls Prb3-7.xls Prb3-9.xls Prb4-3.xls Prb4-4.xls Prb4-7.xls | Handout |
| Oct 16 | Lab 5: LP Modeling | Lab Handout Sweet Tooth.xls |
|||
| Week 8 | Oct 21 | LP Modeling | 3.8, 3.9, 3.11, 3.12 | PowerPoint Handout | |
| Oct 23 | LP Formulations MEET IN THE CLASSROOM |
HW 2 solutions Part 2 |
|||
| Week 9 | Oct 28 | Integer and Nonlinear Programming | 6.0 - 6.8, 8.0 - 8.3 | Prb3-13.xls Prb3-15.xls Prb3-16.xls Prb3-20.xls Prb3-24.xls Prb3-26.xls | |
| Oct 30 | Lab Project 2: The Diet Problem | Group Project 2 mcdonalds.xls sugar.xls |
|||
| Week 10 | Nov 4 | Exam 2 | sample test 2 | ||
| Nov 6 | Time Series Forecasting | 11.0 - 11.6 | Homework Set 3 Excel Forecasting template |
||
| Week 11 | Nov 11 | Regression, Multiple Regression | 9.0 - 9.9, 9.11 - 9.17 | Excel Regression template | Handout |
| Nov 13 | Lab 6: Time Series and Regression | Lab Handout Time Series.xls Regression Examples.xls Multiple Regression.xls |
|||
| Week 12 | Nov 18 | Seasonality and Trends | 11.7 - 11.20 (skim) | ||
| Nov 20 | Lab 7: Seasonality and Trends | 11.7 - 11.20 | Group Project 3 Excel template Excel Data |
||
| Week 13 | Nov 25 | Project Work Day | HW Set 3 revised HW set 3 solutions Prb9-7.xls Prb9-11.xls Prb11-4.xls Prb11-5.xls Prb11-6.xls Prb11-7.xls Prb11-8.xls Prb11-9.xls Prb11-10.xls Prb11-15.xls Prb11-17.xls Prb11-18.xls Prb11-19.xls |
||
| Nov 27 | Thanksgiving! No Class | ||||
| Week 14 | Dec 2 | Introduction to Decision Analysis | 15.0 - 15.5 | HW Set 4 HW Set 4 solns |
Handout |
| Dec 4 |
Decision Analysis MEET IN THE CLASSROOM |
15.6 - 15.7 | |||
| Week 15 | Dec 9 | Decision Analysis | 15.8 - 15.9, 15.15 - 15.17 | ||
| Dec 11 | Review | ||||
| Dec 16 | Final Exam - Tuesday: 1:00 - 2:45 Hand in Portfolio |
Sample Exam |
| Assignment | Percentage |
|---|---|
| Portfolio | 10% |
| Lab Projects | 10% |
| Group Projects | 30% |
| Examinations | 50% |
Your grade will translate to a letter grade as follows :