Bean Counter
https://www.dwmbeancounter.com
How to use this template
This template uses sales values and costs
Template provides the option to assign fixed costs to products directly or
treat the fixed costs as unassigned. If you use the option to assign enter your fixed
costs in column B. Cells B64 thru B91.  If you chose to use the unassing option
enter your fixed costs in Column C Cell C91.
The spreadsheet will accommodate up to 6 products or categories
The burgundy cells are ones where you can enter relevant information.
Then, the calculations are automatically performed.
If you use the the option to asign fixed costs your results are displayed in Column B
If you use the unsassign option your results are displayed in Column C.
A Cost-Worksheet is also provided to aid you in calculating your costs
Break-EvenPercentage Contribution Margin Calculation for Single or Multiple Products
Sales Amounts
Sales Product #1
Sales Product #2
Sales Product #3
Sales Product #4
Sales Product #5
Sales Product #6
Total	$0
Product Mix Percentage
Product #1	0%
Product #2	0%
Product #3	0%
Product #4	0%
Product #5	0%
Product #6	0%
Variable Costs
Variable Costs of Product #1	$0
Variable Costs of Product #2	$0
Variable Costs of Product #3
Variable Costs of Product #4	$0
Variable Costs of Product #5	$0
Variable Costs of Product #6	$0
Contribution Margin
Contribution Margin Product #1	$0
Contribution Margin Product #2	$0
Contribution Margin Product #3	$0
Contribution Margin Product #4	$0
Contribution Margin Product #5	$0
Contribution Margin Product #6	$0
Contribution Ratio Product 1	0.00%
Contribution Ratio Product 2	0.00%
Contribution Ratio Product 3	0.00%
Contribution Ratio Product 4	0.00%
Contribution Ratio Product 5	0.00%
Contribution Ratio Product 6	0.00%
Fixed Costs
Direct Fixed Costs Product #1	$0
Direct Fixed Costs Product #2	$0
Direct Fixed Costs Product #3
Direct Fixed Costs Product #4
Direct Fixed Costs Product #5
Direct Fixed Costs Product #6
Total Direct Fixed Costs	$0
Total Fixed Costs To Allocate	$0
Allocated Fixed Costs Product #1	$0
Allocated Fixed Costs Product #2	$0
Allocated Fixed Costs Product #3	$0
Allocated Fixed Costs Product #4	$0
Allocated Fixed Costs Product #5	$0
Alocated Fixed Costs Product #6	$0
Total Allocated Fixed Costs	$0
Total Fixed Costs Product #1	$0
Total Fixed Costs Product #2	$0
Total Fixed Costs Product #3	$0
Total Fixed Costs Product #4	$0
Total Fixed Costs Product #5	$0
Total Fixed Costs Product #6	$0
		Unassigned
Total Fixed Costs	$0	$0
Weighted Contribtion Margin	0.00%
Sales Dollars
	Direct & Allocated	Weighted Average
	Fixed Costs	Contribution
Total Sales of Product #1 needed  per month to break even	$0	$0
Total Sales of Product #2 needed per month to break even	$0	$0
Total Sales of Product #3 needed per month to break even	$0	$0
Total Sales of Product #4 needed per month to break even	$0	$0
Total Sales of Product #5 needed per month to break even	$0	$0
Total Sales of Product #6 needed per month to break even	$0	$0
Total Sales needed per month to break even	$0	$0