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

Info iconThis 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
Background 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

Ask a homework question - tutors are online