Question: INCLUDE SCREESNHOT OF EXCEL WORK, INCLUDING ALL FORMULAS AND SOLVER INPUTS Freedom County consists of six towns that need emergency ambulance service. A station at
INCLUDE SCREESNHOT OF EXCEL WORK, INCLUDING ALL FORMULAS AND SOLVER INPUTS
Freedom County consists of six towns that need emergency ambulance service. A station at a town can serve other towns within minutes less than or equal to of driving time. The table below gives the driving times in minutes among the six towns.
tableTime in minutes from town i to jij
Assuming stations can only be built in these six towns not in between do the following:
apt Formulate an integer linear programming problem mathematically to find the smallest number of stations that will serve all towns. Clearly define the decision variables, objective and constraints.
Station at can serve: etc.
bpt Solve the integer linear programming problem defined in part a using Excel's solver or Python's linprog function. Report the number and locations of the service stations at the optimum.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
