follows:

a$.$ In cell D$5,$ enter a formula without using a function that references cell BA

is the expected hours of management consulting contracted.

b$.$ In cell E$5,$ enter a formula without using a function that references cell B$19,$

is the expected total sales for management consulting.

c$.$ In cell $F5,$ enter a formula without using a function that references cell $B20,$ which

is the expected total expenses for this product.

d$.$ In cell G$5,$ enter a formula without using a function that references cell B$21,$ which

is the expected gross profit for this product.

e$.$ Select the range $D5$:$G10$ and then complete the one$-$variable data table, using cell

B$4$ as the Column input cell for your data table.

Create a two$-$variable data table to calculate the gross profit based on the hours of

management consulting contracted and the hourly rate charged:

a$.$ For the range D$14$:K$19,$ create a two$-$variable data table using the hourly rate

charged $($cell B$5)$ as the Row input cell.

b$.$ Use the hours of management consulting contracted $($cell B$4)$ as the Column input

cell.

c$.$ Apply a custom format to cell D$14$ to display the text Hours$/$Price in place of the

cell value.

Switch to the Change worksheet. Create a Scatter with Straight Lines chart based on the

range D$4$:F$14$ in the data table Organizational Change $-$ Break$-$Even Analysis.

Modify the new chart as follows:

a$.$ Resize and reposition the chart so that it covers the range D$15$:H$32.$

b$.$ Remove the chart title from the chart.

Add Sales and Expenses as the vertical axis title and Hours Contracted as the