550.251 Deterministic Math Models

Home	Bottom of Page

Algebraic Word Problems

* Class Handout
* Systems of Linear Equations
Introduction to Excel
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.

* An example of solving square systems with Excel: Problem Statements Excel File
* Using Solver

Formulating Linear Programs

* This is a Class Handout that I use some semesters
* Feed Mix Problem
* Feed Mix (Excel)
Graphical Solution of LPs

* Class Handout
Formulating LPs with Excel
See Chapter 3 for additional discussion.

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

Applications of Linear Programs
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
See Chapter 5 for more examples of the transportation, assignment, and shortest path problems.

* Problem Statements

Chinese Postman Problem
* Background and Examples
* An ILP Formulation
* Excel File for above formulation

Project Scheduling (Crashing)
* In Class Example
* In Class Example (Excel)
* Another Example

Project Scheduling (Multiple Projects)
This is also a good example of using binary variables.
* Scheduling Multiple Projects
* Multiple Projects (Excel)

Nonlinear Optimization: Formulation & Excel
* Here are some NLPs we setup in class and an Excel workbook showing how to use Excel to find solutions.

Inventory Models
The main body of the course text focuses on inventory models that must be modeled using nonlinear programming techniques. However, some inventory problems can be described using (integer) linear programming. A few of these are described in
* Introduction to Inventory Management and the accompanying Excel workbook
* Intro to Inventory Mgmt (Excel)

Some other models (not discussed in the text) that can be solved using nonlinear optimization models are
* Multi-Item EOQ
* More Inventory Models

Differential Equations
The photocopied handouts are all taken from Differential Equations by Polking, Bigges, and Arnold, 2nd Edition (unless otherwise stated).
* Introduction
* Separable ODEs
* Linear ODEs
* Models and Applications
* Personal Finance
* Nonrenewable Resources
* Separable ODEs (Examples from Lecture)
* Linear ODEs (Examples from Lecture)

Home