Breakeven Note: For the formulas pass Cell Pointer over Total Sales, etc. for the Note to Show (Red Corner Triangle). In CELLS D19 and D20 (GREEN CELLS), Key in the formulas, using Relative or Absolute Cell References, for Total Variable Costs & Total Costs. Then drag the formulas to the adjacent YELLOW cells. Total Sales and Profit/Loss are already calculated. Fixed Costs $50,000 Variable Cost per Unit $15.00 Selling Price per Unit $30.00 Units Sold 10,000 12,000 14,000 16,000 18,000 20,000 Total Sales Total Variable Costs 300,000 $0 $360,000 $ 420,000 $ $0 $0 480,000 $ $0 540,000 $ $0 600,000 $0 Total Costs $0 $0 $0 $0 $0 $0 Profit (Loss) $300,000 $360,000 $420,000 $480,000 $540,000 $600,000 Note: For the formulas See Below or run Cell Pointer over Total Sales, etc. for the Note to Show (Red Corner Triangl Total Variable Cost = Unis Sold * Variable Cost Per Unit Total Cost = Total Variable Cost + Fixed Cost