BreakEven sheet tab.

Review break$-$even formulas and

build the data source for a line

chart.

a$.$

Select cell B$8.$ The margin

per unit is calculated by

subtracting the variable cost

from the sales price.

b$.$

Select cell B$10.$ The formula

divides the fixed cost by the

sales price minus the variable

cost $($margin per unit$).$ The

results are rounded to show

no decimal places.

c$.$

Review the references and

formulas in row $15.$ Build a

table for the chart by copying

Figure $3-84$ Dragging the resize pointer

the formulas in row $15$ to the

blank rows below it up to and

including row $24.$

d$.$

Select cell B$5$ and type $200.$ Verify that at this price, the break$-$even point is $200$ units. This is the level at

which the profit covers all costs.

Create a line chart.

a$.$

Select cells B$14$:C$24$ and E$14$:F$24.$

b$.$

Create a $2-$D Line chart with markers for each line.

Guide me step by step in excel For project