You Have Been Given the Following Linear Programming Model and Excel

question 44

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: } & 2 X _ { 1 } + 7 X _ { 2 } \\\text { Subject to: } & 5 X _ { 1 } + 9 X _ { 2 } \leq 90 \\& 9 X _ { 1 } + 8 X _ { 2 } \leq 144 \\& 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: } & 2 & 7 & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & 5 & 9 & & 90 \\\hline 9 & 2 & 9 & 8 & & 144 \\\hline 10 & 3 & 0 & 1 & & 8 \\\hline\end{array}$$

---

Definitions:

Medium

The material (for example, marble, bronze, clay, fresco) in which an artist works; also, in painting, the vehicle (usually liquid) that carries the pigment.

Humanity

The collective term for all human beings, or the qualities that characterize human beings, such as benevolence, compassion, and the ability to think and reason.

Red And Green

Often considered opposites on the color wheel, this color combination is known for its striking contrast and has various cultural, psychological, and artistic implications.

Parisian Dance Halls

Social venues in Paris famous for public dancing, music, and entertainment, which were particularly popular from the 19th to the early 20th century.