An asterisk (*) will appear to the right of an incorrect entry.
1.
Sales
Cost of goods sold:
Direct materials
Direct labor
Factory overhead
Gross profit
Expenses:
Selling expenses
Sales salaries and commissions
Miscellaneous selling expense
Office and officers’ salaries
Supplies
Miscellaneous administrative expense
Total administrative expenses
Total expenses
Operating income
2.
Contribution margin ratio:
Sales
Contribution margin
Sales
Contribution margin ratio
3.
Break-even sales:
Fixed costs
Unit contribution margin
Break-even sales (units)
Sale price
Break-even sales (dollars)
4. For each unit level of sales, enter the total sales dollars and total costs. The chart at right will be plotted as you enter the amounts.
After all points are plotted, grab and move the labels provided at the left to identify each area.
0
2,000
4,000
6,000
8,000
10,000
12,000
14,000
16,000
18,000
Units Unit Variable Cost
Sale Price – Unit Variable Cost
Estimated Income Statement
For the Year Ended December 31, 20Y7
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
$-
$0
$0
$1
$1
$1
$1
0 2,000 4,000 6,000 8,000 10,000 12,000 14,000 16,000 18,000
Sales and Costs
Units
Cost-Volume-Profit Chart
Sales $
Costs $