Break-even.xlsx
Sheet1
| No. of Units | Allocated Fixed Costs | Variable Cost/Unit | Total Production | Average Unit Cost | Unit Price | Total Sales Revenue | Gross Profit |
| | | | Cost |
| 500 | $ 10,000 | $ 10 |
| 1,000 | $ 10,000 | $ 10 |
| 1,500 | $ 10,000 | $ 10 |
| 2,000 | $ 10,000 | $ 10 |
| 2,500 | $ 10,000 | $ 10 |