Transportation Problem Optimization using Excel Solver

The video "Transportation Problem Optimization using Excel Solver" explains how to solve a balanced transportation problem using Excel Solver. The instructor uses a sample problem from JK Sharma, highlighting cost cells, supply, and demand. Key steps include setting up the Excel sheet with cost, supply, and demand data, using the SUMPRODUCT function to calculate total cost, and configuring Excel Solver by setting the objective to minimize cost. The tutorial also covers adding constraints for supply and demand and selecting the Simplex LP method to find the optimal solution. The process is demonstrated in a clear, step-by-step manner for learners.

[@Yashrathod82]

Good sir 😃

[@Rohit_Lala]

Keep watching

[@profyasheshzaveri3240]

In case of demand imbalance problem, what are sign of demamd constraints and supply constraints?

[@Rohit_Lala]

We need to keep all the things same sir.. to match unbalanced demand we need to add dummy column and meet the remaining demand with equal sign.

[@Rohit_Lala]

ruclips.net/video/jCc4hkCBjwI/видео.html
Thanks for motivation sir