Pretty sure i got cells C32:C43 wrong, could someone give me the right answers + step by step?

832 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Supplier Contract D o Decisions to e Made Price Supplier Contract Advertising Budget c $350 $75,000,000 $35,000,000 Market Information Competitor Pricing Base Demand Market Size $200 1,000,000 Variable Cost Calculations Variable Production Costs Prepaid Discount Amount Adjusted Variable Costs Demand Calculations Price Demand Factor Total Demand $199 $26 $173 -75% 1575000 Profitability Total Revenue (-) Total Variable Costs (-) Total Fixed Costs Total Profit $272,078,355 $110,000,000 $169,171,645 Inputs Price (C3) Decision Set Decision Set 2: Decision Set 3i Decision Set 4 $200 $250. Decision Set 3 $329. $250 Supplier Contract (C4)} Advertising (C5) Which Scenario is most profitable? Goal Seek Parameters and Results Introducing the new, smaller eTablet to market You work on the new product development team for your company's new tablet computer offering, a smaller version of your wildly popular eTablet line. You have been given the task of determining three important decisions for this new product. First, you have been asked to determine the price for this product. Pricing is a tricky decision. You dorft want to price the new tablet too high because few customers will choose the new product over your full-sized tablet offerings and you risk losing sales to your aggressively priced competitors' products. You dorft want to price the product too low, because you want to earn as much revenue as possible from the product. Second, you must determine where to set the marketing budget for the new product. You know that there will be a base demand for your product that comes from your loyal customers who will buy just about anything you produce. Beyond that you also know that every dollar you spend on advertising will increase the demand for your product. Of course, there is a limit to how much money you will want to spend on advertising because eventually more money spent on advertising will have little effect on demand and will reduce the profitability of the new product. Finally, you have been asked to help decide how much money to prepay to the suppliers of the raw materials of the new product to reduce the overall costs of these materials. Every dollar you spend on prepaying your suppliers will reduce the costs of these materials and will ensure that your competitors dorft have access to these materials. You have completed a spreadsheet model to aid in your analysis. Use the 'What If Analysis' options in Excel to help you determine the right rice, advertisin s endin and re aid su lier contract for our new roduct. Set Cell To Value By Changing Cell Resulting Price? $c$14 2,625,000 $C$3 $290 Supplier Contract and Profitability Su lier Contract and Profitabilit 300000000 250000000 200000000 150000000 0 100000000 sooooooo -50000000 -IE+08 Assignment Tasks Pricing, Advertising, and Prepaid Contracts Create a one-way data table using the values in cells B32:B43 after 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 3 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] Supplier Contract $0 $10,000,000 $20,000,000 $30,000,000 $60,000,000 $80,000,000 $90,000,000 $100,000,000 $169,171,645 -75000000 -5236672.944 64526654.11 134289981.2 204053308.2 273816635.3 263816635.3 253816635.3 243816635.3 233816635.3 223816635.3 000 000 000 000 000 409 Supplier Contract Level 000