Figure 1:

Figure 1 Demonstrates an Excel

question 23

Multiple Choice

Figure 1:

Figure 1 demonstrates an Excel spreadsheet that is used to model the following linear programming problem:
$$\begin{array} { l l } \operatorname { Max } : & 4 \mathrm { X } _ { 1 } + 3 \mathrm { X } _ { 2 } \\\text { Subject to: } & \\& 3 \mathrm { X } _ { 1 } + 5 \mathrm { X } _ { 2 } \leq 40 \\& 12 \mathrm { X } _ { 1 } + 10 \mathrm { X } _ { 2 } \leq 120 \\& \mathrm { X } _ { 1 } \geq 15 \\& \mathrm { X } _ { 1 } , \mathrm { X } _ { 2 } \geq 0\end{array}$$
Note: Cells B3 and C3 are the designated cells for the optimal values of X₁ and X₂,respectively,while cell E4 is the designated cell for the objective function value.Cells D8:D10 designate the left-hand side of the constraints.
-Refer to Figure 1.What formula should be entered in cell E4 to compute total profitability?

• A)=SUMPRODUCT(B5:C5,B2:C2)
• B)=SUM(B3:C3)
• C)=B2*B5 + C2*C5
• D)=SUMPRODUCT(B5:C5,E8:E10)
• E)=B3*B5 + C3*C5

Understand the trade-off between equity and efficiency in the allocation of resources.

Comprehend how the principle of gains from trade operates within and benefits an economy.

Recognize how individual spending influences the income of others in the economy.

Understand the concept of public goods and externalities as challenges to market efficiency.

---

Definitions:

Liability Rule

A legal principle that governs how damages or losses are allocated in cases of harm or infringement, typically requiring compensation from the party at fault.

Garden Gnome

Decorative figurines of mythical gnomes, typically placed in gardens or on lawns.

Coase Theorem

A concept in economics that if trade in an externality is possible and there are no transaction costs, bargaining will lead to an efficient outcome regardless of the initial allocation of property.

External Benefit

A benefit derived from a product or service that affects people who are not directly involved in the transaction or production of it.