30 points] Refer the Capacitated Facility Location Model in presentation 8. The transportation costs, demand, fixed cost of each low and high capacity plants is changed as follows: Inputs - Costs, Capacities, Demands Demand Region Production and Transportation Cost per 1,000,000 Units Fixed Low Fixed High Supply Country N. America S. America Europe Asia Africa Cost ($) Capacity Cost ($) Capacity USA 82 96 110 130 115 6,500 10 12,000 25 Brazil 97 79 112 115 106 4,800 10 7,750 20 Germany 105 114 93 108 99 6,500 10 11,750 20 China 115 125 100 65 84 4,500 12 8,150 20 Nigeria 132 110 100 98 69 4,000 12 8,000 20 Demand 15 12 16 20 12 - - - - a. Which facilities should be operated? Which size? What are the shipped quantities to each demand region from each . show work and steps in excel