The XYZ Automotive Company manufactures automobiles in four plants and then ships them to three regions of the country. The plant can supply the amounts listed in the right column of Table 1 below. The demands by region are listed in the bottom row of the table, and the unit costs of shipping an automobile from each plan to each region are listed in the middle of the table.

Region 1 Region 2 Region 3 Capacity Plant 1 $128 $260 $370 550 Plant 2 $218 $263 $120 700 Plant 3 $240 $132 $320 450 Plant 4 $350 $140 $330 600 Demand 200 450 300 Develop a spreadsheet optimization model with a two-way table and finds the least-cost way of shipping the automobiles from plants to regions for meeting the demands of the three regions without exceeding capacities of the plants. After running Solver, generate and save the answer report.