Question: This is the entire question. For part b, can you please post a screenshot of the excel sheet that details the cells used for better

This is the entire question. For part b, can you please post a screenshot of the excel sheet that details the cells used for better reference :)
1. There are nine cities in Hudson County. The county must determine where to build fire stations. The county wants to build the minimum number of fire stations needed to ensure that at least one fire station is within 14 minutes (driving time) of each city. The times (in minutes) required to drive between the cities in Hudson County are shown in the following table. a) Formulate an Integer Programming model that will tell Hudson where fire stations should be located. b) Solve the problem by using Excel Solver (Hand-in the value and formulas printouts for the problem). Show the optimal solution and optimal value in your printoutsStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
