Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need the answers to the blue colored cells. Can you please show me how you would calculate the answers using excel, Thank you so

image text in transcribedimage text in transcribed

I need the answers to the blue colored cells.

Can you please show me how you would calculate the answers using excel, Thank you so much!

Degree of operating leverage. Grey Products has fixed operating costs of $380,000, variable operating costs of $16 per unit, and a selling price of $63.50 per unit a. Calculate the operating breakeven point in units. b. Calculate the firm's EBIT at 9,000, 10,000, and 11,000 units, respectively c. With 10,000 units as a base, what are the percentage changes in units sold and EBIT as sales move from the base to the other sales levels used in part b? d. Use the percentages computed in part e to determine the degree of operating leverage (DOL) e.Use the formula for degree of operating leverage to determine the DOL at 10,000 units. Solution a. Calculate the operating breakeven point in units. Fixed operating costs Variable operating costs Selling price Operating breakeven point S 380,000 $ 16.00 S 63.50 b. Calculate the firm's EBIT at 9,000, 10,000, and 11,000 units, respectively Units 9,000 10,000 11,000 Sales Less: Variable costs Less: Fixed costs 380,000 S S 380,000 380,000 EBIT c. With 10,000 units as a base, what are the percentage changes in units sold and EBIT as sales move from the base to the other sales levels used in part b? 9,000 Units 10,000 11,000 Change in unit sales % change in unit sales Change in EBIT % change in EBIT 0% 0% d. Use the percentages computed in part c to determine the degree of operating leverage (DOL) Degree of operating leverage e.Use the formula for degree of operating leverage to determine the DOL at 10,000 units 10,000 380,000 Units Fixed operating costs Variable operating costs Selling price Degree of operating leverage $ 16.00 63.50

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

Mergers Acquisition And Other Restructuring Activities

Authors: Donald M. Depamphilis

6th Edition

123854857, 978-0123854858

More Books

Students also viewed these Finance questions