USING EXCEL. WHICH TWO SITES SHOULD BE SELECTED TO MINIMIZE TOTAL FIXED AND SHIPPING COSTS. PLEASE INCLUDE ALL CELL EXPRESSIONS (NOT JUST NUMBERS INSIDE CELLS) AND A SCREENSHOT OF SOLVER WITH OBJECTIVE FUNCTION, VARIABLES TO BE CHANGED AND CONSTRAINTS TO ENSURE LIKE.

A company needs to decide on the locations for two new warehouses. The candidate sites are Philadelphia, Tampa, Chicago, and Denver. The following table provides the monthly capacities and the monthly fixed costs for operating warehouses at each potential site. Warehouse Philadelphia Tampa Chicago Denver Monthly Capacity (units) 250 260 280 270 Monthly Fixed Cost $1000 $800 $1200 $700 The warehouses will need to ship to three marketing areas: North, South, and West. Monthly requirements are 200 units for North, 180 units for South, and 120 units for West. The following conditions must be met by the final decision: (1) A warehouse must be opened in either Philadelphia or Denver, and (2) if a warehouse is opened in Tampa, then one must also be opened in Chicago. Finally, the following table provides the cost to ship one unit between each location and destination. Warehouse Philadelphia Tampa Chicago Denver North $4 $6 $5 South $7 $3 $6 $10 West $9 $11 $5 $2 $8 Formulate the given decision problem as an integer linear program to determine which two sites should be selected for the new warehouses as to minimize total fixed and shipping costs. Setup/solve