Optimizing machine changeovers in Excel and Python
An practical introduction to mathematical programming in Excel and Python
Lectures -12
Resources -11
Duration -2 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course 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 an 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 program
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 have access to case study data, case study descriptions, mathematical model definitions, Excel files, and Python scripts. You can use these as templates for your specific problem.
Goals
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
Prerequisites
Basic knowledge of linear programming required
Basic knowledge of mathematical programming required
Basic Python knowledge required
Basic Excel knowledge required
Curriculum
Check out the detailed breakdown of what’s inside the course
Course introduction
2 Lectures
- Course introduction and overview 02:38 02:38
- Understanding the changeover and setup sequencing problem 02:58 02:58
Mathematical programming for machine changeover sequencing
2 Lectures
Solving machine changeover sequencing problem with Excel Solver
4 Lectures
Solving machine changeover sequencing problem in Python
3 Lectures
Resources
1 Lectures
Instructor Details
Linnart Felkl M.Sc.
Industrial engineer with a M.Sc. from ETH Zürich and many years of industrial optimization and simulation experience for business process, logistics system, and manufacturing process improvement.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now