Solved

In This Portion of an Excel Spreadsheet, the User Has

Question 43

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.  A  B  C  D  E 1234 Break-even calculation 56 Selling price per unit 1078 Costs 9 Fixed cost 840010 Variable cost per unit 4.51112 Break-even volume 1314 Sample calculation 15 volume 200016 Total revenue 17 Total cost 1819 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}

Correct Answer:

verifed

Verified

a.=E9/(E6-...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents