please show formulas used to solve

You work on the new product development team for your company's new tablet computer offering, which is 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 don't 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 don't 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. 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 don't 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 product price, advertising spending, and prepaid supplier contract for your new product. (2.1) Use the Scenario Manager to input each of the four decision sets depicted in range a. The names of each decision set are given in cells ( 16:F16. Use the decision set name as the Scenario Name in each of the four scenarios. The grader requires the Scenario Names be spell correctly. b. You must type the data into Scenario Manager, because Excel does not allow you to use a cell reference to enter data into a scenario. c. Create the summary of the scenarios on a new worksheet. d. Do not rename the scenario summary sheet generated by the scenario manager. The grader uses the default sheet name during the grading process. If you need to re-create the scenario summary, delete the original scenario summary sheet before creating another scenario summary. Using the Scenario Summary as a reference which scenario is most profitable? Decision Set 1 Decision Set 2 Decision Set 3 Decision Set 4 Goal Seek Analysis Supplier Contract and Profitahility Price, Advertising, and Profitability You work on the new product development team for your company's new tablet computer offering, which is 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 don't 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 don't 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. 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 don't 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 product price, advertising spending, and prepaid supplier contract for your new product. (2.1) Use the Scenario Manager to input each of the four decision sets depicted in range a. The names of each decision set are given in cells ( 16:F16. Use the decision set name as the Scenario Name in each of the four scenarios. The grader requires the Scenario Names be spell correctly. b. You must type the data into Scenario Manager, because Excel does not allow you to use a cell reference to enter data into a scenario. c. Create the summary of the scenarios on a new worksheet. d. Do not rename the scenario summary sheet generated by the scenario manager. The grader uses the default sheet name during the grading process. If you need to re-create the scenario summary, delete the original scenario summary sheet before creating another scenario summary. Using the Scenario Summary as a reference which scenario is most profitable? Decision Set 1 Decision Set 2 Decision Set 3 Decision Set 4 Goal Seek Analysis Supplier Contract and Profitahility Price, Advertising, and Profitability