Celine's Scooter Supply Ltd. Quarterly Income Statement Units Sold Price per Unit Total Revenue Administrative Leasing Marketing Salary and Benefits Total Fixed Expenses Material Cost per Unit Total Material Cost Manufacturing Cost per Unit Total Manufacturing Cost Total Variable Expenses Total Expenses Operating Income Revenue Fixed Expenses Variable Expenses Summary 875,000.00 $22.50 $19,687,500.00 $2,250,000.00 800,000.00 500,000.00 1,100,000.00 $4,650,000.00 $3.25 $2,843,750.00 $4.75 $4,156,250.00 $7,000,000.00 $11,650,000.00 $12,687,500.00 Break-Even Analysis Units Total Revenue Total Expenses Operating Income 19,687,500.00 11,650,000.00 12,687,500.00 250,000 275,000 300,000 325,000 350,000 375,000 400,000 425,000 450,000 475,000 500,000 525.000 550,000 575,000 600,000 625,000 650,000 Enter the contact formula in colls F4, NGA and H4 Thon, use the function Data Table (not the formula) we learn in chapter 4 to denive the Total Revenue, Total Expense, and Operating Income for different amount of units sold. 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. Celine's Scooter Supply Ltd. Quarterly Income Statement Units Sold Price per Unit Total Revenue Administrative Leasing Marketing Salary and Benefits Total Fixed Expenses Material Cost per Unit Total Material Cost Manufacturing Cost per Unit Total Manufacturing Cost Total Variable Expenses Total Expenses Operating Income Revenue Fixed Expenses Variable Expenses Summary 875,000.00 $22.50 $19,687,500.00 $2,250,000.00 800,000.00 500,000.00 1,100,000.00 $4,650,000.00 $3.25 $2,843,750.00 $4.75 $4,156,250.00 $7,000,000.00 $11,650,000.00 $12,687,500.00 Break-Even Analysis Units Total Revenue Total Expenses Operating Income 19,687,500.00 11,650,000.00 12,687,500.00 250,000 275,000 300,000 325,000 350,000 375,000 400,000 425,000 450,000 475,000 500,000 525.000 550,000 575,000 600,000 625,000 650,000 Enter the contact formula in colls F4, NGA and H4 Thon, use the function Data Table (not the formula) we learn in chapter 4 to denive the Total Revenue, Total Expense, and Operating Income for different amount of units sold. 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
