1Chapter 1: Applying Excel 3 Data $12.000 4 Sales 5 Variable costs: 6 Cost of goods sold 7 Variable selling 8 Variable administrative 9 Fixed costs 10 Fixed selling 11 Fixed administrative $6,0 $900 $400 $2,500 $1,500 12 13 Enter a formula into each of the cells marked with a ? below 14 Exhibit 1-7 15 16 Traditional Format Income Statement $ 12,000 17 Sales 18 Cost of goods sold 19 Gross margin 20 Selling and administrative expenses: 21 Selling 22 Administrative (6,000) 6,000 $3,100 1900 5000 (1,000) 23 Net operating income 24 Contribution Format Income Statement 25 $ 12,000 26 Sales 27 Variable expenses 28 Cost of goods sold 29 Variable selling 30 Variable administration 31 Contribution margirn 32 Fixed expenses 33 Fixed selling 34 Fixed administrative 35 Net operating income $6,000 600 400 5,000 2,500 1.500(4.000) S 1,000 36 37 1Chapter 1: Applying Excel 3 Data $12.000 4 Sales 5 Variable costs: 6 Cost of goods sold 7 Variable selling 8 Variable administrative 9 Fixed costs 10 Fixed selling 11 Fixed administrative $6,0 $900 $400 $2,500 $1,500 12 13 Enter a formula into each of the cells marked with a ? below 14 Exhibit 1-7 15 16 Traditional Format Income Statement $ 12,000 17 Sales 18 Cost of goods sold 19 Gross margin 20 Selling and administrative expenses: 21 Selling 22 Administrative (6,000) 6,000 $3,100 1900 5000 (1,000) 23 Net operating income 24 Contribution Format Income Statement 25 $ 12,000 26 Sales 27 Variable expenses 28 Cost of goods sold 29 Variable selling 30 Variable administration 31 Contribution margirn 32 Fixed expenses 33 Fixed selling 34 Fixed administrative 35 Net operating income $6,000 600 400 5,000 2,500 1.500(4.000) S 1,000 36 37