SHOW IN EXCEL!!

Locating and assigning service centers The State of Texas frequently audits companies doing business in Texas. Because these companies often have headquarters outside the state, auditors must be sent to out-of-state locations. Each year, auditors must make the following number of trips to the cities in each region: Sate of Texas is considering basing auditors in one or more of the following cities: New York, Chicago, Los Angeles, and Atlanta. The cost of sending an auditor from any of these bases to a region is given below. Determine the bases to open and regions to assign to each open base in order to minimize the total annual trip cost subject to assigning each region to exactly one base, having a total of 2 bases, and assigning maximum of 2 regions to a base