Complete Chapter 5 Exercise 3 on an Excel spreadsheet.

3. Sunchem, a manufacturer of printing inks, has five manufacturing plants worldwide. Their locations and capacities are shown in Table 56 along with the cost of producing 1 ton of ink at each facility. The production costs are in the local currency of the country where the plant is located. The major markets for the inks are North America, Europe, Japan, South America, and the rest of Asia. Demand at each market is shown in Table 5-6 . Transportation costs from each plant to each market in U.S. dollars are shown in Table 5-6 . Management must come up with a production plan for the next year. a. If exchange rates are expected as in Table 5-7 , 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? c. Can adding 10 tons of capacity in any plant reduce costs? d. How should Sunchem account for the fact that exchange rates fluctuate over time? Table 5-7 Anticipated Exchanae Rates for the Next Year Table 5-6 Capacity, Demand, Production, and Transportation Costs for Sunchem \begin{tabular}{|l|l|l|l|l|l|l|l|} \hline & North America & Europe & Japan & South America & Rest of Asia & Capacity Tons/Year & Production Cost/Ton \\ \hline United States & $600 & $1,300 & $2,000 & $1,200 & $1,700 & 185 & $10,000 \\ \hline Germany & $1,300 & $600 & $1,400 & $1,400 & $1,300 & 475 & 15,000 euro \\ \hline Japan & $2,000 & $1,400 & $300 & $2,100 & $900 & 50 & 1,800,000 yen \\ \hline Brazil & $1,200 & $1,400 & $2,100 & $800 & $2,100 & 200 & 13,000 real \\ \hline India & $2,200 & $1,300 & $1,000 & $2,300 & $800 & 80 & 400,000 rupees \\ \hline Demandtons/year) & 270 & 200 & 120 & 190 & 100 & & \\ \hline \end{tabular}