Please help me with 5d (b) What is the margin of safety percentage?Margin of safety percentage10 %(c) What is the degree of operating leverage? (Round your answer to 2 decimal places.)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%.Percentage increase in net operating income|%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 Excel2Data4Unit sales72,000 units5 Selling price per unit6 Variable expenses per unit10 per unit6 per unit$ 216,0007Fixed expenses(a) What is net operating income? (Negative amount should be indicated by a minus sign.)Net operating income (loss)90,000(b) By what percentage did the net operating income increase?Percentage increase in net operating income200 %5. Thad Morgan, a motorcycle enthusiast, has been exploring the possibility of relaunching the Western Hombre brand of cycle thatwas popular in the 1930s. The retro-look cycle would be sold for $18,000 and at that price, Thad estimates 700 units would be soldeach year. The variable cost to produce and sell the cycles would be $13,500 per unit. The annual fixed cost would be $2,362,500.a. What is the break-even in unit sales?Break-even in unit sales525b. What is the margin of safety in dollars?Margin of safety in dollars3,150,000c. What is the degree of operating leverage? (Round your answer to 2 decimal places.)Degree of operating leverage4.00 А1fxChapter 5: Applying Excel1 Chapter 5: Applying Excel3 Data4 Unit sales5 Selling price per unit6 Variable expenses per unit7 Fixed expenses20,000 units$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-even21 Break-even in unit sales18,000 units22 Break-even in dollar sales$1,080,0002324 Compute the margin of safety25 Margin of safety in dollars26 Margin of safety percentage$120,00010%2728 Compute the degree of operating leverage29 Sales$ 1,200,00030 Variable expenses31 Contribution margin32 Fixed expenses33 Net operating income900,000300,000$270,000$30,0003435 Degree of operating leverage10.00362. Change all of the numbers in the data area of your worksheet so that ilooks like this:AвChapter 5: Applying Excel3Data4Unit sales60.000 units5Selling price per unit$10 per unit6Variable expenses per unit6 per unit7Fixed expenses$ 216.000If your formulas are correct, you should get the correct answers to the following questions.(a) What is the break-even in dollar sales?wwwwmBreak-even in dollar sales540,000........

Question

Accepted Answer

As suggested, Question 5 is solved and presented in the prescribed form in excel. However, part d in…