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:

Quarterly Sales

The total value of all sales achieved by a company during a specific three-month period.

Chapters

Sections or divisions in documents or publications, such as books, typically indicating a change in subject, theme, or story progression.

Unsystematic Risk

The risk of price changes in a company's stock due to factors specific to the company, as opposed to market-wide factors.

Treasury Bills

Short-term U.S. government debt obligations maturing in one year or less, considered a safe and liquid investment.