Question: What do I need to change (equations/values) in solver in order to get the total distance? Solver Parameters Set Objective: TotalDistance To: Max O Min


What do I need to change (equations/values) in solver in order to get the total distance?
Solver Parameters Set Objective: TotalDistance To: Max O Min Value Of: 0 By Changing Variable Cells: On Route Subject to the Constraints: NetFlow = SupplyDemand Add Change Delete Reset All Load/Save Make Unconstrained Variables Non-Negative Select a Solving Method: Simplex LP Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non- smooth. Close Solve Littletown Fire Department Shortest Path Problem = = Oo = Nodes Fire Staion B D E F G H Farming Community Net Flow Supply/Demand 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 = Range Name Cells Distance F4:F27 From B4:B27 NetFlow 14:113 Nodes H4:H13 OnRoute D4:D27 SupplyDemand K4:K13 C4:C27 Total Distance D29 = = = = OO = 0 0 = -1 From Fire Station Fire Station Fire Station A A B B B B D D E E E E F F G G G H H To On Route A 0 B D 0 0 B 0 0 0 A 0 D D 0 E 0 B B 0 E 0 F 0 E 0 D 0 H 0 G G 0 F 0 Farming Community 0 0 G 0 F 0 0 H 0 Farming Community 0 Farming Community 0 0 G 0 Distance 3 3 6 4 4 6 4 4 2 4 4 4 5 2 7 8 3 3 3 4 5 6 4 4 3 3 2 6 7 2 2 Total Distance 0Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
