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:

Dispatching Rule

A guideline or policy used in scheduling to determine the order in which jobs or tasks are assigned to resources, aiming to optimize a certain objective.

Critical Ratio

A scheduling or prioritization technique that calculates the ratio of the time remaining until a task's due date to the time required to complete the task, used to order tasks by urgency.

Due Date

The specified date by which a task, project, or payment is required to be completed or submitted.

Priority Rule

A guideline or criterion used to determine the sequence in which tasks or operations will be carried out in a process or system.