Question 35 14 pts Problem (14 points Solve this problemin Excel Use the following me to compute the blank cells in the table 10 pointul. Am the following question after the analysis Note: You should be able to use the data into Excel Opcions for increasing Contribution Options for Marketing Both Marketing & OM Increasing Curren OM Option Option Option contribution Increase Reduce Increase sales Revenue Do Sales Action Plan Production by CON & Reduce Nothing Revenue by Cents by 15% Production Costs by 1556 1096 Sales 5 revenue 100,000 Cost of 5 poods (7050 70.000 COGS Gross $ margin 30.000 ) Finance $ 10,000 $ 20.000 Tesat 5 3056 6,000 Contributions PATI 10 000 al Which option among Marketing and OM will lead to maximum profit 12 points bi if the company chooses topment both Marketing & OM options, what will be the increase in contribution (PAT) in comparison with the current situation point Problem (14 points Solve this problem in Excel: Use the following table to compute the blank cell values in the table. [10 points). Answer the following questions after the analysis. (Note: You should be able to copy paste the data into Excell Options for increasing Contribution Options for Marketing Increasing Current OM Option Option Contribution Both Marketing & OM Options Reduce Increase Sales Revenue Production by 40% & Reduce Costs by 15% Production Costs by 15% Increase Do Sales Action Plan Nothing Revenue by 40% Sales $ revenue 100.000 Cost of $ goods (70%) 70,000 COGS) Gross $ margin 30,000 IPBIT) Finance costs $ 10,000 $ 20.000 PBT Taxes at $ 30% 6,000 Contributions 14.000 al Which option among Marketing and OM will lead to maximum profit? 12 points) b) If the company chooses to impment both Marketing & OM options, what will be the increase in Contribution (PAT) in comparison with the current situation [2points)