1 Chapter 1: Applying Excel 2 3 Data 4 Sales $ 50,850 5 6 $ 36,160 Variable costs: Cost of goods sold Variable selling Variable administrative 7 $ 3,616 3,390 8 $ 9 Fixed costs: 10 Fixed selling $ 2,500 11 Fixed administrative $ 1,500 Enter this new data into your worksheet. Make sure you enter all of the new data - not just the sales. (a) What is the gross margin now? Answer is complete but not entirely correct. Gross margin $ 3,684 X