$8\mathrm{.}1$ Create a one$-$way data table for profit at different levels of supplier contract in range

a$.$ Ensure that the price in cell is $$290$ and the advertising budget in cell C$5$ is $$35,000,000($you may need to manually adjust these values$).$

b$.$ Use the values in rapge as the different levels of the supplier contract.

c$.$ Reference the profit calculation in cell $($F$12).$

d$.$ Notice the Supplier Contract and Profitability chart updates with the values in the data table to visually demonstrate