You Have Been Given the Following Linear Programming Model and Excel

question 69

Essay

You have been given the following linear programming model and Excel spreadsheet to solve this problem. What cell references would you enter in the Risk Solver Platform (RSP) task pane for the following?
Objective Cell:
Variables Cells:
Constraints Cells:
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 & & 1 & & 8 \\\hline 9 & 2 & 8 & 5 & & 80 \\\hline 10 & 3 & 3 & 5 & & 60 \\\hline\end{array}$$

---

Definitions:

LMS

A Learning Management System (LMS) is a software application for the administration, documentation, tracking, reporting, and delivery of educational courses or training programs.

Modified Date

The date on which a file or document was last altered or saved after being created or previously modified.

Left-Handed

Referring to individuals who predominantly use their left hand for activities such as writing and handling objects, often requiring specific ergonomic adaptations.

Arithmetic Logic Unit

A component of a computer's processor (CPU) responsible for carrying out arithmetic and logic operations, such as addition, subtraction, and comparisons.