header2

Create Breakeven Analysis

cba_ribbon

Use this function to find the breakeven point, where outputs reach "zero". Evidently, this depends on the input involved.

cba1

The following image shows the results obtained after applying the tool.
In this case, you can see what the Price per Unit should be for the Gross Profit to reach the breakeven point.

cba2

Alternatively, you can save this data analysis and rerun it from Run Multi Goal Seeker Analysis.