How to Use Sensitivity Analysis In Excel

Oct 27, 2020

Sensitivity analysis gives you insight in how the optimal solution changes when you change the coefficients of the model.

#Tutorial#How To#Data Analysis#Solver

How To Use Shortest Path Problem In Excel

Use the solver in Excel to find the shortest path from node S to node T in an undirected network.

How To Use Transportation Problem In Excel

Use the solver in Excel to find the number of units to ship from each factory to each customer that minimizes the total cost.

How To Use Maximum Flow Problem In Excel

Oct 25, 2020

Use the solver in Excel to find the maximum flow from node S to node T in a directed network.

How To Use Assignment Problem In Excel

Oct 24, 2020

Use the solver in Excel to find the assignment of persons to tasks that minimizes the total cost.

How To Use Capital Investment In Excel

Use the solver in Excel to find the combination of capital investments that maximizes the total profit.