|
Break Even
Template
|
|
Company Name: |
|
|
|
|
|
|
|
BREAKEVEN POINT CALCULATION |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
STEP 1: Determine total overhead costs. |
|
|
|
|
|
Rent |
0.00 |
|
|
|
|
|
|
Electricity |
0.00 |
|
|
|
|
|
|
Telephone |
0.00 |
|
|
|
|
|
|
Water /Sewer |
0.00 |
|
|
|
|
|
|
Advertising |
0.00 |
|
|
|
|
|
|
Salaries |
0.00 |
|
|
|
|
|
|
Owner's Draw |
0.00 |
|
|
|
|
|
|
Postage/Shipping |
0.00 |
|
|
|
|
|
|
Office Supplies |
0.00 |
|
|
|
|
|
|
Loan Payment |
0.00 |
|
|
|
|
|
|
Insurance |
0.00 |
|
|
|
|
|
|
Miscellaneous |
0.00 |
|
|
|
|
|
|
Other |
0.00 |
|
|
|
|
|
|
Total Overhead |
$0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
STEP 2: Determine average profit margin for products/services. |
|
|
|
|
% of |
Sales |
|
|
Profit |
Weighted |
|
Products/Services |
Sales |
Price |
COGS |
Contribution |
Margin |
Profit Marg. |
|
|
0% |
0.00 |
0.00 |
0.00 |
0.00% |
0.00% |
|
|
0% |
0.00 |
0.00 |
0.00 |
0.00% |
0.00% |
|
|
0% |
0.00 |
0.00 |
0.00 |
0.00% |
0.00% |
|
|
0% |
0.00 |
0.00 |
0.00 |
0.00% |
0.00% |
|
|
0% |
0.00 |
0.00 |
0.00 |
0.00% |
0.00% |
|
|
|
|
|
|
|
|
|
(Must equal 100%) |
0% |
|
Average profit margin: |
|
0.00% |
|
|
|
|
Average sales per customer: |
$0.00 |
|
|
|
|
|
|
|
|
|
STEP 3: Determine monthly break-even in dollars. |
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Overhead |
$0.00 |
|
|
|
|
divided by |
Average Profit Margin |
0.00% |
|
|
|
|
|
= BREAKEVEN |
$0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
STEP 4: Determine break-even point by week, day, hour, and unit. |
|
|
|
Avg Sales per Customer |
$0.00 |
|
|
|
|
|
|
Days Open Per Week |
5 |
|
|
|
|
|
|
Hours Open Per Day |
8 |
|
|
|
|
|
|
BREAKEVEN |
|
Prod 1 |
Prod 2 |
Prod 3 |
Prod 4 |
Prod 5 |
|
Monthly In Dollars |
$0.00
|
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
|
In Units |
|
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
|
Weekly In Dollars |
$0.00
|
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
|
In Units |
|
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
|
Daily In Dollars |
$0.00
|
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
|
In Units |
|
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
|
Hourly In Dollars |
$0.00
|
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
|
In Units |
|
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
|

For more information:
info@ACORNetwork.com
|