Question: 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
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. INote: You should be able to copy-paste the data into Excel Options for increasing Contribution Options for Marketing Both Marketing & OM Increasing Current OM Option Option Options Contribution Increase Reduce Increase Sales Revenue Do Sales Action Plan Production by 40% & Reduce Nothing Revenue by Costs by 15% Production Costs by 15% 40% Sales $ revenue 100.000 Cost of 5 goods (70%) 70,000 COGS Gross $ margin 30,000 KPBIT) Finance costs $ 10.000 $ 20,000 PBT 10,000 Taxes at $ 30% 6,000 Contribution $ (PAT) 14,000 a) Which option among Marketing and OM will lead to maximum proht? [2points) bilf the company chooses to impment both Marketing & OM options, what will be the increase in Contribution (PAT) in comparison with the current situation? [2points
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
