Create a one-way data table using the values in cells b32: b43 after referencing total profit (calculated in cell f12) to determine the supplier contract amount that leads to the most profit given that price is $290 and advertising budget is $35,000,000. enter this contract amount in cell c 45. 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 profitability