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:

Net Present Value

The difference between the present value of cash inflows and the present value of cash outflows over a period of time.

Discount Rate

The interest rate used in discounted cash flow analysis to determine the present value of future cash flows.

Working Capital

The difference between a company’s current assets and current liabilities, indicating the short-term financial health and operational efficiency.

Salvage Value

This is the estimated resale value of an asset at the end of its useful life, used in calculating depreciation.