Create a one$-$way data table for profit at different levels of supplier contract in range B$22$:C$33.$

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

Use the values in range B$23$:B$33$ as the different levels of the supplier contract.

Reference the profit calculation in cell F$12.$

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.