Mathematical optimization for high school

• 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)

• Other links:

  • “What is O.R.?” The movie

  • Optimization at DSB-S: “Sæt dog et andet tog ind - hvor svært kan det være?” by Jens Clausen, former Professor at DTU Management