Excel problem
12 Demand Calculations Total Profit $169,171,645 determine where to set the marketing budget for the new product. You know th 13 Price Demand Factor -75% your product that comes from your loyal customers who will buy just about any 14 Total Demand 1575000 also know that every dollar you spend on advertising will increase the demand f 15 limit to how much money you will want to spend on advertising because event 16 17 Inputs Decision Set 1 Decision Set 2 Decision Set 3 Decision Set 4 advertising will have little effect on demand and will reduce the profitability of Price (C3 $200 $250 $329 been asked to help decide how much money to prepay to the suppliers of the ra $250 reduce the overall costs of these materials. Every dollar you spend on prepaying Supplier Contract (C4) $50,000,000 $75,000,000 $100,000,000 $20,000,000 Advertising (C5) $25,000,000 $25,000,000 $50,000,000 $50,000,000 of these materials and will ensure that your competitors don't have access to the spreadsheet model to aid in your analysis. Use the 'What If Analysis' options in E price, advertising spending, and prepaid supplier contract for your new product Which Scenario is most profitable? Goal Seek Parameters and Results Set Cell Assignment Tasks To Value Pricing, Advertising, and Prepaid Contracts By Changing Cell Use the scenario manager to input each of the four decision sets depicted in the picture near cell B16. Make sure 1 the scenario name is the name given in the image. You must type the data into scenario manager, because Excel 29 Resulting Price? does not allow you to use a cell reference to enter data into a Scenario . Create the summary of the scenarios. 30 Enter the name of the most profitable scenario in cell D22 using the drop-down box in the cell. [15 points] 31 Supplier Contract and Profitability 32 Supplier Contract 0.8 33 $0