can someone PLEASE show me how to do this step by step on making a one way data table for this? along with flling out the gray area + formulas? no one has answered within 2 days now.

Assignment Tasks Pricing, Advertisingi and Prepaid Contracts Create a one-way data table using the values in cells B32:843 after referencing total profit (calculated in cell F 12) 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 CAS. 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 profitablity. [ 10 points]