$1$ Create a one$-$way data table or profit at different levels of supplier ontract in range $B22$:$C33.$

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

b$.$ Use the values in range $B23$:$B33$ as the different levels of the supplier contract.

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

d$.$ Notrice 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.