3.Create a one-way data table using the values in cells B32:B43 and 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 C45. 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.

For question 3, we are looking at the second picture. The cells B32:B43 the supplier contract and profitability chart. The referencing total profit I got is 197,786,074. I know I need to use the "What if Analyisis" - "Data Table" but am unsure of what goes in that column..

4.Create a two-way data table using the values in cells B49:B69 (Price) and C48:E48 (Advertising Budget) to analyze the relationships among advertising budget, price, and profitability. Complete the "Price, Advertising, and Profitability" chart to include series for advertising budgets $50,000,000 and $75,000,000 on your data table (notice that the series for $25,000,000 is already on the chart). Enter the advertising budget amount from your analysis that will produce the most profit E71. Enter the price that will product the most profit in cell E72.

Question 4 uses this chart right below. Cells B49:B69 and C48:E48 are listed below. Again I know to use "What if Analysis and Data Tables" but unsure of what actually goes in this chart. Any help would be greatly appreciated.

$25,000,000 $200 $210 $220 $230 $240 $250 $260 $270 $280 $290 $300 $310 $320 $330 $340 $350 $360 $370 $380 $390 $400 How much should they spend on advertising? Where should they set their price? Advertising Budget SZS non non $50,000,000 Decision Set Selection Choose the Scenario that is most profitable. $25,000,000 $200 $210 $220 $230 $240 $250 $260 $270 $280 $290 $300 $310 $320 $330 $340 $350 $360 $370 $380 $390 $400 How much should they spend on advertising? Where should they set their price? Advertising Budget SZS non non $50,000,000 Decision Set Selection Choose the Scenario that is most profitable