READ BEFORE SOLVING.. 3rd time posting. solve in cell function format.. exampl: =b5-b7

. 1 - E TE U UU AU 140 x D E F G H K . + A B 1 Chapter 1: Applying Excel 2 3 Data 4 Sales $12.000 5 Variable costs 6 Cost of goods sold $6,000 7 Variable selling $600 Variable administrative $400 9 Food costs: 10 Fixed soling $2,500 11 Foed administrative $1,500 12 13 Enter a formula into each of the cells marked with a bolow 14 Exhibit 1-7 15 16. Traditional Format Income Statement 17 Sales 18 Cost of goods sold 19 Gross margin 20 Soling and administrative expenses 21 Seling 2 22 Administrative 2 23 Net operating income 24 25 Contribution Format Income Statement 26 Sales 27 Variable expenses 28 Cost of goods sold ? 20 Variable seling 2 ? 30 Variable administration 31 Contribution margin 32 Fixed expenses 33 Fixed selling 7 34 Fbcod administrative 7 35 Not operating income 36 37 38 ? 7 2 ? 2 7 7 ? ? ? 40 41 42 43 44 45