Return to the VariableCosts table and fill out all of the costs related to your product. The more accurate you are here, the more accurate your BEP calculation will be. Each cost in the VariableCosts table should be per unit sold. Enter these costs into your Fixed Costs table. These are the costs of running your business, and should all be set to the same interval (for example, monthly costs). In the BEP sheet, enter an initial estimated price per unit. You'll be able to adjust this as you perform the calculations This is the number of units you intend to sell in the same timeframe as your Fixed Costs. For example, if your fixed costs includes monthly rent and insurance, the Units Sold will be the number of units sold in that same timeframe. The Units output cell (C11) will display the number of units that you'll need to sell in your timeframe to break even. This number will change depending on the Price Per Unit as well as your Variable Costs and Fixed Costs tables. Changing the Price Per Unit will change the number of units you need to break even. Try changing the price and see what happens with your BEP value.

Summary:
Enter your business's variable costs. Enter your business's fixed costs. Enter a price per unit. Enter the number of units you want to sell. Read the "Units" output. Make adjustments to the price and costs.