Question

Formulas Data Review View Share Comments Home Insert Draw Page Layout C18 A XV fx? B 1 Chapter 1: Applying Excel C D E F G H I J K L M N O P Q R S T U $12.000 3 4 5 8 7 B 9 10 11 Data Salas Variable costs: Cost of goods sold Variable selling Variable administrative Fixed costs: Fixed seling Fixed administrative $6.000 $500 $400 32.500 $1.500 12 13 Enter a famulinda each of the calls marked with a ? below 14 Exhibit 1-7 15 16 Traditional Format Income Statement 17 Sales 18 Cost of goods sold 19 Gross margin 20 Seling and administrative expenses 21 Seling 22 Administrative 23 Net agerating income 25 Contribution Format Income Statement 26 Sales 27 Variable expenses 28 Cost of goods sold 29 Variable selling 30 Variable administration 31 Contribution margin 32 Fixed expenses: 33 Fixed seling 34 Fixed administrative 35 Not operating income Applying Excel Required 1 Applying Excel Required 2 Exercise 1-3 Exercise 1-16 Problem 1-19 Problem 1-22 + 0 0 - - + 100%

Answer 1

Answer is given below

For excel formula Screenshot is given . Please link the cells accordingly

2 $12,000 3 Data: 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,000 $600 $400 $2,500 $1,500 12 13 Enter a formula into each of the cells 14 Sales 15 16 Traditional format Income Statement 17 $12,000 18 Cost of Goods sold $6,000 19 Gross margin $6,000 20 Selling and administrative expenses: 21 Selling $3,100 22 Administrative $1,900 $5,000 23 Net Operating Income $1,000 24 25 Contribution Format Income Statement 26 Sales $12,000 27 Variable expenses: 28 Cost of goods sold $6,000 29 Variable selling $600 30 Variable administrative $400 $7,000 31 Contribution Margin $5,000 32 Fixed expenses: 33 Fixed selling $2,500 34 Fixed administrative $1,500 $4,000 35 Net Operating Income $1,000 36

Excel Screenshot

Book1 - Microsoft Excel - O X Home Insert Page Layout Formulas Data Review View ABC as show/Hide Comment y Protect and Share Workbook Spelling Research Thesaurus Translate Show All Comments Show Ink Allow Users to Edit Ranges Protect Protect Share Sheet Workbook Workbook Track Changes Changes New Delete Previous Next Comment Comments fc Proofing G8 - A BC AD E F H 12000 6000 600 400 2500 1500 3 Data: 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 12 13 Enter a formula into each of the cells 14 15 16 Traditional format Income Statement 17 Sales 18 Cost of Goods sold 19 Gross margin 20 Selling and administrative expenses: 21 Selling 22 Administrative 23 Net Operating Income 24 25 Contribution Format Income Statement Ke Format =B4 =B6 =C17-C18 =B7+B10 =B8+B11 =SUM(B21:B22) =C19-C22 Ready BOU 100% u ENG Type here to search @ 10:45 ^ * IN 04-02-2020

Book1 - Microsoft Excel - O X Home Insert Page Layout Formulas Data Review View ABC as show/Hide Comment y Protect and Share Workbook Spelling Research Thesaurus Translate New Delete Previous Next Comment Comments Show All Comments Show Ink Allow Users to Edit Ranges Protect Protect Share Sheet Workbook Workbook Track Changes Changes Proofing B4 fic 12000 =B4 =B6 =C17-C18 =B7+B10 =B8+B11 =SUM(B21:B22) =C19-C22 16 Traditional format Income Statement 17 Sales 18 Cost of Goods sold 19 Gross margin 20 Selling and administrative expenses: 21 Selling 22 Administrative 23 Net Operating Income 24 25 Contribution Format Income Statement 26 Sales 27 Variable expenses: 28 Cost of goods sold 29 Variable selling 30 Variable administrative 31 Contribution Margin 32 Fixed expenses: 33 Fixed selling 34 Fixed administrative 35 Net Operating Income 36 =B4 =SUM(B28:B30) =C26-C30 =B10 =B11 =SUM(B33:B34) =C31-C34 38 39 40 K™ Format Ready Average: 56,200 Type here to search Count: 3 Sum: 518,600 BOU 100% M ENG IN 10:46 04-02-2020 W