Use the Table Below to Answer the Following Question(s) -Which of the Following Is the Excel Formula to Determine

question 26

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}$
-Which of the following is the Excel formula to determine the number of units sold?

• A) =B8
• B) =MIN(0,B8,B9)
• C) =MIN(B8,B9)
• D) =MAX(0,B8,B9)

Understand the distinction between cost centers, profit centers, and investment centers.

Identify direct and indirect expenses and understand their treatment in departmental costing.

Comprehend the concepts of controllable and uncontrollable costs.

Grasp the basics of departmental income statements and the allocation of expenses.

---

Definitions:

Contract Carrier

A transportation service provider for hire that enters into an agreement with specific customers to transport goods or passengers.

Push Strategy

A marketing approach where a company "pushes" its products to consumers through advertising and promotion strategies.

Speculation Strategy

An approach to investment that involves taking on higher risk in anticipation of significant returns, often based on predictions about market trends.

Hybrid Strategy

A business approach that combines elements of different strategies, such as cost leadership and differentiation, to achieve competitive advantage.