business P
xinbolu66
Breakeventemplate0421.xlsBr Even Template
| Breakeven Analysis | |||||||||
| Life | |||||||||
| Contribution Margin | |||||||||
| Enter sale price per unit | Sale price per unit | $ 260.00 | 100% | ||||||
| Variable costs per unit | |||||||||
| labor | 10.00 | ||||||||
| metrial | 20.00 | ||||||||
| Enter variable costs description | transport | 5.00 | |||||||
| and per unit cost | |||||||||
| note: Data entry is required | Total Variable Costs | 35.00 | 13% | ||||||
| in a minimum of one row | |||||||||
| Contribution margin per unit | $ 225.00 | 87% | Contribution margin percentage | ||||||
| Fixed Costs | |||||||||
| rent | $ 5,000 | ||||||||
| salaries | 6,000 | ||||||||
| advertising | 3,000 | Data entry required | |||||||
| Enter fixed cost | |||||||||
| description and annual cost | |||||||||
| note: Data entry is required | |||||||||
| in a minimum of one row | |||||||||
| Total Fixed Costs | $ 14,000 | ||||||||
| Profit Component | |||||||||
| Enter profit before income tax | Profit before income tax | $ 20,000 | Data entry optional | ||||||
| Breakeven Analysis Formula | |||||||||
| Breakeven Point | |||||||||
| Sales needed to cover | Fixed costs + | Profit BFIT | = | Units | Dollars | ||||
| fixed expenses + profit component | Contribution margin | 151 | $ 39,289 | ||||||
| Required Sales Volume | Sales per | Month | = | 13 | $ 3,274 | ||||
| Sales per | Week | = | 3 | 756 | |||||
| Sales per | Day | = | 0 | 108 | |||||
| Proof | Income Statement | ||||||||
| Sales in units | 151 | ||||||||
| Sale price per unit | $ 260.00 | ||||||||
| Total sales | $ 39,289 | ||||||||
| Sales in units | 151 | ||||||||
| Variable cost per unit | $ 35.00 | ||||||||
| Total Variable costs | 5,289 | ||||||||
| Contribution margin/Gross Profit | $ 34,000 | ||||||||
| Fixed expenses | 14,000 | ||||||||
| Profit before income tax | $ 20,000 |
1
2
3
4
Ques 7
Ques 9
| Breakeven Analysis | |||||||||
| (your company name) | |||||||||
| Contribution Margin | |||||||||
| Enter sale price per unit (1) | Sale price per unit | 0% | |||||||
| Variable costs per unit | |||||||||
| Description | Unit cost | ||||||||
| xxxxx | |||||||||
| xxxxx | |||||||||
| Enter variable costs description | xxxxx | ||||||||
| and per unit cost (2) | xxxxx | ||||||||
| xxxxx | |||||||||
| note: Data entry is required | Total Variable Costs | - 0 | 0% | ||||||
| in a minimum of one row | |||||||||
| Contribution margin per unit | $ - 0 | 0% | Contribution margin percentage | ||||||
| Fixed Costs | |||||||||
| Fixed Costs | Description | Annual Cost | |||||||
| xxxxx | |||||||||
| xxxxx | |||||||||
| xxxxx | Data entry required | ||||||||
| Enter fixed cost | xxxxx | ||||||||
| description and annual cost (3) | xxxxx | ||||||||
| xxxxx | |||||||||
| note: Data entry is required | xxxxx | ||||||||
| in a minimum of one row | xxxxx | ||||||||
| xxxxx | |||||||||
| xxxxx | |||||||||
| Total Fixed Costs | $ - 0 | ||||||||
| Profit Component | |||||||||
| Enter profit before income tax (4) | Profit before income tax | Data entry optional | |||||||
| Breakeven Analysis Formula | |||||||||
| Breakeven Point | |||||||||
| Sales needed to cover | Fixed costs + | Profit BFIT | = | Units | Dollars | ||||
| fixed expenses + profit component | Contribution margin | - 0 | $ - 0 | ||||||
| Required Sales Volume | Sales per | Month | = | - 0 | $ - 0 | ||||
| Sales per | Week | = | - 0 | - 0 | |||||
| Sales per | Day | = | - 0 | - 0 | |||||
| Proof | Income Statement | ||||||||
| Sales in units | - 0 | ||||||||
| Sale price per unit | $ - 0 | ||||||||
| Total sales | $ - 0 | ||||||||
| Sales in units | - 0 | ||||||||
| Variable cost per unit | $ - 0 | ||||||||
| Total Variable costs | - 0 | ||||||||
| Contribution margin/Gross Profit | $ - 0 | ||||||||
| Fixed expenses | - 0 | ||||||||
| Profit before income tax | $ - 0 |
Sheet3
| Question | Sale Price | B/E Point | B/E Point | B/E Point | Per Month |
| Profit | Dollars | Units | Units | ||
| 5 | $ 14.00 | $ - 0 | $ 84,172 | 6,012 | 501 |
| 6 | $ 14.00 | 40,000 | 152,883 | 10,920 | 910 |
| 7 | $ 10.50 | 20,000 | 155,806 | 14,839 | 1,237 |
| 8 | $ 11.71 | 10,000 | 42,161 | 3,600 | 300 |
Sheet2
| Breakeven Analysis | |||||||||
| Dan Carroll, CPA | |||||||||
| Department of Business Technology | |||||||||
| Miami University | |||||||||
| Contribution Margin | Data entry required * | ||||||||
| Sale price per unit | * | ||||||||
| Variable costs per unit | * | ||||||||
| Contribution margin per unit | calculate difference | ||||||||
| Fixed Costs | |||||||||
| Salary | * | ||||||||
| Other | * | ||||||||
| Total Fixed Costs | calculate total | ||||||||
| Profit Component | |||||||||
| Profit before income tax | * | ||||||||
| Breakeven Analysis Formula | |||||||||
| Sales in units needed to cover | Fixed costs + | Profit BFIT | = | Units | |||||
| fixed expenses + profit component | Contribution margin per unit | ||||||||
| calculate | |||||||||
| Income Statement | formula | ||||||||
| Sales in units | * | ||||||||
| Sale price per unit | * | ||||||||
| Total sales | calculate total | ||||||||
| Variable costs in units | * | ||||||||
| Variable cost per unit | * | ||||||||
| Total Variable costs | calculate total | ||||||||
| Contribution margin/Gross Profit | total sales-total cost of sales | ||||||||
| Fixed costs | * | ||||||||
| Profit before income tax | contrib margin-fixed expenses | ||||||||
| Required Sales Volume | |||||||||
| Sales in units per | Month | units/12 | |||||||
| Sales in units per | Week | units/52 | |||||||
| Sales in units per | Day | units/365 |
