student_name_Excel_Chapter4

student_name_Excel_Chapter4 - 234,606.00 Material Cost per...

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

View Full Document Right Arrow Icon
The Bean Bag Game Company Break-Even Quarterly Income Statement Analysis Revenue Units Sold 55,000 $1,320,000.00  $1,310,394.00   9,606.00  Price per Unit $24.00  40,000  960,000.00   1,085,394.00  (125,394.00) Total Revenue $1,320,000.00  45,000  1,080,000.00   1,160,394.00  (80,394.00) Fixed Expenses 50,000  1,200,000.00   1,235,394.00  (35,394.00) Administrative $131,394  55,000  1,320,000.00   1,310,394.00  9,606.00  Rent $52,000  60,000  1,440,000.00   1,385,394.00  54,606.00  Marketing $55,000  65,000  1,560,000.00   1,460,394.00  99,606.00  Salary and Benefits $247,000  70,000  1,680,000.00   1,535,394.00  144,606.00  Total Fixed Expenses $485,394  75,000  1,800,000.00   1,610,394.00  189,606.00  Variable Expenses 80,000  1,920,000.00   1,685,394.00 
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 234,606.00 Material Cost per Unit $8.00 85,000 2,040,000.00 1,760,394.00 279,606.00 Total Material Cost $440,000.00 90,000 2,160,000.00 1,835,394.00 324,606.00 Manufacturing Cost per Unit $7.00 95,000 2,280,000.00 1,910,394.00 369,606.00 Total Manufacturing Cost $385,000.00 100,000 2,400,000.00 1,985,394.00 414,606.00 Total Variable Expenses $825,000.00 105,000 2,520,000.00 2,060,394.00 459,606.00 Summary 110,000 2,640,000.00 2,135,394.00 504,606.00 Total Expenses $1,310,394.00 115,000 2,760,000.00 2,210,394.00 549,606.00 Operating Income $9,606.00 120,000 2,880,000.00 2,285,394.00 594,606.00...
View Full Document

Ask a homework question - tutors are online