Optimizing Machine Changeovers In Excel And Python

An practical introduction to mathematical programming in Excel and Python

What you'll 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

Requirements

Basic knowledge of linear programming required

Basic knowledge of mathematical programming required

Basic Python knowledge required

Basic Excel knowledge required

Description

This course provides a practical introduction to mathematical modeling and optimization in Excel and Python, usingExcel Solver in Excel PuLP and default free solvers through PuLP in PythonA 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:Optimal setup and changeover sequence for a one-time production programOptimal changeover sequence for a repeated production cycle, i.e. repetitive cyclic production programAs part of this course, you will see and learnHow to formally define a changeover sequencing problem mathematicallyGet an overview of modeling frameworks and solvers in Excel and PythonHow to setup Excel Solver and how to implement mathematical models with Excel Solver How to implement and solve mathematical optimization models with PuLP in PythonAs 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 courseSome basic knowledge of mathematical programming: You should have head about linear optimization beforeIntermediate Python skills: You should know what a list comprehension is, and you should be familiar with common libraries such as NumPyBeginner 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

Overview

Section 1: Introduction to machine changeover sequencing

Lecture 1 Course introduction and overview

Lecture 2 Understanding the changeover and setup sequencing problem

Section 2: Mathematical programming for machine changeover sequencing

Lecture 3 Mathematical model for the one time only production program

Lecture 4 Mathematical model for the repeated production cycle problem

Section 3: Solving machine changeover sequencing problem with Excel Solver

Lecture 5 Activating and using the Excel Solver add-in

Lecture 6 Getting started in Excel Solver - simple first optimization model

Lecture 7 Implementing the repeated production cycle problem in Excel Solver

Lecture 8 Implementing the one-time-only production program problem in Excel Solver

Section 4: Solving machine changeover sequencing problem in Python

Lecture 9 Tools in Python for mathematical modeling and optimization

Lecture 10 Getting started in Python - simple first optimization model

Lecture 11 Implementing the repeated production cycle problem in Python

Lecture 12 Implementing the one-time-only production program in Python

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