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:

Journal

A record where all financial transactions are initially documented in chronological order.

Record

The act of documenting business transactions in the financial books of a company.

Stockholders' Equity Accounts

Accounts on a company's balance sheet that represent the ownership interest of shareholders, including common stock, retained earnings, and additional paid-in capital.

Credits

Accounting entries that increase liabilities or equity accounts, or decrease asset or expense accounts, reflecting the sources of the value in the transaction.