You Have Been Given the Following Linear Programming Model and Excel

question 72

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 } \text { MAX: } & 12 X _ { 1 } + 9 X _ { 2 } \\\text { Subject to: } & 9 X _ { 1 } + 10.5 X _ { 2 } \leq 126 \\& X _ { 1 } \geq 5 \\& X _ { 2 } \geq 6 \\& X _ { 1 } , 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: } & 12 & 9 & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & 9 & 10.5 & & 126 \\\hline 9 & 2 & 1 & 0 & & 5 \\\hline 10 & 3 & 0 & 1 & & 6 \\\hline\end{array}$$

---

Definitions:

Before-Tax Distribution

The allocation of income or wealth in a society before the effects of taxes are taken into account.

Progressive Income Tax

A tax system in which the rate of taxation increases as the taxable amount or income increases, making it more proportionately burdensome for wealthier individuals.

Higher Income

A level of earnings or revenue that is above average or an increase in financial earnings.

Marginal Utility

Marginal Utility is the additional satisfaction or benefit gained from consuming one more unit of a product or service.