Please provide the Excel file that you use to solve the corresponding problems. If you can not attach the excel please show the tables and the excel functions you used to solve.

New fire station(s) are to be located in a city and the major of the city wants to decide where to locate the fire station(s). For planning purposes, the city has been divided into five regions, with no more than one fire station to be located in any given region. The major wants each region to be able to receive service in no more than 13 minutes. The objective is to minimize the total number of fire stations. The following table gives the average response times to a fire in each region.

a) Formulate an integer programming model for this problem. b) Without solving the problem, can you identify in which area the fire station must be located and why?

Region 1 Region 2 Region 3 Region 4 Region 5 Region 1 5 20 12 15 17 Region 2 11 4 20 11 20 Region 3 20 16 6 20 15 Region 4 18 9 15 4 14 Region 5 15 25 12 15 5