Question: need help doing this in excel. Problem 3: (120 points) Caliente City is located in a particularly warm and arid part of the United States,

need help doing this in excel.
Problem 3: (120 points) Caliente City is located in a particularly warm and arid part of the United States, so prone to the occurrence of fires. However, the city has only one fire station, located in the congested center of the town. The result has been long delays in fire trucks reaching fires in the outer parts of the city, causing more damage than would have occurred with a prompt response. The city residents are very unhappy about this and city council has directed the city manager to develop a plan for locating multiple fire stations throughout the city that would greatly reduce the response time to less than or equal 10 minutes. The city has been divided into 8 tracks. Table 2 shows the estimated response time for a fire in each tract from a potential fire station in each of the eight tracts. The bottom row of the Table 2 shows what the cost would be of acquiring the land and the construction of a fire station in any of the eight tracts. The problem is to determine which tracts should receive a fire station to minimize the total cost of stations while ensuring that each tract has at least one station close enough to respond to a fire in no more than 10 minutes. Formulate and solve a spreadsheet model for thisStep 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
