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 | Jan 11 | Course Introduction | Chapter 1 | Homework Set 1 | Modeling Example |
| Jan 13 | Lab 1: Excel Basics | Lab Handout, Excel Lab | |||
| Week 2 | Jan 18 | Lab 2: Exponential and Poisson Distributions | Lab Handout Excel Lab | ||
| Jan 20 | Introduction to Queues | 13.0 - 13.6 | Handout | ||
| Week 3 | Jan 25 | Lab 3: Queuing Models in Excel | 13.0 - 13.8 | HW 1 Solutions | Lab Handout, Q.xls |
| Jan 27 | Queuing Part II | Handout | |||
| Week 4 | Feb 1 | Lab 4: M/G/1 and M/D/1 Queues |
13.9 - 13.10 | Lab Handout | |
| Feb 3 | Lab 5: Queueing Analysis | Lab Handout | |||
| Week 5 | Feb 8 | Lab 6: Queuing Simulation | 13.11 | Portfolio Rubric | |
| Feb 10 | Queuing Summary | ||||
| Week 6 | Feb 15 | Lab: Exam 1 | |||
| Feb 17 | Linear Programming | 2.0 - 2.12 | Homework Set 2 | LP Introduction | |
| Week 7 | Feb 22 | Lab 7: LP In Excel | 3.0 - 3.7 | Project 1 | Lab Handout, Wapitit Brewing.xls |
| Feb 24 | Sensitivity Analysis | 4.0 - 4.6 | Sensitivity Analysis | ||
| Week 8 | Mar 1 | Lab 8: LP Modeling and Sensitivity Analysis | HW 2 Solutions |
Lab Handout | |
| Mar 3 | Lab 8 or Project work time | 3.9 | |||
| Week 9 | Mar 15 | Lab 9: LP//NLP Models | 8.0 - 8.3 | Lab Handout Sample Exam 2 Sample Exam 2 Solutions |
|
| Mar 17 | Exam 2 | Project 2 mcdonalds.xls |
|||
| Week 10 | Mar 22 | Time Series Forecasting | 11.0 - 11.5 | Homework Set 3 | time series introduction time series examples.xls |
| Mar 24 | Work on Project 2 (Montclaire State trip) |
HW 3 Solutions |
|||
| Week 11 | Mar 29 | Lab 10: Stationary Data and Regression |
11.6, 9.0 - 9.9 | prb11-9.xls prb11-10.xls prb11-15.xls prb11-16.xls prb11-17.xls prb11-18.xls prb11-19.xls prb11-22.xls |
Lab Handout time series examples.xls regression example.xls |
| Mar 31 | Multiple Regression | 9.11 - 9.17 | Multiple Regression Handout | ||
| Week 12 | Apr 5 | Nonstationary Data | 11.10 - 11.12, 11.15 - 11.17 | Trends Handout | |
| Apr 7 | Lab 11: Multiple Regression and Trend Data | Lab Handout multiple regression.xls nonstationary.xls |
|||
| Week 13 | Apr 12 | Lab 12: Seasonality | 11.7 - 11.9, 11.13 - 11.14, 11.19 - 11.20 | Lab Handout seasonal.xls |
|
| Apr 14 | Lab 13: Seasonality and Trends | Lab Handout Holt seasonal.xls regression seasonal.xls |
|||
| Week 14 | Apr 19 | Decision Analysis Introduction | 15.0 - 15.6 | Project 3 | Decision Analysis |
| Apr 21 | Probabilistic Methods | 15.7 - 15.8 | Homework Set 4 | ||
| Week 15 | Apr 26 | Lab: Work on Project 3 | |||
| Apr 28 | Lab 15: Multicriteria Decision Making | 15.16 - 15.17 | HW 4 solutions | ||
| May 3 | Exam 3 - Tuesday: 3:00 - 4:45 |
sample exam 3 sample exam 3 solutions |
| Assignment | Percentage |
|---|---|
| Portfolio | 10% |
| Projects | 30% |
| Examinations | 60% |
Your grade will translate to a letter grade as follows :