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 Fixed expenses 12,000 units $ 30 per unit $ 12 per unit $ 135,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 $14,000 and at that price, Thad estimates 200 units would be sold each year. The variable cost to produce and sell the cycles would be $11,200 per unit. The annual fixed cost would be $280,000. a. What is the break-even in unit sales? Break-even in unit sales b. What is the margin of safety in dollars? Margin of safety in dollars