Break Even Analysis
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Break Even Analysis as PDF for free.
More details
- Words: 390
- Pages: 5
Breakeven Analysis
Unit Contribution Margin
[Name]
Model Key Numbers in white cells are entered by user. Numbers in gray cells are calculated for you. These generally should not be altered.
Amounts shown in U.S. dollars
Sales Sales price per unit Sales volume per period (units) Total Sales
30.00 1,000 30,000.00 44.67%
Variable Costs
Variable costs per unit Unit contribution margin
55.33%
Commission per unit Direct material per unit PPC Serarch Engine Submissions Content Design Development CMS CRM SEO E-mail Marketing Shipping per unit Supplies per unit Other variable costs per unit Variable costs per unit Total Variable Costs
2.00 2.50 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.10 0.80 1.20 16.60
Unit contribution margin Gross Margin
13.40
16,600.00
Variable Costs Per Unit 13,400.00
Fixed Costs Per Period Administrative costs Hosting CRM CMS Development Design Insurance Property tax Rent Other fixed costs Total Fixed Costs per period
1200.00 100.00 100.00 100.00 100.00 100.00 500.00 150.00 800.00 750.00
Commission per unit Direct material per unit PPC 12.05%
15.06%
6.02% 6.02%
6.02%
3,900.00
Net Profit (Loss)
7.23% 4.82% 6.63%
6.02% 6.02%
9,500.00
6.02% 6.02% 6.02%
6.02%
Other variable costs per unit
Serarch Engine Submissions Content Design Development CMS CRM SEO E-mail Marketing Shipping per unit Supplies per unit
Results:
291
Breakeven Point (units): Sales volume analysis: Sales volume per period (units) Sales price per unit Fixed costs per period Variable costs
0
100
200
300
400
500
600
700
800
900
30.00
30.00
30.00
30.00
30.00
30.00
30.00
30.00
30.00
30.00
1,000 30.00
3,900.00
3,900.00
3,900.00
3,900.00
3,900.00
3,900.00
3,900.00
3,900.00
3,900.00
3,900.00
3,900.00
0.00
1,660.00
3,320.00
4,980.00
6,640.00
8,300.00
9,960.00
11,620.00
13,280.00
14,940.00
16,600.00
Total costs
3,900.00
5,560.00
7,220.00
8,880.00
10,540.00
12,200.00
13,860.00
15,520.00
17,180.00
18,840.00
20,500.00
Total sales
0.00
3,000.00
6,000.00
9,000.00
12,000.00
15,000.00
18,000.00
21,000.00
24,000.00
27,000.00
30,000.00
(3,900.00)
(2,560.00)
(1,220.00)
120.00
1,460.00
2,800.00
4,140.00
5,480.00
6,820.00
8,160.00
9,500.00
Net profit (loss)
Lower price
4 600
Page 2
Higher price
6 450
Page 3
Breakeven Analysis Chart 30,000.00 28,000.00 26,000.00 24,000.00 22,000.00 20,000.00 18,000.00
Dollars
16,000.00
12,000.00
Fixed costs per period Total costs Total sales
10,000.00
Net profit (loss)
14,000.00
8,000.00 6,000.00 4,000.00 2,000.00 0.00 (2,000.00) (4,000.00) Column Column Column Column Column Column Column Column Column Column Column D E F G H I J K L M N Sales Volume (Units)
ts per period s s
(loss)
Unit Contribution Margin
[Name]
Model Key Numbers in white cells are entered by user. Numbers in gray cells are calculated for you. These generally should not be altered.
Amounts shown in U.S. dollars
Sales Sales price per unit Sales volume per period (units) Total Sales
30.00 1,000 30,000.00 44.67%
Variable Costs
Variable costs per unit Unit contribution margin
55.33%
Commission per unit Direct material per unit PPC Serarch Engine Submissions Content Design Development CMS CRM SEO E-mail Marketing Shipping per unit Supplies per unit Other variable costs per unit Variable costs per unit Total Variable Costs
2.00 2.50 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.10 0.80 1.20 16.60
Unit contribution margin Gross Margin
13.40
16,600.00
Variable Costs Per Unit 13,400.00
Fixed Costs Per Period Administrative costs Hosting CRM CMS Development Design Insurance Property tax Rent Other fixed costs Total Fixed Costs per period
1200.00 100.00 100.00 100.00 100.00 100.00 500.00 150.00 800.00 750.00
Commission per unit Direct material per unit PPC 12.05%
15.06%
6.02% 6.02%
6.02%
3,900.00
Net Profit (Loss)
7.23% 4.82% 6.63%
6.02% 6.02%
9,500.00
6.02% 6.02% 6.02%
6.02%
Other variable costs per unit
Serarch Engine Submissions Content Design Development CMS CRM SEO E-mail Marketing Shipping per unit Supplies per unit
Results:
291
Breakeven Point (units): Sales volume analysis: Sales volume per period (units) Sales price per unit Fixed costs per period Variable costs
0
100
200
300
400
500
600
700
800
900
30.00
30.00
30.00
30.00
30.00
30.00
30.00
30.00
30.00
30.00
1,000 30.00
3,900.00
3,900.00
3,900.00
3,900.00
3,900.00
3,900.00
3,900.00
3,900.00
3,900.00
3,900.00
3,900.00
0.00
1,660.00
3,320.00
4,980.00
6,640.00
8,300.00
9,960.00
11,620.00
13,280.00
14,940.00
16,600.00
Total costs
3,900.00
5,560.00
7,220.00
8,880.00
10,540.00
12,200.00
13,860.00
15,520.00
17,180.00
18,840.00
20,500.00
Total sales
0.00
3,000.00
6,000.00
9,000.00
12,000.00
15,000.00
18,000.00
21,000.00
24,000.00
27,000.00
30,000.00
(3,900.00)
(2,560.00)
(1,220.00)
120.00
1,460.00
2,800.00
4,140.00
5,480.00
6,820.00
8,160.00
9,500.00
Net profit (loss)
Lower price
4 600
Page 2
Higher price
6 450
Page 3
Breakeven Analysis Chart 30,000.00 28,000.00 26,000.00 24,000.00 22,000.00 20,000.00 18,000.00
Dollars
16,000.00
12,000.00
Fixed costs per period Total costs Total sales
10,000.00
Net profit (loss)
14,000.00
8,000.00 6,000.00 4,000.00 2,000.00 0.00 (2,000.00) (4,000.00) Column Column Column Column Column Column Column Column Column Column Column D E F G H I J K L M N Sales Volume (Units)
ts per period s s
(loss)
Related Documents
Break Even Analysis
June 2020 9
Break Even Analysis
May 2020 16
Break Even Analysis
June 2020 9
Break Even Analysis
May 2020 10
Break Even Analysis
November 2019 17