Use the Table Below to Answer the Following Questions) -Which of the Following Is the Excel Formula to Determine

question 18

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 { Prufit Madel } & & \\\hline 2 & & & \\\hline 3 & & & \text { What } \text { V J 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 Cast \$) } & 550,000 & 60,000 \\\hline 8 & \text { Demand } & 60,000 & 65,000 \\\hline 9 & \text { Quantity Praduced } & 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) =MIN0,B8,B9)
• C) =MINB8,B9)
• D) =MAX0,B8,B9)

---

Definitions:

Feasibility Study

A review of the viability and prospective achievement of a planned project or system.

Comprehensive Business Plan

A detailed document that outlines a business's objectives, strategies, market analysis, financial projections, and operational requirements.

Angel Funding

Investment in a startup company by affluent individuals, typically in exchange for ownership equity or convertible debt.

Venture Capital

Financing provided by investors to startups and small businesses with potential for long-term growth.