please answer question 3 a and b. please solve using solver in excel and how to do so (the constraints, etc) the answer on chegg isn't correct

all all CluLUNUI De Sllould be s has five manufac- DryIce build its factories and how large should they be? ( 3. Sunchem, a manufacturer of printing inks, has five ma turing plants worldwide. Their locations and capacities shown in Table 5-7 along with the cost of producing 1 tono apacities are ink at each facility. The production costs are in the local cur- rency of the country where the plant is located. The major markets for the inks are North America, South America, Europe, Japan, and the rest of Asia. Demand at each market is shown in Table 5-7. Transportation costs from each plant to each market in U.S. dollars are shown in Table 5-7. Manage- ment must come up with a production plan for the next year. a. If exchange rates are expected as in Table 5-8, and no plant can run below 50 percent of capacity, how much should each plant produce and which markets should each plant supply? b. If there are no limits on the amount produced in a plant, how much should each plant produce? TABLE 5-8 Anticipated Exchange Rates for the Next Year US$ Yen US$ Euro Yen Real Rupee 1.000 0.502 0.0093 0.562 0.023 Euro Real Rupee 1.993 107.7 1.78 4 3.55 1 54.07 0.89 21.83 0.0185 1. 0.016 0.405 1.12460.65 1 24.52 0.046 2.470.041 1 TABLE 5-7 Capacity, Demand, Production, and Transportation Costs for Sunchem North South Capacity Production America Europe Japan America Asia Tons/Year Cost/Ton United States $600 $1,300 $2,000 $1,200 $1,700 185 $10,000 Germany $1,300 $600 $1,400 $1,400 $1,300 475 15,000 euro Japan $2,000 $1,400 $300 $2,100 $900 50 1,800,000 yen Brazil $1,200 $1,400 $2,100 $800 $2,100 200 13,000 real India $2,200 $1,300 $1,000 $2,300 $800 80 400,000 rupees Demand 270 200 120 190 100 (tons/year)