Optimizing machine changeovers in Excel and Python

An practical introduction to mathematical programming in Excel and Python

Ratings: 0.00 / 5.00




Description

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.


Requirements for taking this course

  • Some basic knowledge of mathematical programming: You should have head about linear optimization before

  • Intermediate Python skills: You should know what a list comprehension is, and you should be familiar with common libraries such as NumPy

  • Beginner Excel skills: You should be comfortable writing and using formulas, but you do not need to have heard about Excel Solver before; and you will also not need to write any macros etc. at all

What You Will Learn!

  • How to use Excel Solver in Excel for mathematical programming
  • How to use Python for mathematical programming
  • Define a changeover matrix for a machine
  • Define changeover sequencing problem as mathematical optimization problem
  • Implement a single machine changeover sequence optimization problem in Excel Solver
  • Implement a single machine changeover sequence optimization problem in Python

Who Should Attend!

  • Production planners
  • Excel and Python learners
  • Students of majors such as operations research, industrial engineering, production management, or similar