You Have Been Given the Following Linear Programming Model and Excel

question 54

Essay

You have been given the following linear programming model and Excel spreadsheet to solve this problem.What numbers should be entered into cells B5:C5 and B8:C10 to implement this model?
MIN: ^{8 X}₁ ^{+ 3 X}₂
Subject to: ^X₂ ^{≥ 8}
8 X₁ + 5 X₂ ≥ 80
3 X₁ + 5 X₂ ≥ 60 X₁,X₂ ≥ 0
$\begin{array}{|c|c|c|c|c|c|} \hline& \mathrm{A} & \mathrm{B} & \mathrm{C} & \mathrm{D} & \mathrm{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: } & & & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & & & &8 \\\hline 9 & 2 & & & & 80 \\\hline 10 & 3 & & & & 60 \\\hline\end{array}$

---

Definitions:

Judgments

Assessments or opinions formed about something, not necessarily based on fact or knowledge.

Indisputable Facts

Information or statements that are accepted as true and cannot be argued against or disputed.

Ethical Thinking

The process of considering actions and decisions in terms of moral values and principles.

Own Ethics

Personal or individual moral principles that govern one's behavior and decision-making.