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
![Optimizing machine changeovers in Excel and Python Optimizing machine changeovers in Excel and Python](https://d3mxt5v3yxgcsr.cloudfront.net/courses/18952/course_18952_image.jpg)
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
![Tutorialspoint](/market/public/assets/images/loader.gif)
Solving machine changeover sequencing problem with Excel Solver
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Solving machine changeover sequencing problem in Python
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Resources
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Linnart Felkl M.Sc.](https://www.tutorialspoint.com/assets/profiles/1207375/profile/200_171960-1716294240.jpg)
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.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
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 now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)