Please help me formulate this answer over excel only and show pictures of formulas so I know how you got the answer. Thank you so much !!

e City is considering the relocation of B24 al police substations to obtain better C D E F G H rcement in high-crime areas. The locations under consideration together with the areas that Parameters be covered from these locations are given in the following table: N Substation A B C D E G Potential Arca 1 Locations for Areas Area 2 0 -o- Substations Covered Area 3 ooo-- Area 4 A 1, 5, 7 Area 5 O oo-- 1, 2, 5, 7 Area 6 10 Area 7 1, 3, 5 11 D 2, 4, 5 Model m 3, 4, 6 A B C D E F G Tota 4, 5, 6 6 Select? G 1, 5, 6, 7 17 18 Times Covered 19 Area | 20 Area 2 mulate an integer programming model that could be used to find the minimum number of 21 Area 3 ation necessary to provide coverage to all areas. Solve your model. 22 Area 4 23 Area 5 24 Area 6 25 Area 7 Question 1 a Question 1 b Question 2 Question 3 Questi Ready