Help 17 Required information Chapter 5: Applying Excel The Chapter 5 Form worksheet Is to be used to create your own worksheet version of the Review Problem example in the art 2 of 2 ints Chapter 5: Applying Excel: Exercise (Part 2 of 2) 2. Change all of the numbers in the data area of your worksheet so that it looks like this: 1 Chapter 5: Applying Excel 3 Data Print 40,000 units 4 Unit sales 40 per unit 28 per unit 6Variable ox ferences If your formulas are correct, you should get the correct answers to the following questions (a) What is the break-even in dollar sales? (b) What is the 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%. centage increase in net operating Prev17 of 17 Next 4. Confirm your calculations in Requirem ent 3 above by increasing the unit sales in your worksheet by 20% so that th like this: e Data area 1 Chapter 5: Applying Excel 3 Data 48,000 units 40 per unit 28 per unit 7 Fixed expenses S 432,000 (a) What is net operating income? (Negative amount should be indicated by a minus sign.) (b) By what percentage did the net operating income increase? Next >