Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following CVP income statements are available for Brooks Company and Addington Company Addington Company $700,000 -1 for each others around functional rounded to the

image text in transcribed
image text in transcribed
The following CVP income statements are available for Brooks Company and Addington Company Addington Company $700,000 -1 for each others around functional rounded to the wonder of decimal 4 points to Arwen Verify a complete ROUND Runctions, and that it is rounded to decimal aces 2 for each bardded cell Awwer Press CTRL and then. This will show the form for the Verify there are ne numbers) Combubon man Instructions insert answers below under "Answer Sheer in row 15) al Compute the degree of operating everage for each company Round your answer to 2 decimal places in the Round Function bi Prepare a CVP Income statement for each company assuming Sales increases by 20% Cell Referencin i no B elis BRS B2925 2 Part does not use Decree of Operating leveres forme -1 Part does not use te e ning in and C posto 1 incorrect flere holder mest Namewelrpti total) -10 the files from previous restent maybe wetten til 50 points for more and other actions as the tractors c) Calculate Change in Net income at nalandsson Answer Sheet Brooks Addington Round each Degree of Operating leverage using the ROUND function to round your answers to 2 decimal places Degree of Operating Leverage b) Complete the CM Income Statement (Use Absolute Cell Referencing (5) when using B22 in cells B25, B26, C25, C26) Total Sales Increase Brooks Company Addington Company Complete the CM Income Statement with a 20% Increase in Sales, by absolute cell referencing cell 822 Sales revenue Variable costs Contribution margin Fixed costs Net income Brooks Company Addington Company c) Calculate Percentage Change in Net Income for each company Using the Degree of Operating Leverage calculated in Parta) and the Sales Increase in B34 Use Absolute Cell Referencing when using B34 in your formula and Use the ROUND Function to round your answer to 2 decimal places Round each change in Net Income using the ROUND function to round your answers to 2 decimal places Sales Percentage Increase

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

Investment Grade Energy Audit Making Smart Energy Choices

Authors: Shirley J. Hansen, James W. Brown

1st Edition

0824709284, 978-0824709280

More Books

Students also viewed these Accounting questions

Question

Differentiate the function. r(z) = 2-8 - 21/2 r'(z) =

Answered: 1 week ago