Chapter 5: Applying Excel: Exercise (Part 2 of 2) (Algo) 2. Change all of the numbers in the data area of your worksheet so that it looks like this: A B 1 Chapter 5: Applying Excel 2. 3 4 Data Unit sales Selling price per unit Variable expenses per unit un $ $ 50,000 units 50 per unit 20 per unit 6 7 Fixed expenses 1,350,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? Break-even in dollar sales (b) What is the margin of safety percentage? Margin of safety percentage % (c) What is the degree of operating leverage? (Round your answer to 2 decimal places.) 3. Using the degree of operating leverage and without changing anything in your worksheet, calculate the percentage change in net operating income if unit sales increase by 20% Petceritage 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 looks like this B 1 Chapter 5: Applying Excel 2 3 Data 4 Unit sales 5 Selling price per unit 6 Variable expenses per unit 7 Faced expenses 60.000 units 5 50 por unit 5 20 per unit s 1 350 000 (a) What is net operating income? (Negative amount should be indicated by a minus sign.) Net operating income (loss) (b) By what percentage did the net operating income increase? Percentage increase in net operating income 5. Thad Morgan, a motorcycle enthusiast, has been exploring the possibility of relaunching the Western Hombre brand of cycle that was popular in the 1930s. The retro-look cycle would be sold for $15,000 and at that price, Thad estimates 600 units would be sold each year. The variable cost to produce and sell the cycles would be $10,500 per unit. The annual fixed cost would be $2,160,000 a. What is the break-even in unit sales? Break-even in uilt salos b. What is the margin of safety in dollars? Marity do