This question refers to $$Facility Location $/$ Distribution: example$$ in the slides.

The purpose of this question is to find a solution to the integer linear programming model

using Excel Solver. The template worksheet can be found in hw$8.$xlsx$.$

Complete the Excel implementation in worksheet $$HW $8$ Facility Location$,$ and solve the

problem using Solver.

$10.$ Write down the Excel formula that goes in cell J$21.$

$11.$ Write down the Excel formula that goes in cell L$21.$

$12.$ Write down the Excel formula that goes in cell H$22.$

$13.$ Write down the Excel formula that goes in cell H$24.$