550.251 Deterministic Math Models

Many of the models discussed in the text can be solved using the following templates. To access these files, run Excel and open the files listed below:

• CPM-Budget.xls
  
• CPM-Deadline.xls
  
• Decision Payoff Table.xls
• FORECAST.XLS
  
• inventory.xls
  
• MARKOV.XLS
  
• NETWORK.XLS
  
• PERT-COST.xls
  
• PERT-CPM.xls
  
• QC.XLS
  
• QUEUE.XLS
  

Some of the material discussed in class is available on the CD that comes with the text.  In particular, we'll be using:

• Supplement 5 which discusses some of the algorithms for the network models.
• Chapter 13 which includes the material on nonlinear optimization.
• Mathematical Formulas for inventory models.
• Derivation of the planned shortage model.
• Production Based Inventory Models