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

---

Definitions:

New Classical

An economic theory that emphasizes the importance of rational expectations and market-clearing prices in understanding economic fluctuations.

Rational Expectations

The hypothesis that forecasts of future values of economically relevant variables are based on all available information and are therefore optimal.

Keynesians

Followers and theorists of Keynesian economics, which emphasizes the need for government intervention in economies to manage output and demand through fiscal and monetary policies.

Classical School

A school of economic thought that emphasizes the importance of free markets, competition, and the self-regulating nature of economies.