Reduced Cost | Shadow PriceSensitivity analysis gives you insight in how the optimal solution changes when you change the coefficients of the model. After the solver found a solution, you can create a sensitivity report. 1. Before you click OK, select Sensitivity from the Reports section. Below you can find the optimal solution and the […]
Formulate the Model | Trial and Error | Solve the Model Use the solver in Excel to find the combination of capital investments that maximizes the total profit. Formulate the Model The model we are going to solve looks as follows in Excel. 1. To formulate this binary integer programming (BIP) model, answer the following […]
Formulate the Model | Trial and Error | Solve the Model Use the solver in Excel to find the maximum flow from node S to node T in a directed network. Points in a network are called nodes (S, A, B, C, D, E and T). Lines in a network are called arcs (SA, SB, […]
Formulate the Model | Trial and Error | Solve the Model Use the solver in Excel to find the shortest path from node S to node T in an undirected network. Points in a network are called nodes (S, A, B, C, D, E and T). Lines in a network are called arcs (SA, SB, […]
Formulate the Model | Trial and Error | Solve the Model Use the solver in Excel to find the assignment of persons to tasks that minimizes the total cost. Formulate the ModelThe model we are going to solve looks as follows in Excel. 1. To formulate this assignment problem, answer the following three questions. a. […]
Formulate the Model | Trial and Error | Solve the Model Use the solver in Excel to find the number of units to ship from each factory to each customer that minimizes the total cost. Formulate the Model The model we are going to solve looks as follows in Excel. 1. To formulate this transportation […]
Load the Solver Add-in | Formulate the Model | Trial and Error | Solve the Model Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems. Load the Solver Add-in To load the solver add-in, execute the following steps. 1. On the […]
