B 4 Chapter 1: Applying Excel 5 6 Data 7 Sales RM12,000.00 8 Variable costs: 9 Cost of goods sold RM6,000.00 10 Variable selling RM600.00 11 Variable administrative RM400.00 12 Fixed costs: 13 Fixed selling RM2,500.00 14 Fixed administrative RM1,500.00 15 16 Enter a formula into each of the cells marked with a ? below 17 Exhibit 1-7 18 19 Traditional Format Income Statement 20 Sales 21 Cost of goods sold 22 Gross margin 23 Selling and administrative expenses. 24 Selling ? 25 Administrative 26 Net operating income ? ? 7 PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to & 2 2 2 ? 2 2 ? A B 16 Enter a formula into each of the cells marked with a 7 below 17 Exhibit 1-7 18 19 Traditional Format Income Statement 20 Sales 21 Cost of goods sold 22 Gross margin 23 Selling and administrative expenses: 24 Selling 25 Administrative 26 Net operating income 27 28 Contribution Format Income Statement 29 Sales Variable expenses 31 Cost of goods sold 32 Variable selling 33 Variable administration 34 Contribution margin 35 Fixed expenses 36 Fixed selling 37 Fixed administrative 3B Net operating income 2 2 2 2 2 2 2 ? 01 MANUFACTURING 02-JOB ORDER COSTING 03- PROCESS Ready Type here to search