Use a Modern Software Tool to Perform Statistical Calculations -What Is the Inventory at the End of the First

question 20

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}$
-What is the inventory at the end of the first quarter?

• A) 725
• B) 525
• C) 50
• D) 75