$2\mathrm{.}7$ Create a one$-$way data table for profit at different

levels of supplier contract in range C$24$:C$35.$

a$.$ Ensure that the price in cell F$3)$ is $$420$ and the

advertising budget in cell F$5$ is $$45000000($you may

need to manually adjust these values$).$

b$.$ Use the values in range

as the different levels

of the supplier contract.

c$.$ Reference the profit calculation in cell

d$.$ Notice the Supplier Contract and Profitability chart

updates with the values in the data table to visually

demonstrate the relationship between supplier contract

amounts and the profitability.

$2\mathrm{.}8$ Consider the one$-$way data table. What is the

$2\mathrm{.}9$ Create a two$-$way data table for profit at different