Please help me with 4(a). Thanks! :) (b) What is the margin of safety percentage?Answer is complete and correct.Margin of safety percentage10 O %(c) What is the degree of operating leverage? (Round your answer to 2 decimal places.)Answer is complete and correct.Degree of operating leverage10.003. Using the degree of operating leverage and without changing anything in your worksheet, calculate the percentage change in netoperating income if unit sales increase by 20%.O Answer is complete and correct.Percentage increase in net operating income200 O %4. Confirm your calculations in Requirement 3 above by increasing the unit sales in your worksheet by 20% so that the Data area lookslike this:AB1Chapter 5: Applying Excel23Data4Unit sales72,000 unitsSelling price per unit10 per unit6.Variable expenses per unit6 per unit7Fixed expenses$ 216,000(a) What is net operating income? (Negative amount should be indicated by a minus sign.)X Answer is complete but not entirely correct.Net operating income (loss)90,000 x x v fxB7270000AВ1 Chapter 5: Applying Excel23 Data4 Unit sales20,000 units5 Selling price per unit6 Variable expenses per unit7 Fixed expenses$60 per unit$45 per unit$270,00089 Enter a formula into each of the cells marked with a ? below10 Review Problem: CVP Relationships1112 Compute the CM ratio and variable expense ratio13 Selling price per unit14 Variable expenses per unit15 Contribution margin per unit$60 per unit45 per unit$15 per unit1617 CM ratio25%18 Variable expense ratio75%1920 Compute the break-even18,000 units$1,080,00021 Break-even in unit sales22 Break-even in dollar sales2324 Compute the margin of safety25 Margin of safety in dollars26 Margin of safety percentage$ 120,00010%2728 Compute the degree of operating leverage$ 1,200,000900,000300.00029 Sales30 Variable expenses31 Contribution margin32 Fixed expenses33 Net operating income$270,00030,000$3435 Degree of operating leverage10.002. Change all of the numbers in the data area of your worksheet so that it looks like this:ABChapter 5: Applying Excel2DataUnit sales5 Selling price per unit6 Variable expenses per unit7 Fixed expenses460,000 units10 per unit6 per unit$ 216,000$If your formulas are correct, you should get the correct answers to the following questions.(a) What is the break-even in dollar sales?O Answer is complete and correct.Break-even in dollar sales540,000 O

Operating income represents the earnings remain after subtracting the expenses incurred during that…

4. Confirm your calculations in Requirement 3 above by increasing the unit sales in your worksheet by 20% so that the Data area looks like this: A B 1 Chapter 5: Applying Excel 2 3 Data Unit sales 5 Selling price per unit 6 Variable expenses per unit 7 Fixed expenses 72,000 units 10 per unit 6 per unit $ 216,000 4 (a) What is net operating income? (Negative amount should be indicated by a minus sign.) Answer is complete but not entirely correct. Net operating income (loss) 90,000 X

4. Confirm your calculations in Requirement 3 above by increasing the unit sales in your worksheet by 20% so that the Data area looks like this: A B 1 Chapter 5: Applying Excel 2 3 Data Unit sales 5 Selling price per unit 6 Variable expenses per unit 7 Fixed expenses 72,000 units 10 per unit 6 per unit $ 216,000 4 (a) What is net operating income? (Negative amount should be indicated by a minus sign.) Answer is complete but not entirely correct. Net operating income (loss) 90,000 X

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

A7 please help[.....
The answer 417,974.94 was correct. Can you please help me solve without technology? Formulas used, etc. Thank you!
Can you please solve questions 5-15 of the problem above. Thank you.
only answer d now please
solve it using this method: S2 = (((1+S1)*(1+F2))1/2 )– 1 S3 = ((1+S1)*(1+F3)) 1/3 - 1 P = 50/(1+S1)+50 / (1+S2) 2 + 1050 / (1+S3) 3 and find the value of p
how do you get the last part? (number 5)