PLEASE DO THE BREAK EVEN ANALYSIS

Celine's Scooter Supply Ltd. Quarterly Income Statement \begin{tabular}{|l|l|r|} \hline Revenue & & 875,000.00 \\ \hline & Units Sold & $22.50 \\ \hline & Price per Unit & \\ \hline & Total Revenue & $19,687,500.00 \\ \hline Fixed Expenses & $2,250,000.00 \\ \hline & Administrative & 800,00000 \\ \hline & Leasing & 500,000.00 \\ \hline & Marketing & 1,100,000.00 \\ \hline & Salary and Benefits \\ \hline & Total Fixed Expenses & $4,650,000.00 \\ \hline & & $33.25 \\ \hline Variable Expenses & $8.00 \\ \hline & Material Cost per Unit & $4.75 \\ \hline & Total Material Cost & \\ \hline & Manufacturing Cost per Unit & \\ \hline & Total Manufacturing Cost & \\ \hline & Total Variable Expenses & \\ \hline Summary & & \\ \hline & Total Expenses & \\ \hline & Operating Income & \\ \hline \end{tabular} Name: Banks-EdmondsonDanielle \|\|\|\| Instructions: 1. Use the formulas to calculate the following: Total Revenue = Units Sold Price per Unit Total Fixed Expenses = sum all fixed expenses Total Material Cost = Units Sold Material Cost per Unit Total Manufacturing Cost = Units sold Manufacturing Cost per Unit Total Variable Expenses = Total Material Cost + Total Manufacturing Cost Total Expenses = Total Fixed Expense + Total Variable Expense Operating Income = Total Revenue Total Expenses 2. Use the function Data Table to derive the Total Revenue, Total Expense, and Operating Income for different amount of units sold. per Unit acturing Cost nse Expense, and Operating Income for different amount of units