You Have Been Given the Following Linear Programming Model and Excel

question 13

Essay

You have been given the following linear programming model and Excel spreadsheet to solve this problem. What formulas should be entered into cells E5 and D8:D10 to implement this model?
$$\begin{array} { l l } \text { MAX: } & 4 X _ { 1 } + 3 X _ { 2 } \\\text { Subject to: } & 6 X _ { 1 } + 7 X _ { 2 } \leq 84 \\& X _ { 1 } \leq 10 \\& X _ { 2 } \leq 8 \\& X _ { 1 } , X _ { 2 } \geq 0\end{array}$$ $$\begin{array} { | c | c | c | c | c | c | } \hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } \\\hline 1 & & & & & \\\hline 2 & & & & & \\\hline 3 & & \mathrm { X } _ { 1 } & \mathrm { X } _ { 2 } & & \\\hline 4 & \text { Number to make: } & & & & \text { OBJ. FN. VALUE } \\\hline 5 & \text { Unit profit: } & 4 & 3 & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & 6 & 7 & & 84 \\\hline 9 & 2 & 1 & 0 & & 10 \\\hline 10 & 3 & 0 & 1 & & 8 \\\hline\end{array}$$

---

Definitions:

Global Financial Markets

The worldwide forums that exist for exchanging securities, currencies, and other financial instruments among global participants.

Domestic Markets

Markets within a country's borders that involve the buying and selling of goods and services among its residents.

United Nations

An international organization formed in 1945 to promote peace, security, and cooperation among the world's countries.

Global Peace

A state of harmony among countries and societies around the world, characterized by the absence of conflict and the presence of cooperative international relationships.