You Have Been Given the Following Linear Programming Model and Excel

question 7

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?

$\begin{array}{|l|l|l|l|l|l|} \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: } & & & & \begin{array}{l}\text { OBJ. FN. } \\\text { VALUE }\end{array} \\\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:

Beer Industry

A sector of the economy devoted to the production, distribution, and sale of beer.

HHI

Herfindahl-Hirschman Index, a measure of the size of firms in relation to the industry and an indicator of the amount of competition among them.

Justice Department

A federal executive department of the U.S. government responsible for the enforcement of the law and administration of justice.

Sustainable Career Advantage

A long-term career benefit that is maintained through continuous learning and adapting to changes in the job market or industry.