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:
Problem (14 points) Solve this problem in Excel:
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 Excel] Both Marketing & OM Options Increase Sales Revenue by 40% & Reduce Production Costs by 15% Options for increasing Contribution Options for Increasing Current Marketing Option. OM Option Contribution Increase Sales Reduce Production Action Plan Do Nothing Revenue by 40% Costs by 15% $ Sales revenue 100.000 Cost of goods $ (70%) (COGS) 70.000 Gross margin $ (PBIT) 30.000 Finance costs $ 10,000 $ 20,000 PBT Cost of goods $ (70%) (COGS) 70,000 Gross margin S (PBIT) 30,000 Finance costs S 10,000 $ 20,000 PBT Taxes at 3096 $ 6.000 Contribution (PAT) $ 14,000 a) Which option among Marketing and OM will lead to maximum profit? 2points) 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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!