We revisit and extend the posted exercise Optimizing the Location of a Facility. Here we consider the following facility location model. A firm would like to choose the site of a new distribution center that will simultaneously serve eight of its sales centers in Pennsylvania. These sales centers (SC) are all located within the rectangular planar area 0x280,0y170 (each unit of distance corresponds to one mile). Next, you select the given sales center locations yourself, so that everyone's exam is solved for a different set of sales center locations. Also select the monthly number of deliveries that must be made to each sales center: again (except due to random happenstance), different integer values between 10 and 30 are expected from each person. Suppose that truck delivery costs are $1.00 per mile for trucks that travel between the distribution center and the sales centers. (For simplicity, we are not considering any other costs.) As before, for simplicity we also assume that truck delivery distances are based on the Euclidean distance between two points in the plane. To illustrate the problem-type to solve, below is my model-instance configuration: With your own data (SC locations and number of deliveries), select the site of a new distribution center that will simultaneously serve all eight sales centers at minimized total transportation cost. Formulate and solve your model using Excel. Include a graphical image of your problem and its solution