Question: I need help. What am I doing wrong? I was asked to start each formula with an equal sign 10 abe Wrap Text General B
10 abe Wrap Text General B Currency 2 Pasta Marge - 96 FS Condikenal Formatting Noma D G H 126 - A Chapter 18 Applying Excel 2 3 Data 4 Sales $12,000 S Variable costs: 6 Cost of goods sold $6,000 7 Variable selling $600 8 Variable administrative $400 9 Fixed costs: 10 Fixed selling $2,500 11 Fixed administrative $1,500 12 13 Enter a formula into each of the cells marked with a 7 below 14 Exhibit 1-7 15 16 Traditional Format Income Statement 17 Sales 64 18 Cost of goods sold b 19 Gross margin b4-b6 b19 20 Selling and administrative expenses: 21 Seling b7+10 22 Administrative b8+11 um b2221 23 Net operating Income 24 25 Contribution Format Income Statement 26 Sales b4 27 Variable expenses: 28 Cost of goods sold b6 29 Variable selling b7 30 Variable administration bB 28:29:30 31 Contribution margin sum=31 32 Fixed expenses: 33 Fixed selling b10 34 Fixed administrative b11 um b34b33 35 Net operating income +621-634+b33 sumb35 36 37 38 39 40 41 42 sum b22 a>
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
