An asterisk (*) will appear to the right of an incorrect entry.
1.
Sales
Cost of goods sold:
Direct materials
Direct labor
Gross profit
Expenses:
Selling expenses
Sales salaries and commissions
Miscellaneous selling expense
Office and officers’ salaries
Miscellaneous administrative expense
Total administrative expenses
Total expenses
Income from operations
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
3,000
6,000
9,000
12,000
15,000
18,000
21,000
24,000
27,000
Units Unit Variable Cost
Sale Price – Unit Variable Cost
Estimated Income Statement
For the Year Ended December 31, 2016
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 3,000 6,000 9,000 12,000 15,000 18,000 21,000 24,000 27,000
Sales and Costs
Units
Cost-Volume-Profit Chart
Sales $
Costs $