EX $8-2$c Finding the Break$-$Even Point with What$-$If Analysis

What$-$if analysis lets you explore the impact of changing different values in a worksheet. You can use such an analysis to explore the impact of changing financial conditions on a company's profitability. Roy wants to know what the impact would be if the number of Athena I bicycles the company produces and sells rises to $4,000$ or falls to $2,000.$

To perform what$-$if analysis for difierent sales volumes:

$1.$

In cell B$5,$ enter $4000$ to change the units produced and sold value. Increasing the sa volume to $4,000$ units, the net income of the company shown in cell B$27$ increases to $$643,500.$