Please solve using the excel templet and please show the excel functions, thanks!

Grave City is considering the relocation of several police substations to obtain better enforcement in high-crime areas. The locations under consideration together with the areas that can be covered from these locations are given in the following table: Potential Locations for Substations Areas Covered 1,5, 7 1, 2, 5, 7 1, 3, 5 2,4,5 3,4,6 4,5,6 1, 5, 6, 7 Formulate an integer programming model that could be used to find the minimum number of location necessary to provide coverage to all areas. Solve your model. B D E F G H M 3 B E F A 1 Parameters 2 A 4 Area 1 5 Area 2 6 Area 3 7 Area 4 8 Area 5 9 Area 6 10 Area 7 Substation C D 1 1 1 0 0 1 0 0 1 1 0 0 0 0 0 0 1 0 1 1 0 0 0 0 0 1 1 0 1 0 G 0 0 0 1 1 1 0 0 11 A B C D E F G Total Times Covered 12 13 Model 14 15 16 Select? 17 18 19 Area 1 20 Area 2 21 Area 3 22 Area 4 23 Area 5 24 Area 6 25 Area 7 26 27 28 29