Please solve using Excel

2.AgroChemicals,amanufactureroffertilizers,hasfivemanufacturingplantsworldwide.Table5S.8showsthegloballocationsoftheseplants,theirproductioncapacities,andthecost(inlocalcurrency)ofproducingonetonoffertilizerineachoftheseplants.ThefertilizersmanufacturedintheseplantsaretransportedtomeetdemandintheregionsofNorthAmerica,Europe,SouthAmerica,Asia,andSouthAfrica.Thetotalshippingcost(inU.S.dollars)fromeachplanttoeachdemandregionandtheannualdemandforfertilizersfromeachoftheseregionsarealsoprovidedinTable5S.8.TheexpectedexchangeratesamongthecountriesareprovidedinTable5S.9. TABLE 55.8 Cost, Capacity, and Demand Data for Agro Chemicals TABLE 5S.9 Expected Exchange Rates plant, and how should demand from each region be a. If the exchange rates given in Table 5S.9 hold for next allocated to each of the plants? b. What impact do exchange rate fluctuations have on Agro Chemicals' production and shipping strategies? 2.AgroChemicals,amanufactureroffertilizers,hasfivemanufacturingplantsworldwide.Table5S.8showsthegloballocationsoftheseplants,theirproductioncapacities,andthecost(inlocalcurrency)ofproducingonetonoffertilizerineachoftheseplants.ThefertilizersmanufacturedintheseplantsaretransportedtomeetdemandintheregionsofNorthAmerica,Europe,SouthAmerica,Asia,andSouthAfrica.Thetotalshippingcost(inU.S.dollars)fromeachplanttoeachdemandregionandtheannualdemandforfertilizersfromeachoftheseregionsarealsoprovidedinTable5S.8.TheexpectedexchangeratesamongthecountriesareprovidedinTable5S.9. TABLE 55.8 Cost, Capacity, and Demand Data for Agro Chemicals TABLE 5S.9 Expected Exchange Rates plant, and how should demand from each region be a. If the exchange rates given in Table 5S.9 hold for next allocated to each of the plants? b. What impact do exchange rate fluctuations have on Agro Chemicals' production and shipping strategies