odeling Basics-vis Joey Keem (1) View FoxIT PDF Assignment Q Tell me what you want to do Share Assignment Tasks Pricing, Advertising, and Prepaid Contracts 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. [10 points] the raw materials of the new product to reduce the overall costs of these mate cision Set 4 spend on prepaying your suppliers will reduce the costs of these materials and $250 competitors don't have access to these materials. You have completed a sprea 20,000,000 your analysis. Use the "What if Analysis' options in Excel to help you determine 50,000,000 spending, and prepaid supplier contract for your new product upplier Contract and Profitability odeling Basics-vis Joey Keem (1) View FoxIT PDF Assignment Q Tell me what you want to do Share Assignment Tasks Pricing, Advertising, and Prepaid Contracts 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. [10 points] the raw materials of the new product to reduce the overall costs of these mate cision Set 4 spend on prepaying your suppliers will reduce the costs of these materials and $250 competitors don't have access to these materials. You have completed a sprea 20,000,000 your analysis. Use the "What if Analysis' options in Excel to help you determine 50,000,000 spending, and prepaid supplier contract for your new product upplier Contract and Profitability