7.Integer programming & Binary Integer programming | Optimization using Excel

This is the seventh video of the lecture series Optimization using Excel. In this video, we have discussed how to solve an integer program and a binary integer program using Excel's solver add-in. For the integer program, we have taken the same problem that we discussed in video number 5 in the same lecture series. So, the viewers are advised to refer to the previous videos in this series in order to find continuity. For the binary integer program, we have taken a simple Knapsack problem from the following book. Book link (from Google book): https://www.google.co.in/books/edition/Introduction_to_Management_Science/zuOzMvyw36sC?hl=en&gbpv=1&dq=Juan+Hernandez,+a+Cuban+athlete+who+visits+the+United+States+and+Europe+frequently,+is+allowed+to+return+with+a+limited+number+of+consumer+items+not&pg=PA226&printsec=frontcover Complete module: 1 Introduction: https://youtu.be/wbnfcUzWGrE 2. Introduction to LP: https://youtu.be/lr9dJNIeBiU 3. Graphical method to solve an LP: https://youtu.be/4KMQjD9vC7U 4. Introduction to Solver: https://youtu.be/enzlJrqV2N4 5. Product mix problem: https://youtu.be/uvk7ixnXzCg 6. Sensitivity analysis: https://youtu.be/rj7h7Zxj8dY 7. Integer programming: https://youtu.be/NloA4Zm6_1o 8. Transportation problem: https://youtu.be/bDHMi8G4e5E 9. Transshipment problem: https://youtu.be/_PLvU3nqUbw 10. Assignment problem: https://youtu.be/VNhsI4pId7g 11. Set covering problem: https://youtu.be/VNhsI4pId7g 12. Blending: https://youtu.be/921SwHikHDI 13. Network flow introduction: https://youtu.be/hla2zRkrJ3g 14. Shortest path problems: https://youtu.be/4T55qfqDLOQ 15. Maxflow problem: https://youtu.be/OQwIYctJaAM 16. Minimum Spanning Tree problem (Kruskal’s): https://youtu.be/uNpf8vvIePs 17. Minimum Spanning Tree problem (Prim’s): https://youtu.be/75MQLe5cpgk 18. Travelling Salesman Problem (ILP): https://youtu.be/WO9NPOXl3aI 19. Introduction to NLP: https://youtu.be/hcGbzqTgUys 20. Use of GRG solver: https://youtu.be/ZJT1fDqyoX8 21. Job sequencing model using Evolutionary solver: https://youtu.be/toGkKF_6_Tw 22. Travelling Salesman Problem using NLP: https://youtu.be/5da-jUXDrps