Confirm your calculations by increasing the unit sales in your worksheet by 20% so that the Data area looks like this:

Transcribed Image Text:

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 8 B $ 175,000 C 84,000 units $20 per unit $10 per unit $665,000 (a) What is net operating income? (Negative amount should be indicated by a minus sign.) Net operating income (loss) D (b) By what percentage did the net operating income increase? Percentage increase in net operating income 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 8 B $ 175,000 C 84,000 units $20 per unit $10 per unit $665,000 (a) What is net operating income? (Negative amount should be indicated by a minus sign.) Net operating income (loss) D (b) By what percentage did the net operating income increase? Percentage increase in net operating income

Answer rating: 100% (QA)

a Previous unit sale 84000 20 11 70000 operati... View the full answer