excel pls using this spreadsheet

A company is considering opening wareouses in four cities: New York, Los Angeles, Chicago, and Atlanta. Each warehouse dan ship 100 units per week. The weekly fixed cost of keeping each warehouse open is $400 for New York, $500 for Los Angeles, $300 for Chicago, and $150 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 (including production and shipping costs) of sending one unit from a plant to a region are shown in the Homework 8 shell. The company wants to meet weekly demands at minimum cost, subject to the preceding information and the following restrictions: If the New York warehouse is opened, then the Los Angeles warehouse must be opened. At most two warehouses can be opened. Either the Atlanta or the Los Angeles warehouse must be opened. Using the spreadsheet shell provided, develop a model and use Solver to determine which warehouses to open and a shipping schedule that minimizes the company's costs. To Region 1 Region 2 Region 3 From NY $20 $40 $50 LA $48 $15 $26 Chicago $26 $35 $18 Atlanta $24 $50 $35 Warehouses to open (1 if open, if not) NY LA Chicago Atlanta 0 Fixed cost $400 $500 $300 $150 OOO Amount produced and shipped 3 Region 1 9 From NY 80 LA 0 Chicago 0 Atlanta 0 Total 80 Capacity 100 CE Total 80 70 40 0 Se Region 2 Region 3 0 0 70 0 0 40 0 0 70 40 > > 70 40 100 0 At most two open warehouses constraint 2 2 Either Atlanta or LA constraint Logical constraints (don't ship out of a warehouse unless it's open) Shipped out Upper bound NY 190 PILA 190 Chicago 190 Atlanta 190 Objective Cost of opening warehouses Cost of production and shipping Total cost 50 $ $3,370 $3,370