Excel Lab 9

\begin{tabular}{|l|rr|} \hline Units sold & & 120 \\ \hline Total variable costs for above units & S & 2,500.00 \\ \hline Total fixed costs & S & 4,500.00 \\ \hline Per unit sell price & S & 107.00 \\ \hline \end{tabular} Determine using Formulas only: \begin{tabular}{|l|l|} \hline Variable cost per unit & \\ \hline Total costs & \\ \hline Operating profit (EBITA) & \\ \hline Revenue per unit & \\ \hline Gross Profit per unit & \\ \hline Break Even (Units) & \\ \hline Break Even Sales (dollars) & \\ \hline Gross Margin per Unit & \\ \hline \end{tabular} Don't forget to use roundup for Break Even Units 8 Marks Cover Breakeven 1 Breakeven 2 Breakeven 3 Breakeven 4 \begin{tabular}{|l|r|} \hline Units sold & 325 \\ \hline Revenue & $5.00 \\ \hline Variable cost per unit & $1.75 \\ \hline Total fixed costs & $990.00 \\ \hline Target Profit (EBITA) & $250.00 \\ \hline \end{tabular} Determine using Formulas only: \begin{tabular}{|l|l|} \hline Total revenue & \\ \hline Total variable costs & \\ \hline Total costs & \\ \hline Operating income (EBITA) & \\ \hline Gross Profit per Unit & \\ \hline Break Even (Units) & \\ \hline Break Even Sales (dollars) & \\ \hline Gross Margin per Unit & \\ \hline Units required to reach EBITA target & \\ \hline \end{tabular} Don't forget to use roundup for Units 9 Marks Cover Breakeven 1 Breakeven 2 Breakeven 3 Breakeven 4 \begin{tabular}{|l|r|} \hline Sell Price per unit & $1.60 \\ \hline Variable cost per unit & $0.80 \\ \hline Total fixed costs for the month & $1,600.00 \\ \hline Desired Profit (EBITA) for the Month (minimum) & $1,100.00 \\ \hline What if this many units sold: & 3,650 \\ \hline \end{tabular} Determine using Formulas only: \begin{tabular}{|l|l|} \hline Gross Profit per Unit & \\ \hline Break Even units & \\ \hline Sales in Dollars at Break Even Units & \\ \hline Operating profit (EBITA) at break-even point & \\ \hline Operating Profit (EBITA) at "What if" units sold & \\ \hline Units required for target EBITA & \\ \hline Sales (Dollars) at target EBITA & \\ \hline \end{tabular} Don't forget to use roundup for Units 7 Marks Cover Breakeven 1 Breakeven 2 Breakeven 3 Breakeven 4 Fixed costs (per day) \begin{tabular}{|l|r|r|} \hline Location rent & & $25.00 \\ \hline Coffee Wagon maintenance & & $1.50 \\ \hline Total daily fixed costs & & \\ \hline \end{tabular} Variable costs per unit Don't forget to use roundup for Units 9 Marks Cover Breakeven 1 Broakeven 2 Broakeven 3 Breakeven 4