You Have Been Given the Following Linear Programming Model and Excel

question 50

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:


$\begin{array}{|l|l|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: } & & & & \begin{array}{l}\text { OBJ. FN. } \\\text { VALUE }\end{array} \\\hline 5 & \text { Unit profit: } & 8 & 5 & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & 3 & 5 & & 54 \\\hline 9&2 & 1 & 1 & & 14 \\&& 1 & 0 && 4 \\\hline 10 & 3 & 1 & 0 & & 12 \\\hline\end{array}$

---

Definitions:

Government Intervention

Actions taken by a government to influence or regulate economic activity, often to correct market failures and achieve desired social or economic outcomes.

Prices

The sum needed to buy a product or service, shaped by aspects such as the availability of the item and the desire for it from consumers.

Economic Activity

Actions that involve the production, distribution, and consumption of goods and services within an economy.

Market Economy

An economic system where supply and demand from consumers and businesses drive the production and allocation of resources and services, with minimal government intervention.