5.Solving a Product Mix Problem using Solver | Optimization using Excel

This is the fifth video of the lecture series Optimization using Excel. In this video, we have explained how to enter algebraically formulated linear programming into an Excel worksheet and Solver add-in. The problem selected here is a Product Mix problem. Viewers are advised to watch the previous videos in the same series in order to maintain continuity. 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 Excel solver documentation: https://support.microsoft.com/en-us/office/load-the-solver-add-in-in-excel-612926fc-d53b-46b4-872c-e24772f078ca Excel solver limitations: https://www.solver.com/standard-excel-solver-dealing-problem-size-limits Free alternative to built-in solver: https://opensolver.org/