Use a Modern Software Tool to Perform Statistical Calculations -What Is the Net Production at the End of the the Table

question 2

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 net production at the end of the second quarter?

• A) 75
• B) 200
• C) 450
• D) 600

---

Definitions:

Labor Rate Variance

The difference between the actual cost of labor and the expected (or standard) cost, often used in manufacturing to measure efficiency and cost management.

Favorable

A term typically used in budgeting and accounting to describe variances or outcomes that are better than expected or budgeted figures.

Variable Overhead Rate Variance

The difference between the actual variable overhead incurred and the standard variable overhead estimated.

Variable Overhead Efficiency Variance

The difference between the actual hours taken to produce a good and the standard hours expected, multiplied by the variable overhead rate.