Percentages should total to 100%
|
|
||||||||||||||
| Bean Counter | ||||||||||||||
| https://www.dwmbeancounter.com | ||||||||||||||
| How to use this template | ||||||||||||||
| This template uses unit prices and costs | ||||||||||||||
| I've also provided another template that use 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 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. | ||||||||||||||
| A Cost-Worksheet is also provided to aid you in calculating your costs | ||||||||||||||
| Finally a Break Even Graph is also included for this Unit Contribution Worksheet | ||||||||||||||
| 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 | ||||||||||||||
| Percentage of Total Sales represented by Product #2 | ||||||||||||||
| 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 | 0% | |||||||||||||
| Fixed Costs | Assigned To Products | Unassigned | ||||||||||||
| Direct Fixed Costs | ||||||||||||||
| Allocated Fixed Costs | ||||||||||||||
| Total Fixed Costs | $0 | |||||||||||||
| Sale prices | ||||||||||||||
| Sale price of Product #1 | ||||||||||||||
| Sale price of Product #2 | ||||||||||||||
| 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 | ||||||||||||||
| Variable Costs of Product #2 | ||||||||||||||
| 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 | $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 | |||||||||||||
| 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 | $0.00 | |||||||||||||
| Weighted Sales Price | $0.00 | |||||||||||||
| Weighted Variable Costs | $0.00 | |||||||||||||
| Number Of Products | ||||||||||||||
| Direct & 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 | ||||||||||||||
| Direct & Allocated | Weighted | |||||||||||||
| 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 | ||||||||||||