A

$8$

C

$0$

$E$

$F$

G

$H$

$1$

Bishop Company has provided the estimated data that appear in rows $7$ to $11$ of the following spreadsheet.

Required

Complete the spreadsheet to determine net income, break$-$even in units, and operating leverage for the estimates shown in the table below $($cells A$10$:B$14).$

Spreadsheet Tip

$($Ungraded$)$ You can explore the power of formulas by copying cells A$10$:B$26$ Into the scratchpad area $8$ below. There you can explore how changes to the given information are automatically reflected in the calculation of net income, break$-$even, and operating leverage.

$\backslash$table$[[9],[10,$Bishop Company Forecast for December, Year $2],[11,$Selling price per unit,$$18\mathrm{.}00$