Please show formuals and graphs when complete.

create one way data table for the supplier contract and profitabality chart

create a two way data table for the price,advertising, and profitability chart

Pricing, Advertising, and Prepaid Contracts Create a one-way data table using the values in cells B32:B43 after referencing total profic (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. [ 10 points] Pricing, Advertising, and Prepaid Contracts Create a two-way data table after referencing total profit (calculated in cell F12) and using the values in cells. B49:B69 (Price) and C48:E48 (Advertising Budget) to analyze the relationships among advertising budget, price, and profitability. Make sure you highlight cells B48:E69 before going to the Data Table tool. 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. [15 points] \begin{tabular}{|l|r|} \hline \multicolumn{2}{|c|}{ Decisions to be Made } \\ \hline Price & $290 \\ \hline Supplier Contract & $100,000,000 \\ \hline Advertising Budget & $35,000,000 \\ \hline \end{tabular} \begin{tabular}{|lr|} \hline \multicolumn{2}{|c|}{ Market Information } \\ \hline Competitor Pricing & $200 \\ Base Demand & 1,000,000 \\ Market Size & 5,000,000 \\ \hline \end{tabular} \begin{tabular}{|l|c|} \hline By Changing Cel & Sc\$5 \\ \hline Resulting Price? & $290 \\ \hline \end{tabular} Supplier Contract and Profitability Where should they set their price? Pricing, Advertising, and Prepaid Contracts Create a one-way data table using the values in cells B32:B43 after referencing total profic (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. [ 10 points] Pricing, Advertising, and Prepaid Contracts Create a two-way data table after referencing total profit (calculated in cell F12) and using the values in cells. B49:B69 (Price) and C48:E48 (Advertising Budget) to analyze the relationships among advertising budget, price, and profitability. Make sure you highlight cells B48:E69 before going to the Data Table tool. 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. [15 points] \begin{tabular}{|l|r|} \hline \multicolumn{2}{|c|}{ Decisions to be Made } \\ \hline Price & $290 \\ \hline Supplier Contract & $100,000,000 \\ \hline Advertising Budget & $35,000,000 \\ \hline \end{tabular} \begin{tabular}{|lr|} \hline \multicolumn{2}{|c|}{ Market Information } \\ \hline Competitor Pricing & $200 \\ Base Demand & 1,000,000 \\ Market Size & 5,000,000 \\ \hline \end{tabular} \begin{tabular}{|l|c|} \hline By Changing Cel & Sc\$5 \\ \hline Resulting Price? & $290 \\ \hline \end{tabular} Supplier Contract and Profitability Where should they set their price