Please provide solution through excel with formulas please.

Thank You!

1. (25 points) A manufacturing company is considering opening warehouses in four cities: Seattle, LA, Chicago, and Atlanta. Each warehouse can ship 100 units per week. The weekly fixed cost of keeping each warehouse open is $800 for New York, $1,000 for LA, $600 for Chicago, and $450 for Atlanta. Region 1 of the country requires 80 units per week, region 2 requires 70 units per week, and region 3 requires 40 units per week. The costs of sending one unit from a warehouse to a region are given in the following table. 20 0 50 From To Seattle LA Chicago Atlanta Region 1 Region 2 Region 3 40 48 25 26 26 35 24 50 35 19 The company also needs to satisfy the following conditions. a. If the Chicago warehouse is opened, then the LA warehouse must be opened. b. At most two warehouses can be opened. C. If Seattle warehouse is opened, then LA warehouse cannot be opened. Formulate an integer-programming model for this problem situation