Now change all of the dollar amounts in the data area of your worksheet so that it looks like this: B $ 27,000 1 Chapter 1: Applying Excel 2 3 Data 4 Sales 5 Variable costs 6 Cost of goods sold 7 Variable selling 8 Variable administrative 9 Fixed costs 0 Fixed selling 1 Fixed administrative $ $ $ 13,500 1,400 1,200 $ 2,500 1,500 $ If your formulas are correct, you should get the correct answers to the following questions. (a) What is the gross margin now? Gross margin $ 10,900 (b) What is the net operating income now? Net operating income 6,900 (c) What is the contribution margin now? Contribution margin $ 10.900