Answered step by step
Verified Expert Solution
Question
1 Approved Answer
6. In the table below, you can see the Basic Data of an Income Statement of ABC INC. The management has asked you to increase
6. In the table below, you can see the Basic Data of an Income Statement of ABC INC. The management has asked you to increase net profit by 4%, by reducing the cost of goods (COGS). (20 marks) The assignments are: a) Develop this table into the tab of your Excel file (tab 5). Show all the cases with %. b) Then develop a second table in the same tab) with the new values when you decrease the COGS. c) Calculate the ELA% (Leverage Effect on Acquisition) Quantity sold 5000 Account Results Unit cost TOTAL Sale 30.00 $ 150000 $ Cost of goods 20.00 $ 100000 $ Gross Margin Operation Cost 7.62 $ 38100 $ Net Profit Quantity sold 5000 TOTAL 150000 $ Account Results Unit cost Sale 30.00 $ Cost of goods Gross Margin lopreration Cost 7.62 $ Net Profit 38100 $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started