550.251 Deterministic Math Models
Spring 2008

Home	Bottom of Page

Algebraic Word Problems (Wednesday, January 30, 2008)

* Class Handout
Introduction to Excel (Thursday, January 31, 2008)
See Chapters 1 and 2 in the text for a discussion of Excel functions and instructions on how to load and use the Solver Add-In for solving linear programs.

* Section 1 Handout
* Section 1 Excel Workbook
* Using Solver (another example)

Formulating Linear Programs (Friday, February 01, 2008)

* Class Handout
Graphical Solution of LPs (Monday, February 04, 2008)

* Class Handout
Formulating LPs with Excel (Thursday, February 07, 2008)
See Chapter 3 for additional discussion.

* Section 2 Handout
* Section 2 Excel Workbook
* Galaxy Industries Model
* Galaxy Industries Excel Workbook

Applications of Linear Programs (Friday, February 08, 2008)
See Chapter 4 for more examples.

* Problem Statements
* Galaxy Expansion Excel Workbook
* St. Josephs Excel Workbook

Writing Reports And Memos
This document provides guidelines for writing up your case studies.

* Reports and Memos

Network Models (Wednesday, February 13, 2008)
See Chapter 5 for more examples of the transportation, assignment, and shortest path problems.

* Problem Statements

Section Notes (Thursday, February 14, 2008)
* Section 3 Handout
* Section 3 Excel Workbook

Dijkstra's Algorithm (Wednesday, February 20, 2008)
* Example

Section Notes (Thursday, February 21, 2008)
* Section 4 Handout
* Section 4 Excel Workbook

Minimum Spanning Tree (Wednesday, February 27, 2008)
* MST Algorithms

Traveling Salesperson Problem (Wednesday, February 27, 2008)
* Examples

Integer Programming (Friday, February 29, 2008)
* Graphical Solution Method

Integer Programming -- Logical Constraints (Wednesday, March 05, 2008)
* Formulation Examples

Section Notes (Thursday, March 06, 2008)
* Section 6 Handout
* Section 6 Data (Excel)
* Section 6 Solutions (Excel)

Knapsacks & Capital Budgeting (Friday, March 07, 2008)
* Knapsack Problems

Project Scheduling (Crashing) (Wednesday, March 12, 2008)
(sorry these are late!)
* In Class Example
* In Class Example (Excel)
* Another Example

Facility Location on Networks (Wednesday, March 12, 2008)
* In Class Example
* In Class Example (Excel)

Section Notes (Thursday, March 13, 2008)
* Section 7 Handout
* Section 7 (Excel)

Inventory Models
* EPQ Model
* Time-Varying Demand

Multivariate Optimization (Friday, April 4, 2008)
* Schaum's Outline

Regression (Monday, April 14, 2008)
* Schaum's Outline

Section Notes (Thursday, April 17, 2008)
* Excel file

Mathematical Review (Friday, April 18, 2008)
* Integration Refresher

Differential Equations (April 23 -- May 02, 2008)
The photocopied handouts are all taken from Differential Equations by Polking, Bigges, and Arnold, 2nd Edition.
* Introduction
* Separable ODEs
* Linear ODEs
* Models and Applications
* Separable ODEs (Examples from Lecture)
* Linear ODEs (Examples from Lecture)

Home