A B C D E F G H J K L Celine's Scooter Supply Ltd. Break-Even 2 Quarterly Income Statement Analysis 3 Revenue Units Total Revenue Total Expenses | Operating Income Units Sold 875,000.00 19687500.00 Price per Unit $22.50 250,000 5625000.00 6 Total Revenue $19,687,500.00 275,000 Fixed Expenses 300,000 Administrative $2,250,000.00 325,000 co Leasing 800,000.00 350,000 10 Marketing 600,000.00 375,000 Enter the correct formula in cells F4, 11 Salary and Benefits 1,100,000.00 400,000 G4, and H4. Then, use the 12 Total Fixed Expenses $4,650,000.00 425,000 function Data Table (not the 13 Variable Expenses 450,000 formula) we learn in chapter 4 to derive the Total Revenue, Total 14 Material Cost per Unit $3.25 475,000 Expense, and Operating Income for 15 Total Material Cost $2,843,750.00 500,000 different amount of units sold. 16 Manufacturing Cost per Unit $4.75 525,000 17 Total Manufacturing Cost $4,156,250.00 550,000 18 Total Variable Expenses $7,000,000.00 575,000 19 Summary 600,000 20 Total Expenses $11,650,000.00 625,000 21 Operating Income $8,037,500.00 650,000 22 23 Name: HIIII 24 Instructions: 25 1. Use the formulas to calculate the following: 26 Total Revenue = Units Sold * Price per Unit 27 Total Fixed Expenses = sum all fixed expenses 28 Total Material Cost = Units Sold * Material Cost per Unit 29 Total Manufacturing Cost = Units sold * Manufacturing Cost per Unit 30 Total Variable Expenses =Total Material Cost + Total Manufacturing Cost 31 Total Expenses =Total Fixed Expense + Total Variable Expense 32 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 33 sold