{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

student_name_Excel_Chapter4

# student_name_Excel_Chapter4 - 234,606.00 Material Cost per...

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

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
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

{[ snackBarMessage ]}