Please show step by step using excel & excel solver. Show how you complete the decisions variables and constraints table.

Anticipated Exchange Rates for the Next Year Assignment Information Sunchem, a manufacturer of printing inks, has five manufacturing plants worldwide (cells A4:A8).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 B3:F3. Transportation costs from each plant to each market in U.S. dollars are shown in the cells B4:F8. Management must come up with a production plan to meet demand for the next year. 1. How much should each plant produce? What is the minimal total cost for the next year? 2. What if no plant can run below 50% of capacity, how much should each plant produce and which markets should each plant supply