This is the amount by which your profits are impacted by each cremation call you gain or lose
This is the number of calls you are over or short of the recommended minimum volume level
This is the amount by which your profits are impacted by each burial call you gain or lose
This is the minimum number of calls over your personal break even volume we recommend
This is the incremental margin for each call. It includes both burial and cremation
This is the total number of calls over or under your minimum breakeven calls
This is your average sale for cremation of all types. It excludes miscellaneous services.
This is your average sale for cremation of all types. It excludes miscellaneous services.
This is the minimum revenue you need to produce in order to reach $0 profitability
This is your average sale for those services that involve burial it excludes misc. services and cremation
This is the minimum number of services of all types you need to perform to reach $0 profitability
This your average sale for your total call volume
is this approximately what you expected? If not go back and change some of your guesses
enter the your total fixed overhead costs
alan creedy: These are standard ratios for typical funeral homes.
Enter what you consider regular adult burials.
Enter what you consider regular adult burials.
Enter what you consider regular adult burials.
Enter what you consider regular adult burials.
Enter what you consider regular adult burials.
Enter what you consider regular adult burials.
Enter what you consider regular adult burials.
Enter what you consider regular adult burials.
Enter what you consider regular adult burials.
Enter what you consider regular adult burials.
Enter what you consider regular adult burials.
Enter what you consider regular adult burials.
Enter what you consider regular adult burials.
Please fill all required fields
input sheet
results
Narrative
Free Breakeven Calculator
Step 1 Call Mix & Average Sale
How To Use This Calculator
Your Call Mix:
This is a simple way to calculate your break even in two ways: # of calls and $ in revenue. I recommend you start by entering your best guesses. The results will tell you if you are close. You can play some
"what / if"
games by changing the input on this sheet. For instance: What if you increased your burial prices by 5%? Try it and see what happens. Have fun! After you have learned how it works you can get serious by inputting actual data from your financial statements.
Burials
Cremations
Misc. Calls
Total Calls
Your Sales Averages:
Avg. Burial Sale
Avg. Cremation Sale
Miscellaneous Revenue
Step 2 Average Wholesale Cost
Step 4 Mdse Volume
Your Wholesale averages
Your Units Sold
Avg. Casket Cost
Caskets Sold
Avg. Vault Cost
Vaults Sold
Avg. Cremation Mdse
Cremation Mdse Sold
xxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxx
Step 3
Other Wholesale costs
Your Cost of Sales
Casket Wholesale
Other Wholesale Costs
Vault Wholesale
Urn Wholesale
Aggregate Miscellaneous Cost
Miscellaneous Cost
Step 5 Operating Ratios
Your P & L
Your Ratios
Standard Ratios
Total Revenue
100.00%
Cost of Sales
15-20%
Gross Margin
75-80%
Total Fixed Overhead
70+%
Net Profit /
(
Loss)
5+%
alancreedy.org • All Rights Reserved 2011
Free Breakeven Calculator
Key Results
Your Averages
Your Breakeven
Averages:
Avg. Sale
Calls Needed to Breakeven:
Avg. Burial Sale
Revenue Needed to Breakeven:
Avg. Cremation Sale
Your Margin of Safety
Your Cremation Rate
Your Current Call Volume:
Calls
Incremental Unit C
ontribution:
Your Current Margin of Safety:
Calls
Avg. Unit Margin
Your Margin of Safety Should Be:
Calls
Burial Margin
Your Margin of Safety Is:
Calls
Cremation Margin
xxxxxxxxxxxxx
xxxxxxxxxxxxxxxx
Disclaimer:
This tool is not intended to replace a thoroughly detailed analysis. It is for your use as a quick and easy way to assess your situation and try a few different scenarios. Certain items are not included which could materially affect results. These include things like conversions from guaranteed preneed contracts, certain competitive factors, revenue or expense from unrelated enterprises and payment to non contributing family members. Click on the button below to learn more.
alancreedy.org • All Rights Reserved 2011
Free Breakeven Calculator
Narrative
Results
AlanCreedy.org for specific recommendations on how to maximize your business performance.
Disclaimer:
This tool is not intended to replace a thoroughly detailed analysis. It is for your use as a quick and easy way to assess your situation and try a few different scenarios. Certain items are not included which could materially affect results. These include things like conversions from guaranteed preneed contracts, certain competitive factors, revenue or expense from unrelated enterprises and payment to non contributing family members. Click on the button below to learn more.
alancreedy.org • All Rights Reserved 2011
The browser does not support JavaScript. The calculations created using
SpreadsheetConverter
will not work. Please access the web page using another browser.