Figure 1:

Figure 1 Demonstrates an Excel

question 3

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 cell reference designates the Target Cell in "Solver"?

• A)E4
• B)B3
• C)C3
• D)D8:D10
• E)E8:E10

---

Definitions:

Multiple Step Income Statement

An income statement that separates operational revenues and expenses from non-operational ones to calculate net income.

Adjusted Trial Balance

A list of all accounts and their balances after adjusting entries have been made, used to prepare financial statements.

Gross Profit

The difference between revenue and the cost of goods sold, indicating the efficiency of core operations before overhead costs.

Gross Profit Percentage

A financial metric that shows the portion of revenue that exceeds the cost of goods sold, expressed as a percentage.