In This Portion of an Excel Spreadsheet, the User Has

question 44

Essay

In this portion of an Excel spreadsheet, the user has given values for selling price, the costs, and a sample volume. Give the cell formula for
a.cell E12, break-even volume.
b.cell E16, total revenue.
c.cell E17, total cost.
d.cell E19, profit/loss. $\begin{array}{|l|c|c|c|c|c|}\hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } \\\hline 1 & & & & & \\\hline 2 & & & & & \\\hline 3 & & & & \\\hline 4 &\text { Break-even calculation } & & & \\\hline 5 & & & & \\\hline 6 &&\text { Selling price per unit }&&&10\\\hline 7 & & & & & \\\hline 8 && \text { Costs } \\\hline 9 &&\text { Fixed cost }& & &8400 \\\hline 10 & &\text { Variable cost per unit }& & &4.5 \\\hline 11 & & & & & \\\hline 12 & &\text { Break-even volume } & & & \\\hline 13 & & & & & \\\hline 14 & &\text { Sample calculation } & & & \\\hline 15 & & \text { volume }& & &2000 \\\hline 16 & &\text { Total revenue } & & & \\\hline 17 & &\text { Total cost } & & & \\\hline 18 & & & & & \\\hline 19 & & \text { Profit loss }& & & \\\hline\end{array}$

---

Definitions:

Markets

Any structure that allows buyers and sellers to exchange any types of goods, services, and information.

Central Planners

Officials or bodies within a government responsible for making decisions about the economy’s production and distribution of goods and services.

Communal Ownership

A system where property and resources are owned collectively by a community or society rather than by individual members or companies.

Opportunity Cost

The price paid by not choosing the second-best option available during decision-making.