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

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