Excel 4 - 12,450,000 350,000 Material Cost per Unit $4.00...

Info icon This preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Celine's Scooter Supply Ltd. Break-Even Quarterly Income Statement Analysis Revenue Units Revenue Expenses Income Units Sold 625,000 $13,125,000 $12,775,000 $350,000 Price per Unit $21.00 400,000 8,400,000 9,850,000 350,000 Total Revenue $13,125,000 425,000 8,925,000 10,175,000 350,000 Fixed Expenses 450,000 9,450,000 10,500,000 350,000 Administrative $2,250,000 475,000 9,975,000 10,825,000 350,000 Leasing 800,000 500,000 10,500,000 11,150,000 350,000 Marketing 500,000 525,000 11,025,000 11,475,000 350,000 Salary and Benefits 1,100,000 550,000 11,550,000 11,800,000 350,000 Total Fixed Expenses $4,650,000 575,000 12,075,000 12,125,000 350,000 Variable Expenses 600,000 12,600,000
Image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 12,450,000 350,000 Material Cost per Unit $4.00 625,000 13,125,000 12,775,000 350,000 Total Material Cost $2,500,000 650,000 13,650,000 13,100,000 350,000 Manufacturing Cost per Unit $9.00 675,000 14,175,000 13,425,000 350,000 Total Manufacturing Cost $5,625,000 700,000 14,700,000 13,750,000 350,000 Total Variable Expenses $8,125,000 725,000 15,225,000 14,075,000 350,000 Summary 750,000 15,750,000 14,400,000 350,000 Total Expenses $12,775,000 775,000 16,275,000 14,725,000 350,000 Operating Income $350,000 800,000 16,800,000 15,050,000 350,000 Matthew Weiner CMPSC 203 In the lab 4 2/19/2007...
View Full Document

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern