Breakeven Analysis
(your company name)
Contribution Margin
1
Enter sale price per unit
Sale price per unit
2
Enter variable costs description
and per unit cost
note: Data entry is required
in a minimum of one row
$
Variable costs per unit
materials
labor
supplies
xxxxx
xxxxx
Total Variable Costs
300.00
100%
60.00
50.00
20.00
Contribution margin per unit
$
130.00
43%
170.00
57%
Contribution margin percentage
Fixed Costs
Enter fixed cost
description and annual cost
equip
$
sal
taxes
adv
rent
xxxxx
xxxxx
xxxxx
xxxxx
xxxxx
Total Fixed Costs
3
note: Data entry is required
in a minimum of one row
Profit Component
2,400
24,000
4,800
1,200
6,000
Data entry required
$
38,400
$
10,000
4
Enter profit before income tax
Profit before income tax
Data entry optional
Breakeven Analysis Formula
Sales needed to cover
fixed expenses + profit component
Fixed costs +
Profit BFIT
Contribution margin
Required Sales Volume
Proof
Sales per
Month
Sales per
Week
Sales per
Day
=
=
=
=
Income Statement
Sales in units
Sale price per unit
$
Total sales
Sales in units
Variable cost per unit
$
Total Variable costs
Contribution margin/Gross Profit
Fixed expenses
Profit before income tax
285
300.00
$
85,412
285
130.00
37,012
$
48,400
38,400
$
10,000
Breakeven Point
Units
Dollars
285
$
85,412
24
$
7,118
5
1,643
1
234

Purchase answer to see full
attachment