Help

Save & E

Use the accompanying Profit$\_$Analysis spreadsheet model to answer the following questions.

Click here for the Excel Data File

a$.$ Use the data table tool to show the impact of quantity ranging from $1,500$ to $6,900$ with $500$ unit increments on the total revenues, total costs, and total profits. What are the revenues, costs, and profits for $5,400$ units?

$\backslash$table$[[$Total revenues$],[$Total costs$],[$Total profits$]]$

b$.$ Use the data table tool to show the impact of labor costs ranging from $$5\mathrm{.}00$ to $$8\mathrm{.}00$ with $$0\mathrm{.}50$ increments and price per item ranging from $$10\mathrm{.}99$ to $$15\mathrm{.}99$ with $$1\mathrm{.}00$ increments on the total profits. What is the total profit if the labor costs are $$6\mathrm{.}50,$ and the price is $$14\mathrm{.}99?$

Note: Round your answers to $2$ decimal places.

Total profit

c$.$ What is the breakeven quantity using the assumptions in the spreadsheet model?

Note: Round your answer to $2$ decimal places.