Mathematical optimization in SpreadSheets

• Slides

• Mathematical optimization in spreadsheets:

  Instructions on add-ons for Excel:

  • Microsoft Office Excel add-on
  • OpenSolver

  Instruction on add-ons for Google Sheets:

  • FrontlineSolvers
  • OpenSolver
  • Google Optimization Tools

• The spreadsheet with the data and the solutions of the examples seen in class:

  • Production planning

  • Stigler’s Nutrition plan (Dantzig, G B, Chapter 27.1. In Linear Programming and Extensions. Princeton University Press, Princeton, New Jersey, 1963.)

  • Capital budgeting (from FrontlineSolvers)

  • Transhipment problem