Use a Modern Software Tool to Perform Statistical Calculations -Which of the Following Constraints Is Used in Solver?
A)

question 46

Multiple Choice

Use a modern software tool to perform statistical calculations.
Use the table below to answer the following question(s) using the standard Solver. Below is the spreadsheet for Memphis Designs fixed cost model: $\begin{array}{|l|c|c|c|c|}\hline & \mathrm{A} & \mathrm{B} & \mathrm{C} & \mathrm{D} \\\hline 1 &{\text { Memphis Design Fixed Cost Model }} & & \\\hline 2 & & & & \\\hline 3 & \text { Data } & \\\hline 4 & & \\\hline 5 & \text { Cost } & \text { Quarter 1 } & \text { Quarter 2 } & \text { Quarter 3 } \\\hline 6 & \text { Production } & \$ 10.00 & \$ 15.00 & \$ 13.50 \\\hline 7 & \text { Inventory } & \$ 1.70 & \$ 1.70 & \$ 1.70 \\\hline 8 & \text { Demand } & 200 & 450 & 75 \\\hline 9 & \text { Fixed Cost } & \$ 75.00 & \$ 75.00 & \$ 75.00 \\\hline 10 & \\\hline 11 & \text { Model } \\\hline 12 & \\\hline 13 & & \text { Quarter 1 } & \text { Quarter 2 } & \text { Quarter 3 } \\\hline 14 & \text { Production } & & & \\\hline 15 & \text { Inventory } \\\hline 16 & \text { Binary } \\\hline 17 & \\\hline 18 & \text { Binary constraints } \\\hline 19 & \text { Net Production } \\\hline 20 & & \\\hline 21 & & \text { Cost } \\\hline 22 & \text { Total } & \\\hline\end{array}$
-Which of the following constraints is used in Solver?

• A) $B$14:$D$14 > = $B$18:$D$18
• B) $B$16:$D$16 = binary
• C) $B$19:$D$19 < = $B$8:$D$8
• D) $B$15:$D$15 = binary

---

Definitions:

Journal

A Journal in accounting is the initial record where financial transactions are entered before they are posted to accounts in the ledger, serving as the primary point of documentation for business activities.

Transactions

Business events that involve the exchange of goods, services, or funds, which impact a company's financial statements.

Ledger

A book or collection of financial accounts where transactions are recorded.

Trial Balance

A report that lists all the accounts and their balances at a particular time, used to verify that total debits equal total credits in the double-entry accounting system.