8.Transportation problem | Optimization using Excel

This is the eighth video of the lecture series Optimization using Excel. In this video, we have discussed how to formulate a transportation LP problem and how to solve that using an Excel solver setup. Viewers are advised to watch the previous videos of the same lecture series (playlist) before watching this video in order to find continuity.
The problem that is solved here is from the book OPERATIONS MANAGEMENT Sustainability and Supply Chain Management - Jay Heizer, Barry Render, Chuck Munson.
The link for the book (Google books) is as follows: www.google.co....
Complete module:
1 Introduction: • 1.Introduction | Optim...
2. Introduction to LP: • 2.Introduction to LP |...
3. Graphical method to solve an LP: • 3.Graphical method an ...
4. Introduction to Solver: • 4.Introduction to Solv...
5. Product mix problem: • 5.Solving a Product Mi...
6. Sensitivity analysis: • 6.Sensitvity and Answe...
7. Integer programming: • 7.Integer programming ...
8. Transportation problem: • 8.Transportation probl...
9. Transshipment problem: • 9.Transshipment Proble...
10. Assignment problem: • 10.Assignment Problem ...
11. Set covering problem: • 10.Assignment Problem ...
12. Blending: • 12.Blending or Diet pr...
13. Network flow introduction: • 13.Network flow models...
14. Shortest path problems: • 14. Shortest Path Prob...
15. Maxflow problem: • 15. Maxflow problem | ...
16. Minimum Spanning Tree problem (Kruskal’s): • 16. Minimum Spanning T...
17. Minimum Spanning Tree problem (Prim’s): • 17. How to solve the M...
18. Travelling Salesman Problem (ILP): • 18. Travelling Salesma...
19. Introduction to NLP: • 19. Introduction to No...
20. Use of GRG solver: • 20. Solving a non-line...
21. Job sequencing model using Evolutionary solver: • 21. A Job Sequencing p...
22. Travelling Salesman Problem using NLP: • 22. Travelling Salesma...

[@giulianopierucci2903]

Please, could you show how to solve the MILP problem? Thanks a lot

[@classicquants778]

If you post the problem, I will try to make a video

[@giulianopierucci2903]

I'm referring to the video example, transportation problem

[@classicquants778]

@@giulianopierucci2903 But the video example is a simple application of a transportation problem which does not require MILP formulation. It is just an LP. MILP will be needed if other types of costs (e.g., fixed costs) are involved in the problem.

[@ie95_Moh]

@@classicquants778 Sir please make a video about this drive.google.com/file/d/1QLdiRT3rzqgYntI6sJy5SOmhFCqUaTWf/view?usp=sharing , it is very good because it will connect between Transportation and Transshipment model.
NOTE:
Please use Excel, not Lingo.
Thank you.

[@ArockiaPraveen-dz2vb]

Can you include the plant operation cost for the same problem and post a video for solving by MILP