1. Now change all of the dollar amounts in the data area of your worksheet so that it looks like this:

If your formulas are correct, you should get the correct answers to the following questions.

(a) What is the gross margin now?(a) What is the gross margin now? (b) What is the net operating income now? (c) What is the contribution margin now?

1 Chapter 2: Applying Excel $61,500 3 Data 4 Sales 5 Variable costs: 6 Cost of goods sold Variable selling Variable administrative 9 Fixed costs: 10 Fixed selling 11 Fixed administrative 12 $29,000 $2,900 $2,700 $2,500 $1,500