Chapter 2: Applying Excel
Data
Sales $12,000
Variable costs:
Cost of goods sold $6,000
Variable selling $600
Variable administrative $400
Fixed costs:
Fixed selling $2,500
Fixed administrative $1,500
Enter a formula into each of the cells marked with a ? below
Exhibit 2-12
Traditional Format Income Statement
Sales ?
Cost of goods sold ?
Gross margin ?
Selling and administrative expenses:
Selling ?
Administrative ? ?
Net operating income ?
Contribution Format Income Statement
Sales ?
Variable expenses:
Cost of goods sold ?
Variable selling ?
Variable administration ? ?
Contribution margin ?
Fixed expenses:
Fixed selling ?
Fixed administrative ? ?
Net operating income ?
Chapter 2: Applying Excel
Data
Sales $12,000
Variable costs:
Cost of goods sold $6,000
Variable selling $600
Variable administrative $400
Fixed costs:
Fixed selling $2,500
Fixed administrative $1,500
Enter a formula into each of the cells marked with a ? below
Exhibit 2-12
Traditional Format Income Statement
Sales 12,000$
Cost of goods sold 6,000
Gross margin 6,000
Selling and administrative expenses:
Selling 3,100$
Administrative 1,900 5,000
Net operating income 1,000$
Contribution Format Income Statement
Sales 12,000$
Variable expenses:
Cost of goods sold 6,000$
Variable selling 600
Variable administration 400 7,000
Contribution margin 5,000
Fixed expenses:
Fixed selling 2,500
Fixed administrative 1,500 4,000
Net operating income 1,000$
Chapter 2: Applying Excel
Data
Sales 12000
Variable costs:
Cost of goods sold 6000
Variable selling 600
Variable administrative 400
Fixed costs:
Fixed selling 2500
Fixed administrative 1500
Enter a formula into each of the cells marked with a ? below
Exhibit 2-12
Traditional Format Income Statement
Sales =B4
Cost of goods sold =B6
Gross margin =C17-C18
Selling and administrative expenses:
Selling =B7+B10
Administrative =B8+B11 =B21+B22
Net operating income =C19-C22
Contribution Format Income Statement
Sales =B4
Variable expenses:
Cost of goods sold =B6
Variable selling =B7
Variable administration =B8 =SUM(B28:B30)
Contribution margin =C26-C30
Fixed expenses:
Fixed selling =B10
Fixed administrative =B11 =SUM(B33:B34)
Net operating income =C31-C34
Chapter 2: Applying Excel
Data
Sales $12,000
Variable costs:
Cost of goods sold $6,000
Variable selling $900
Variable administrative $400
Fixed costs:
Fixed selling $2,500
Fixed administrative $1,500
Enter a formula into each of the cells marked with a ? below
Exhibit 2-12
Traditional Format Income Statement
Sales 12,000$
Cost of goods sold 6,000
Gross margin 6,000
Selling and administrative expenses:
Selling 3,400$
Administrative 1,900 5,300
Net operating income 700$
Contribution Format Income Statement
Sales 12,000$
Variable expenses:
Cost of goods sold 6,000$
Variable selling 900
Variable administration 400 7,300
Contribution margin 4,700
Fixed expenses:
Fixed selling 2,500
Fixed administrative 1,500 4,000
Net operating income 700$
Chapter 2: Applying Excel
Data
Sales $13,200
Variable costs:
Cost of goods sold $6,600
Variable selling $990
Variable administrative $440
Fixed costs:
Fixed selling $2,500
Fixed administrative $1,500
Enter a formula into each of the cells marked with a ? below
Exhibit 2-12
Traditional Format Income Statement
Sales 13,200$
Cost of goods sold 6,600
Gross margin 6,600
Selling and administrative expenses:
Selling 3,490$
Administrative 1,940 5,430
Net operating income 1,170$
Contribution Format Income Statement
Sales 13,200$
Variable expenses:
Cost of goods sold 6,600$
Variable selling 990
Variable administration 440 8,030
Contribution margin 5,170
Fixed expenses:
Fixed selling 2,500
Fixed administrative 1,500 4,000
Net operating income 1,170$
Chapter 2: Applying Excel
Data
Sales $12,000
Variable costs:
Cost of goods sold $6,000
Variable selling $600
Variable administrative $400
Fixed costs:
Fixed selling $2,500
Fixed administrative $1,500
Enter a formula into each of the cells marked with a ? below
Exhibit 2-12
Traditional Format Income Statement
Sales 12,000$
Cost of goods sold 6,000
Gross margin 6,000
Selling and administrative expenses:
Selling 3,100$
Administrative 1,900 5,000
Net operating income 1,000$
Contribution Format Income Statement
Sales 12,000$
Variable expenses:
Cost of goods sold 6,000$
Variable selling 600
Variable administration 400 7,000
Contribution margin 5,000
Fixed expenses:
Fixed selling 2,500
Fixed administrative 1,500 4,000
Net operating income 1,000$