Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Will You Be My Internal Audit Manager

Authors: Benito Gross

1st Edition

B09774C8CK, 979-8521636563

More Books

Students also viewed these Accounting questions

Question

6. Show that E(F G) = EF EG.

Answered: 1 week ago