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.

View Tools Data Page Layout 137 x How much should they spend on advertininN? Prkin AdvertisinL and Contracts Price, Advertising, and Profitability View Tools Data Page Layout 137 x How much should they spend on advertininN? Prkin AdvertisinL and Contracts Price, Advertising, and Profitability