Use the Table Below to Answer the Following Questions) -From the "What If" Values, Calculate the Total Cost When

question 45

Multiple Choice

Use the table below to answer the following questions) .
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 Madel } & & \\\hline 2 & & & \\\hline 3 & & & \text { What } \text { if Demand } \\& \text { Data } & & \text { Values } \\\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 cost when demand is 40,000.

• A) " 2,000,"00
• B) $1,925,000
• C) $1,100,000
• D) $75,000

---

Definitions:

Success

The achievement of a goal or the attainment of a desired objective or outcome.

Process Loss

The reduction in team performance due to inefficiencies in group processes, such as coordination problems and conflict.

Task Force

A temporary group assembled to focus on a specific task or project, often multidisciplinary, aiming for a particular goal.

Coordination Problems

Issues that occur when entities attempt to align their actions or activities towards a common goal, but face difficulties due to misunderstandings, conflicting interests, or lack of communication.