6.Sensitvity and Answer reports | Optimization using Excel

This is the sixth video of the lecture series Optimization using Excel. This is video is the explanation of all the parts of an answer report and sensitivity report generated from Excel's Solver add-in. Viewers are advised to watch the prior videos in the same lecture series "Optimization using Excel" in order to feel the continuity. An answer report is the vivid description of the model output while the sensitivity report is the prediction of the model output when the model parameters change within a certain range. 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 Description in one page can be found in this link: https://www.solver.com/excel-solver-interpreting-sensitivity-report The Solver table can be downloaded from this link: https://host.kelley.iu.edu/albright/free_downloads.htm