Please give formulas/complete excel sheet provided, and answer questions based on it.

1- Sunchem, a manufacturer of printing inks, has five manufacturing plants worldwide. Their locations and capacities are shown in the following table with the cost of producing 1 ton of ink at each facility. The major markets for the inks are North America, Europe, Japan, South America, and the rest of Asia. Demand at each market, and transportation costs from each plant to each market are shown in the table as well. Management must come up with a production plan for the next year. a. How much should each plant produce and which markets should each plant supply'? g 10 tons of capacity in just one plant reduce costs? Which plant is the better choice for adding the capacity? N. America Europe Japan S. AmericaCapacity Production (tons/year) (cost/ton) $10000 $7,530 $16,740 $7,306 $9,200 Asia $1300 $2000$1200 $600 $1400 $1400 $2000 $1400$300$2100 $1200$1400 $2100 $800 $2200 ? $1300-000| $2300 $1700 $1300 $900 185 475 50 200 80 USA $600 Japan Brazil India Demand (tons/year) $100 $2100 $800 100 270 200 120 190 1- Sunchem, a manufacturer of printing inks, has five manufacturing plants worldwide. Their locations and capacities are shown in the following table with the cost of producing 1 ton of ink at each facility. The major markets for the inks are North America, Europe, Japan, South America, and the rest of Asia. Demand at each market, and transportation costs from each plant to each market are shown in the table as well. Management must come up with a production plan for the next year. a. How much should each plant produce and which markets should each plant supply'? g 10 tons of capacity in just one plant reduce costs? Which plant is the better choice for adding the capacity? N. America Europe Japan S. AmericaCapacity Production (tons/year) (cost/ton) $10000 $7,530 $16,740 $7,306 $9,200 Asia $1300 $2000$1200 $600 $1400 $1400 $2000 $1400$300$2100 $1200$1400 $2100 $800 $2200 ? $1300-000| $2300 $1700 $1300 $900 185 475 50 200 80 USA $600 Japan Brazil India Demand (tons/year) $100 $2100 $800 100 270 200 120 190