Optimizing machine changeovers in Excel and Python

An practical introduction to mathematical programming in Excel and Python

This course provides a practical introduction to mathematical modeling and optimization in Excel and Python, using

• Excel Solver in Excel
• PuLP and default free solvers through PuLP in Python

A concrete use case serves as application example: Mathematical optimization of machine setup and changeover sequences. There are many versions of this problem, but in course we will focus on two single machine setup and changeover sequencing problems:

1. Optimal setup and changeover sequence for a one-time production program
2. Optimal changeover sequence for a repeated production cycle, i.e. repetitive cyclic production program

As part of this course, you will see and learn

• How to formally define a changeover sequencing problem mathematically
• Get an overview of modeling frameworks and solvers in Excel and Python
• How to setup Excel Solver and how to implement mathematical models with Excel Solver
• How to implement and solve mathematical optimization models with PuLP in Python

As part of the course you will be get access to case study data, case study descriptions, mathematical model defintions, Excel files, and Python scripts. You can use these as templates for your specific problem.