ignore part f

Someone created the following spreadsheet to solve this problem. B F G H F # Hospitals Covering This City City A B 1 2 3 4 5 6 7 8 9 10 11 OOOO--> D E Cities Within 50 Miles B D 1 0 1 0 1 1 1 1 1 OOOOO OOO OOO OOOO m 1 1 Open Hospital? Hospital Cost 5 11 8 12 10 13 Total Cost Answer the following questions. (2 POINTS EACH) Y The formula for the total cost (cell H10) would be -SUMPRODUCT(B9:49,810: The formula for the number of hospitals covering City (cell H5) would be -SUMBS:G5) Suppose that local politics dictate that if we open a hospital in City A, then we must also open a hospital in City F. We could enforce this by adding the following Solver constraint: Select] Someone created the following spreadsheet to solve this problem. B F G H F # Hospitals Covering This City City A B 1 2 3 4 5 6 7 8 9 10 11 OOOO--> D E Cities Within 50 Miles B D 1 0 1 0 1 1 1 1 1 OOOOO OOO OOO OOOO m 1 1 Open Hospital? Hospital Cost 5 11 8 12 10 13 Total Cost Answer the following questions. (2 POINTS EACH) Y The formula for the total cost (cell H10) would be -SUMPRODUCT(B9:49,810: The formula for the number of hospitals covering City (cell H5) would be -SUMBS:G5) Suppose that local politics dictate that if we open a hospital in City A, then we must also open a hospital in City F. We could enforce this by adding the following Solver constraint: Select]