Scenario Manager Problems: Solution Have to made in Excel. Problem 1:Look into the following data: Year 1 Data Tax Rate No. of Units Sold Sales Growth Unit Price Unit Cost Discount Rate Cost Growth Price Growth 0.4 12000 0.05 $ 7.50 $ 6.00 0.15 0.05 0.03 Using this scenario as my current scenario, I want to calculate NPV of 5 years.I also want to create best, worst and most likely scenarios by changing Year 1 sale, sales growth andsales price. The value for my sensitivity analysis is as follows: Best case Most likely case Worst case Year 1 Sales 20,000 units 10,000 units 5,000 units Sales growth 20% Year 1 sales price $10 10% $7.5 2% $5 Make a Summary Table using the scenario manager (Include five years' profits and NPV in the report) Problem 2: Look into the following data: Price Demand Unit Cost Fixed Cost Profit Calculation $ 4 29000 $ 0.45 $ 45,000 Using the scenario as my current scenario, I want to calculate the profit. I also want to create "High cost/high price", "Medium cost/medium price" and "Low cost/low price" scenarios by changing PRICE, UNIT COST and FIXED COST. The value for my sensitivity analysis is as follows: Price High cost/high $5.00 price Medium $4.00 cost/medium price Low cost/low price $2.50 Unit Cost $1.00 $0.75 $0.40 Fixed Cost $65,000.00 $45,000.00 $25,000.00 Make a Summary Table using the scenario manager (Include Profit in the report).