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 A 1 Chapter 5: Applying Excel 2 3 Data 4 Unit sales 5 Selling price per unit 6 Variable expenses per unit 7 Fixed expenses 96,000 units $ 10 per unit $ 5 per unit $ 200,000 (a) What is net operating income? (Negative amount should be indicated by a minus sign.) Not operating income (los) (b) By what percentage did the net operating income increase? Porcentage inore in not operating income 5 Thad Morgan, a motorcycle enthusiast, has been exploring the possibility of relaunching the Westem Hombre brand of cycle that was popular in the 1930s. The retro-look cycle would be sold for $16.000 and at that price, Thad estimates 800 units would be sold each year. The variable cost to produce and sell the cycles would be $12,000 per unit. The annual fixed cost would be $2.560.000 What is the break-even in unit sales? n. What is the margin of safety dollars