Question: Please Solve using MS Excel and show formulas U.S. Steal has the following income statement data: Units Sold 130,000 150,000 Total Variable Costs $ 390,000

 Please Solve using MS Excel and show formulas U.S. Steal has

Please Solve using MS Excel and show formulas

U.S. Steal has the following income statement data: Units Sold 130,000 150,000 Total Variable Costs $ 390,000 450,000 Fixed Costs $130,000 130,000 Total Costs $ 520,000 580,000 Total Revenue $ 780,000 900,000 Operating Income (Loss) $ 260,000 320,000 The top row of the table has the beginning values and the bottom row of the table has the ending values. a. Compute the degree of operating leverage (DOL) based on the formula below. (Do not round intermediate calculations. Round your final answer to 2 decimal places.) DOL Percent change in operating income Percent change in units sold Degree of operating leverage b. Recompute DOL using the formula given below. There may be a slight difference due to rounding. (Do not round intermediate calculations. Round your final answer to 2 decimal places.) DOL Q(P - VC) QIP - VC) - FC Q represents beginning units sold (all calculations should be done at this level). P can be found by dividing total revenue by units sold. VC can be found by dividing total variable costs by units sold. Degree of operating leverage

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!