Use the Table Below to Answer the Following Question(s) -From the "What If" Values, Calculate the Total Profit When

question 48

Multiple Choice

Use the table below to answer the following question(s) .
In the spreadsheet below, there is data on the price, cost, demand, and quantity produced for an item. There are also different "what if" values that can help a manager to calculate costs and revenue with variability in demand. $\begin{array}{|l|l|l|l|}\hline & \text { A } & \text { B } & \text { C } \\\hline 1 & \text { Profit Model } & & \\\hline 2 & & & \\\hline 3 & \text { Data } && \begin{array}{l}\text { What-If } \text { Demand } \\\text { Values }\end{array} \\\hline 4 & & & 20,000 \\\hline 5 & \text { Unit Price (\$) } & 50 & 40,000 \\\hline 6 & \text { Unit Cost (\$) } & 25 & 55,000 \\\hline 7 & \text { Fixed Cost (\$) } & 550,000 & 60,000 \\\hline 8 & \text { Demand } & 60,000 & 65,000 \\\hline 9 & \text { Quantity Produced } & 55,000 & \\\hline 10 & & & \\\hline\end{array}$
-From the "what if" values, calculate the total profit when the demand is 20,000.

• A) $825,000
• B) $1,000,000
• C) $1,100,000
• D) ($925,000)

---

Definitions:

Dynamically Continuous Innovation

Innovation that represents a significant change to an existing product or process but does not entirely disrupt consumer habits and behaviors.

Digital Camera

An electronic device that captures and stores photographs digitally, rather than using film to record images.

Single-Lens Reflex Camera

A type of camera that uses a mirror mechanism to allow the photographer to view through the lens and see exactly what will be captured.

Early Majority

A category in the diffusion of innovation theory describing individuals who adopt new products or ideas after the innovators and early adopters, representing a larger segment of the population.