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

question 15

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 third quarter?

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

Understand the impact of racial discrimination on African-American soldiers during World War Two.

Identify key figures and their roles in race relations and black employment during World War Two.

Analyze the effects of government policies on racial integration and employment during World War Two.

Recognize the contributions of African-American soldiers and workers to the United States' World War Two effort.

---

Definitions:

Sales Growth Rate

The percentage increase in sales over a specific period, indicating the health and expanding nature of a business.

Capacity

The maximum amount that something can contain or produce, often used in the context of production and manufacturing.

Lumpy Assets

Those assets that cannot be acquired smoothly, and that require large, discrete additions. For example, an electric utility that is operating at full capacity cannot add a small amount of generating capacity, at least not economically.

Financial Forecasting

The process of estimating or predicting how a business will perform in the future through the use of historical data and other information.