Bean Counter
https://www.dwmbeancounter.com
How to use this template
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 B28 and B29 thru B If you chose to use the unassing option 
enter your fixed costs in Column C Cell C27.
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.
Break-Even Unit Contribution Calculation for Single or Multiple Products
Percentage Sales Amounts (Sales Mix)
Percentages should total to 100%
Percentage of Total Sales represented by Product #1 60%
Percentage of Total Sales represented by Product #2 40%
Percentage of Total Sales represented by Product #3  
Percentage of Total Sales represented by Product #4  
Percentage of Total Sales represented by Product #5  
Percentage of Total Sales represented by Product #6  
Total 100%
   
Fixed Costs                                             Assigned To Products Unassigned
Direct Fixed Costs  
Allocated Fixed Costs  
Total Fixed Costs $0 $220,000
   
Sale prices
Sale price of Product #1 $150.00
Sale price of Product #2 $200.00
Sale price of Product #3  
Sale price of Product #4    
Sale price of Product #5  
Sale price of Product #6  
   
Variable Costs  
Variable Costs of Product #1 $70.00
Variable Costs of Product #2 $90.00
Variable Costs of Product #3  
Variable Costs of Product #4  
Variable Costs of Product #5  
Variable Costs of Product #6  
   
Contribution Margin
Contribution Margin Product #1 $80.00
Contribution Margin Product #2 $110.00
Contribution Margin Product #3 $0.00
Contribution Margin Product #4 $0.00
Contribution Margin Product #5 $0.00
Contribution Margin Product #6 $0.00
 
Fixed Costs
Direct Fixed Costs Product #1  
Direct Fixed Costs Product #2  
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
   
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 $0
   
Weighted Contribtion Margin $92.00
Weighted Sales Price $170.00
Weighted Variable Costs $78.00
     
Number Of Products    
  Direct & Allocated Weighted
  Fixed Costs Contribution
Total number of Product #1 needed to sell per month to break even 0 1,435
Total number of Product #2 needed to sell per month to break even 0 957
Total number of Product #3 needed to sell per month to break even 0 0
Total number of Product #4 needed to sell per month to break even 0 0
Total number of Product #5 needed to sell per month to break even 0 0
Total number of Product #6 needed to sell per month to break even 0 0
Total number of Products needed to sell per month to break even 0 2,391
     
Sales Dollars    
  Direct & Allocated Weighted
  Fixed Costs Contribution
Total Sales of Product #1 needed  per month to break even $0 $215,250
Total Sales of Product #2 needed per month to break even $0 $191,400
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 $406,650