Refer to the information for Performance Sports in Skill-Building (below). Provide Excel spreadsheet to calculate the operating profit (loss) for the base case and for each of the three scenarios presented in the case. include "data entry" and "sensitivity analysis results" sections, and combine variable cost of goods sold and selling and administrative costs on one line and fixed cost of goods sold and selling and administrative costs on another line.Please provide a sensitivity analysis formatted in the blank example below.

Present Situation Financial Data Option 1 Option 2 Sale $ 2,717,000.00 (1235 units X $2200) Sale $ 2,527,200.00 $ 2,600,000.00 Variable Cost Variable Cost iable Cost Cost of goods sold $988,000.00 (1235 units X $800) Cost of goods sold $ 1,123,200.00 Cost of goods sold $ 1,040,000.00 Selling and Admin cost $ 370,500.00 (1235 units X $300) Selling and Admin cost $ 421,200.00 Selling and Admin cost $ 390,000.00 Total Variable Cost $ 1,358,500.00 Total Variable Cost $ 1,544,400.00 Total Variable Cost $ 1,430,000.00 Contribution Margin $ 1,358,500,00 Contribution Margin 982,800.00 tribution Margin $1,170,000.00 Fixed Cost Fixed Cost ed Cost Cost of goods sold $800,000.00 Cost of goods sold $ 800,000.00 Cost of goods sold $ 800,000.00 Selling and Admin Cost $400,000.00 Selling and Admin Cost $ 400,000.00 Selling and Admin Cost $ 400,000.00 Total Fixed Cost $ 1,200,000.00 Total Fixed Cost 1,200,0 Total Fixed Cost $ 1,200,000.00 Operating Loss 158,500.00 Operating Loss $ (2,127,200.00) erating Loss (30,000.00] Present Sale Price $ 2,000.00 Present Sale Price 2,000.00 Increased Sales Price $ 2,200.00 ($2000 x 1.10) Decreased Sale Price 1,800.00 ($2000 X 0.90) Present Sale Volume 1300 Present Sale Volume 1,300.00 Increased Sale Volume 1404 (1300 X 1.08) Decreased Sale Volume 1,235.00Option 3 Sale $ 2, 990, 000. 00 Variable Cost 1 196000 448500 Total Variable Cost 5 1 , 64 4 , 500. 00 Contribution Margin $ 1 , 3.45 , 500. 00 Fixed Cost Cost of goods sold $ 800, 000. 00 Selling and Admin Cost $ 600, 000. 00 Total Fixed Cost $ 1 , 400 , 000. 00 Operating Loss* (54 , 500 . 00 ) Present Sale Price* 2, 000 . 00 Present Sale Volume 1300 Increased Sale Volume* 1495 ( 1300* * 1 . 15 ) Option 3 - increase in fixed advertisement expenses by 2000000 which will increase cals volume by 15%B D Data Entry Section Base Case Scenario 1 Scenario 2 Scenario 3 Fixed Costs Decrease 30%; Sales varaible Price Volume cost Increase decreased increase Variable 10% 10% 10% Sales Price per unit Variable Cost per unit Monthly Fixed Cost Volume of Sales (units) Inl Performance Sports Sensitivity Analysis Result 2 1 Sales 3 Variable Costs 4 Contribution Margin 5 Fixed Costs 5 Operating Profit Dollarr Change in Profit from Base Case Percent Change in Profit 3 from Base Case Im