Problem $2$: Set Covering Application $(25$ points$)$

Prince Goerge municipality would like to decide how many health care clinics would be required to serve $7$ communities in the region. Each clinic would serve a radius of $35$ minutes driving time. The table below shows the times it takes to travel between the $7$ communities. How many clinics would be needed and in which communities should they be located?

$\backslash$table$[[,$A$,$B$,$C$,$D$,$E$,$F$,$G$],[$A$,--,15,20,35,35,55,55],[$B$,,--,35,20,20,40,40],[$C$,,,--,15,75,60,35],[$D$,,,,---,35,20,20],[$E$,,,,,---,15,40],[$F$,,,,,,---,25],[$G$,,,,,,,--]]$

a$)$ Formulate algebraically this BIP problem. Define the decision variables, objective function, and constraints. $(14$ points$).$

b$)$ Formulate and solve this BIP problem on a spreadsheet and solve using Excel's Solver $($Provide the corresponding "Excel Spreadsheet" and the "Answer Report"$).$ Include "managerial statements" of the optimal decision $($i$.$e$.,$ describe verbally How many clinics would be needed and in which communities should they be located$).(11$ points$).$

Please do part b$)$ its more important and show the steps on how to build exel solver. Would much apreciate the help.