You Have Been Given the Following Linear Programming Model and Excel

question 18

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: $\quad 8 X _ { 1 } + 3 X _ { 2 }$
Subject to: $\quad X _ { 2 } \geq 8$
$\begin{array} { l } 8 \mathrm { X } _ { 1 } + 5 \mathrm { X } _ { 2 } \geq 80 \\3 \mathrm { X } _ { 1 } + 5 \mathrm { X } _ { 2 } \geq 60 \\\mathrm { X } _ { 1 } , \mathrm { 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: } & & & & \\\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:

American Sign Language

A complete, natural language that employs signs made with the hands, body movements, and facial expressions to communicate, primarily used by the deaf in the United States and parts of Canada.

Morphemes

The smallest meaningful units of language, which can be words or parts of words (like prefixes or suffixes).

Mental Abilities

The diverse set of cognitive functions and processes related to knowledge, understanding, problem-solving, and intellect.

Babbling

Referring to the developmental phase in infants, babbling is an essential precursor to language development, where infants experiment with making sounds, indicating early speech capability.