Assignment Information PLEASE SHOW EXCEL FORMULAS USED TO CALCULATE!!!!

Sunchem, a manufacturer of printing inks, has five manufacturing

plants worldwide $($cells A$4$:A$8).$Their locations and capacities are shown

in the above table along with the cost of producing $1$ ton of ink at each

facility $($cell $H4$:$H8).$ The production costs are in the local curency of the

country where the plant is located. The markets are listed in cells

B$3$:F$3.$ Transportation costs from each plant to each market in U$.$S$.$

dollars are shown in the cells B$4$:F$8.$ Management must come up with a

production plan to meet demand for the next year.

How much should each plant produce? What is the minimal total

cost for the next year?

What if no plant can run below $50\%$ of capacity, how much should

each plant produce and which markets should each plant supply?