Percentages should total to 100%
|
|
||||||||||||||
| Bean Counter | ||||||||||||||
| https://www.dwmbeancounter.com | ||||||||||||||
| How to use this template | ||||||||||||||
| The purple cells are ones where you can enter relevant information. | ||||||||||||||
| Then, the calculations are automatically performed. | ||||||||||||||
| The spreadsheet will accommodate up to 6 products or categories | ||||||||||||||
| Break-Even Calculation for Single or Multiple Products | ||||||||||||||
| Percentage Sales Amounts (Sales Mix) Percentages should total to 100% |
||||||||||||||
| Percentage of Total Sales represented by Product #1 | 0% | |||||||||||||
| Percentage of Total Sales represented by Product #2 | 0% | |||||||||||||
| Percentage of Total Sales represented by Product #3 | 0% | |||||||||||||
| Percentage of Total Sales represented by Product #4 | 0% | |||||||||||||
| Percentage of Total Sales represented by Product #5 | 0% | |||||||||||||
| Percentage of Total Sales represented by Product #6 | 0% | |||||||||||||
| Total | 0% | |||||||||||||
| Fixed Expenses for one month (Fixed Costs are allocated to products based on sales mix) | $0 | |||||||||||||
| Sale prices | ||||||||||||||
| Sale price of Product #1 | $0.00 | |||||||||||||
| Sale price of Product #2 | $0.00 | |||||||||||||
| Sale price of Product #3 | $0.00 | |||||||||||||
| Sale price of Product #4 | ||||||||||||||
| Sale price of Product #5 | ||||||||||||||
| Sale price of Product #6 | ||||||||||||||
| Variable Costs | ||||||||||||||
| Variable Costs of Product #1 | $0.00 | |||||||||||||
| Variable Costs of Product #2 | $0.00 | |||||||||||||
| Variable Costs of Product #3 | $0.00 | |||||||||||||
| Variable Costs of Product #4 | ||||||||||||||
| Variable Costs of Product #5 | ||||||||||||||
| Variable Costs of Product #6 | ||||||||||||||
| Contribution Margin | ||||||||||||||
| Contribution Margin Product #1 | $0.00 | |||||||||||||
| Contribution Margin Product #2 | $0.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 | |||||||||||||
| Weighted Contribtion Margin | $0.00 | |||||||||||||
| Number Of Products | ||||||||||||||
| Allocated | Weighted | |||||||||||||
| Fixed Costs | Contribution | |||||||||||||
| Total number of Product #1 needed to sell per month to break even | 0 | 0 | ||||||||||||
| Total number of Product #2 needed to sell per month to break even | 0 | 0 | ||||||||||||
| 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 | 0 | ||||||||||||
| Sales Dollars | ||||||||||||||
| Total Sales of Product #1 needed per month to break even | $0.00 | $0.00 | ||||||||||||
| Total Sales of Product #2 needed per month to break even | $0.00 | $0.00 | ||||||||||||
| Total Sales of Product #3 needed per month to break even | $0.00 | $0.00 | ||||||||||||
| Total Sales of Product #4 needed per month to break even | $0.00 | $0.00 | ||||||||||||
| Total Sales of Product #5 needed per month to break even | $0.00 | $0.00 | ||||||||||||
| Total Sales of Product #6 needed per month to break even | $0.00 | $0.00 | ||||||||||||
| Total Sales needed per month to break even | $0.00 | $0.00 | ||||||||||||