Optimization Project:

Go over an example and write a brief report on developing models using LP, obtaining solutions of such models using solver, and performing sensitivity analyses. Interpret the results of your analyses.

Examples from Chapter 14 (old book)

More Examples

Your report should include the following sections. Illustrate each section with corresponding formulations/results in Excel.

• Situation Description and Overall Objective
• Variables and Measures
• Mathematical Model Formulation (Describe objective function and constraints in plain English)
• Development of Spreadsheet Model (Describe spreadsheet equivalent of formulation)
• Results (include interpretation of optimal solution and sensitivity analysis)
• DSS guidelines (describe how one could use your model as a DSS).