Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show the excel formulas for each solution. Below is the answer to the questions, I need help understanding what formulas to use in excel.

image text in transcribed

Please show the excel formulas for each solution.

Below is the answer to the questions, I need help understanding what formulas to use in excel.

image text in transcribed

Thank you so much!

Case Volume-Profit Income Statements Sales revenue Variable costs Contribution margin Fixed costs Net income $ $ S $ $ East Aviation 976,000 817,400 158,600 90,000 68,600 Mountain Adventures $ 1,000,436 $ 563,000 S 437,436 $ 200,000 $ 237,436 Here's what to do: A.) Compute the degree of operating leverage for each company. *Cell reference AND round to 3 places by using =ROUNI function. East Aviation Mountain Adventures B.) Prepare a CVP/Contribution Margin income statement assuming sales increase by 17%. Use E25 as a reference. *Absolute cell reference (S) when using cell E25 in cells D28, D29, H28, and H29. Sales increase: 1.17 Mountain Adventures East Aviation 19.89 $ Sales revenue Variable costs Contribution margin Fixed costs Net income Cest-Volume-Profit Income Statements East Aviation Sales revenue $ 976,000 Variable costs $ 817,400 Contribution margin $ 158,600 Fixed costs $ 90,000 Net income $ 68,600 Mountain Adventures $ 1,000,436 $ 563,000 $ 437,436 $ 200,000 $ 237,436 Here's what to do: A.) Compute the degree of operating leverage for each company. *Cell reference AND round to 3 places by using =ROUND function. East Aviation Mountain 2.312 1.842 B.) Prepare a CVP/Contribution Margin income statement assuming sales increase by 17%. Use E25 as a reference. *Absolute cell reference (S) when using cell E25 in cells D28, D29, H28, and H29. Sales increase: 1.17 Sales revenue Variable costs Contribution margin Fixed costs Net income $ $ $ $ $ East Aviation 1,141,920 956,358 185,562 90,000 95,562 Mountain Adventures $ 1,170,510 $ 658,710 $ 511,800 $ 200,000 $ 311,800

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_2

Step: 3

blur-text-image_3

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

How To Audit Document Control System Based On ISO 9001 2015

Authors: Folarin Omojoye

1st Edition

B09892NF88, 979-8525615175

More Books

Students also viewed these Accounting questions