ZuoTi.Pro
Question

Download the Applying Excel form and enter formulas in all cells that contain question markS. For example, in cell C18 enter the formulaB6. After entering formulas in all of the cells that contained question marks, verify that the dollar amounts in both the traditional and contribution format income statements match the numbers in Exhibit 1-7 Check your worksheet by changing the variable selling cost in the Data area to $900, keeping all of the other data the same as in Exhibit 1-7. If your worksheet is operating properly, the net operating income under the traditional format income statement and under the contribution format income statement should now be $700 and the contribution margin should now be $4,700. If you do not get these answers, find the errors in your worksheet and correct themTraditional Format Contribution Format Sales Cost of goods sold Gross margin Selling and administrative expenses $12,000 Sales $12,000 6,000 Variable expenses $6,000 600 400 6,000 Cost of goods sold Variable selling Variable administrative Selling Administrative $3,100 1,900 7,000 5,000 5,000 Contribution margin 1000 Fixed expenses: Net operating income Fixed selling Fixed administrative 2,500 1.500 4,000 1,000 Net operating income For a manufacturing company, the cost of goods sold would include some variable costs, such as direct materials, direct labor, and variable overhead, and some fixed costs, such as fixed manufacturing overhead. Income statement formats for manufacturing companies will be explored in greater detail in a subsequent chapter Beginning merchandise +Purchases merchandise inventory Ending Cost of goods sold inventory Beginning Ending Cost of goods = merchandise + Purchases-merchandise inventory $7,000 $3,000 inventory $4,000 = $6,000Chapter 1:Applying Exce Data Sales Variable costs $12,000 $6,000 $600 $400 Cost of goods sold Variable selling Variable administrative Fixed costs: $2,500 $1,500 Fixed selling Fixed administrative Enter a formula into each of the cells marked with a? below Exhibit 1-7 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

business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

1 Chapter 1: Applying Excel 3 Date 4 Sales 5 Variable Costs: 12,000.00 Cost of Goods Sold Variable Selling Variable Administrative 6,000.00 S 600.00 S 400.00 9 Fixed Costs: 10 Fixed Selling 11 Fixed Administrative 12 13 Exhibit 1-7 S 2,500.00 S 1,500.00 15 Traditional Format Income Statement 16 Sales 17 Cost of Goods Sold 18 Gross Margin 19 Selling and Administrative Expenses 20 Selling 21 Administrative 22 Net Operating Expenses 23 12,000.00 S 6,000.00 S 6,000.00 S 3,100.00 $ 1,900.00 5,000.00 S 1,000.00 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 12,000.00 6,000.00 S 600.00 S 400.00 7,000.00 S 5,000.00 S 2,500.00 S 1,500.00 4,000.00 S 1,000.00 37 391 Chapter 1: Applying Excel 3 Date 4 Sales 5 Variable Costs: 12000 Cost of Goods Sold Variable Selling Variable Administrative 6000 600 400 9 Fixed Costs: 10 Fixed Selling 11 Fixed Administrative 12 13 Exhibit 1-7 2500 1500 15 Traditional Format Income Statement 16 Sales 17 Cost of Goods Sold 18 Gross Margin 19 Selling and Administrative Expenses 20 Selling 21 Administrative 22 Net Operating Expenses 23 -B4 -B6 -C16-C17 B7+B10 B8+B11 B20+B21 -C18-C21 25 Contribution Format Income Statement 26 Sales 27 Variable Expenses: 28 Cost of Goods Sold 29 Vriable Selling 30 Variable Administrative 31 Contribution Margin 32 Fixed Expenses 33 Fixed Selling 34 Fixed Administrative 35 Net Operating Income 36 37 -B4 -B6 -B7 B8 SUM(B28 B30) -C26-C30 -B10 B11 -SUM(B33 B34) -C31-C34

0 0
Add a comment
Know the answer?
Add Answer to:
Download the Applying Excel form and enter formulas in all cells that contain question markS. For...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Help Seve & Ext Submit Required information Chapter 1: Applying Excel The Chapter 1 Form worksheet...

    Help Seve & Ext Submit Required information Chapter 1: Applying Excel The Chapter 1 Form worksheet is to be used to create your own worksheet version of Exhibit 1-7 in the text Chapter 1: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and enter formulas in all cells that contain question marks For example, in cell C18 enter the formula "-36". After entering formulas in all of the cells that contained question marks, verify that...

  • Chapter 1: Applying Excel Data Sales $12,000 Variable costs: Cost of goods sold $6,000 Variable selling...

    Chapter 1: 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-9 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...

  • Download the Applying Excel form and enter formulas in all cells that contain question marks. For...

    Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B13 enter the formula "= B5". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text. Check your worksheet by changing the fixed expenses to $270,000. If your worksheet is operating properly, the degree of operating leverage should be 10. If you do not get this answer, find...

  • Chapter 2: Applying Excel Data Sales $12,000 Variable costs: Cost of goods sold Variable selling $6,000...

    Chapter 2: Applying Excel Data Sales $12,000 Variable costs: Cost of goods sold Variable selling $6,000 $600 $400 Variable administrative Fixed costs: Fixed selling $2,500 $1,500 Fixed administrative Enter a formula into each of the cells marked with a ? below Exhibit 2-9 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...

  • $12,000 Sales Variable costs: Cost of goods sold Variable selling Variable administrative Fixed costs: Fixed selling...

    $12,000 Sales Variable costs: Cost of goods sold Variable selling Variable administrative Fixed costs: Fixed selling Fixed administrative $6,000 $600 $400 $2,500 $1,500 Enter a formula into each of the cells marked with a ? below Exhibit 2-9 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...

  • 1 Chapter 2: Applying Excel 3 Data 4 Sales 5 Variable costs: 6 Cost of goods...

    1 Chapter 2: Applying Excel 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 marked with a ? below 14 Exhibit 2-9 15 16 Traditional Format Income Statement 17 Sales 18 Cost of goods sold 19 Gross margin 20 Selling and administrative expenses $12,000 $6,000 $600 $400 $2,500 $1,500 S 12,000 6,000...

  • Complete the following Income Statement and Contribution Statement. Where ever there is a "?", a formula/number...

    Complete the following Income Statement and Contribution Statement. Where ever there is a "?", a formula/number needs to be entered. Sales Variable costs: $12,000 Cost of goods sold Variable selling Variable administrative $6,000 $600 $400 Fixed costs: Fixed selling Fixed administrative $2,500 $1,500 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...

  • For areas with “?” Please fill in with correct answer. Please include how you got that...

    For areas with “?” Please fill in with correct answer. Please include how you got that answer and the formulas used. 1 Chapter 2: Applying Excel 2 3 Data 4 Sales 5 Variable costs: $12,000 6 Cost of goods sold 7 Variable selling 8 Variable administrative $6,000 $600 $400 9 Fixed costs: 10 Fixed selling 11 Fixed administrative 12 13 Enter a formula into each of the cells marked with a ? below 14 Exhibit 2-9 15 $2,500 $1,500 16...

  • Download the Applying Excel form and enter formulas in all cells that contain question marks. For...

    Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B26 enter the formula “= B4*B8”. Note that the worksheet contains a section at the bottom titled “Determine the Product Margin Under a Traditional Cost System” that is not in the Review Problem. In this section, it is assumed that the traditional costing system allocates manufacturing overhead on the basis of the number of units produced. When completed, that part of...

  • 5. value: 3.00 points Exercise 2-6 Traditional and Contribution Format Income Statements [LO2-6] Cherokee Inc. is...

    5. value: 3.00 points Exercise 2-6 Traditional and Contribution Format Income Statements [LO2-6] Cherokee Inc. is a merchandiser that provided the following information: Ꮎ Ꮎ Ꮎ Number of units sold Selling price per unit Variable selling expense per unit Variable administrative expense per unit Total fixed selling expense Total fixed administrative expense Beginning merchandise inventory Ending merchandise inventory Merchandise purchases 12.000 17.00 1.00 1.50 20.000 16,000 8,000 25,000 87,000 $ $ $ $ Required: 1. Prepare a traditional income statement....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT