Question: Give decision variables, objective function, and constraints and solve the sum in excel solver begin{tabular}{|l|c|c|c|c|c|c|c|} hline & North America & Europe & Japan & South

Give decision variables, objective function, and constraints and solve the sum inGive decision variables, objective function, and constraints and solve the sum in excel solver

\begin{tabular}{|l|c|c|c|c|c|c|c|} \hline & North America & Europe & Japan & South America & Asia & CapacityTons/Year & ProductionCost/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 Demand(tons/year) & 270 & 200 & 120 & 190 & 100 & & \\ \hline \end{tabular} \begin{tabular}{|l|c|c|c|c|c|} \hline & US\$ & Euro & Yen & Real & Rupee \\ \hline US\$ & 1 & 1.993 & 107.7 & 1.78 & 43.55 \\ \hline Euro & 0.502 & & 54.07 & 0.89 & 21.83 \\ \hline Yen & 0.0093 & 0.0185 & & 0.016 & 0.405 \\ \hline Real & 0.562 & 1.124 & 60.65 & & 24.52 \\ \hline Rupee & 0.023 & 0.046 & 2.47 & 0.041 & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!