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.

Home Insert Draw Page Layout Formulas Data Review View Assignment Tell me Share o Comments > Analysis Tools Clear 21 22 HO Connections - Properties Edit Links > Reapply Flash Fill E Data Validation Remove Duplicates Consolidate Group 1 Ungroup 19 Subtotal Stocks Get External Data Refresh All Organization Currencies I Sort Filter Advanced Text to Columns What If Analysis C49 x fx A B D E F G H 1 J K L M N O P 150000000 100000000 32 33 34 35 36 37 38 39 50000000 Supplier Contract $0 $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 $60,000,000 $70,000,000 $80,000,000 $90,000,000 $100,000,000 $169,171,645 202825000 192825000 197048667.3 195368979.3 191272334.6 185851332.7 179592646.6 172755882.4 165496001.9 157912958.6 150075000 0 40 $0 $30,000,000 $50,000,000 $70,000,000 $80,000,000 $90,000,000 000'000'oors $40,000,000 $60,000,000 41 42 43 44 45 $10,000,000 $20,000,000 Supplier Contract Level Optimal Supplier Contract? $0 46 Advertising Budget $50,000,000 Price, Advertising, and Profitability $25,000,000 $75,000,000 $1 $1 $1 Total Profit 1 -$25,000,000 Price 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 $200 $210 $220 $230 $240 $250 $260 $270 $280 $290 $300 $310 $320 $330 $340 $350 $360 $370 $380 $390 $400 $0 $0 $0 $200 $210 $220 $230 $240 $250 $260 $270 $280 $290 $300 $310 $320 $330 $340 $350 $360 $370 $380 $390 $400 Price How much should they spend on advertising? Where should they set their price? Paycheck Scenario Summary Pricing + E 100% Home Insert Draw Page Layout Formulas Data Review View Assignment Tell me Share o Comments > Analysis Tools Clear 21 22 HO Connections - Properties Edit Links > Reapply Flash Fill E Data Validation Remove Duplicates Consolidate Group 1 Ungroup 19 Subtotal Stocks Get External Data Refresh All Organization Currencies I Sort Filter Advanced Text to Columns What If Analysis C49 x fx A B D E F G H 1 J K L M N O P 150000000 100000000 32 33 34 35 36 37 38 39 50000000 Supplier Contract $0 $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 $60,000,000 $70,000,000 $80,000,000 $90,000,000 $100,000,000 $169,171,645 202825000 192825000 197048667.3 195368979.3 191272334.6 185851332.7 179592646.6 172755882.4 165496001.9 157912958.6 150075000 0 40 $0 $30,000,000 $50,000,000 $70,000,000 $80,000,000 $90,000,000 000'000'oors $40,000,000 $60,000,000 41 42 43 44 45 $10,000,000 $20,000,000 Supplier Contract Level Optimal Supplier Contract? $0 46 Advertising Budget $50,000,000 Price, Advertising, and Profitability $25,000,000 $75,000,000 $1 $1 $1 Total Profit 1 -$25,000,000 Price 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 $200 $210 $220 $230 $240 $250 $260 $270 $280 $290 $300 $310 $320 $330 $340 $350 $360 $370 $380 $390 $400 $0 $0 $0 $200 $210 $220 $230 $240 $250 $260 $270 $280 $290 $300 $310 $320 $330 $340 $350 $360 $370 $380 $390 $400 Price How much should they spend on advertising? Where should they set their price? Paycheck Scenario Summary Pricing + E 100%