Excel File Edit Data Window Help G D Q 9 Sun Feb 6 9:04 PM View Insert Format Tools AAC ... AutoSave DEF Excel Analytics 1-21 Analytic Solver Data Mining Tell me Home Insert Draw Page Layout Formulas Data Review View Share V Comments X Calibri (Body) v 11 v General Insert v == 29 = = = 47 Conditional Formatting Format as Table Cell Styles O Delete v Paste I U * y ER ar A - A Sensitivity $ %) Format Sort & Filter Find & Select Analyze Data Y P28 . X SX C D E F H I J L M N 0 0 P O R S T Traditional Format Income Statement $ 950,000 $ 950,000 3 Sales Cost of goods sold (OM+DL +all MOH) 5 Gross margin Selling and administrative expenses: 7 Selling fall) B Administrative (all! 9 Net operating income 10 11 12 13 Contribution Format Income Statement 14 Sales 15 Variable expenses 16 Cost of goods sold DMDLYMOH) 17 Variable selling 18 Variable administrative 19 Contribution margin 20 Fixed expenses 21 Fixed manufacturing overhead 22 Fixed selling 23 Fixed administrative 24 Net Operating income 25 26 27 28 29 30 31 Reg 1 Reg 3 Select destination and press ENTER or choose Paste HIE E 100% HE f 6 e tv A Excel File Edit Data Window Help G D Q 9 Sun Feb 6 9:04 PM View Insert Format Tools AAC ... AutoSave DEF Excel Analytics 1-21 Analytic Solver Data Mining Tell me Home Insert Draw Page Layout Formulas Data Review View Share V Comments X Calibri (Body) v 11 v General Insert v == 29 = = = 47 Conditional Formatting Format as Table Cell Styles O Delete v Paste I U * y ER ar A - A Sensitivity $ %) Format Sort & Filter Find & Select Analyze Data Y P28 . X SX C D E F H I J L M N 0 0 P O R S T Traditional Format Income Statement $ 950,000 $ 950,000 3 Sales Cost of goods sold (OM+DL +all MOH) 5 Gross margin Selling and administrative expenses: 7 Selling fall) B Administrative (all! 9 Net operating income 10 11 12 13 Contribution Format Income Statement 14 Sales 15 Variable expenses 16 Cost of goods sold DMDLYMOH) 17 Variable selling 18 Variable administrative 19 Contribution margin 20 Fixed expenses 21 Fixed manufacturing overhead 22 Fixed selling 23 Fixed administrative 24 Net Operating income 25 26 27 28 29 30 31 Reg 1 Reg 3 Select destination and press ENTER or choose Paste HIE E 100% HE f 6 e tv A