Question

In: Accounting

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.

This Excel worksheet form is to be used to recreate Exhibit 1–7. The workbook, and instructions on how to complete the file, can be found in Connect.

Required:

1. 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 them.

How much is the gross margin? Did it change? Why or why not?

2. Suppose that sales are 10% higher as shown below:

 

Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . $13,200

Variable costs:

Cost of goods sold . . . . . . . . . . . . . $6,600

Variable selling . . . . . . . . . . . . . . . . $660

Variable administrative . . . . . . . . . $440

Fixed costs:

Fixed selling . . . . . . . . . . . . . . . . . . $2,500

Fixed administrative . . . . . . . . . . . . $1,500

 

Enter this new data into your worksheet. Make sure that you change all of the data that are different—not just the sales. Print or copy the income statements from your worksheet.

What happened to the variable costs and to the fixed costs when sales increased by 10%? Why? Did the contribution margin increase by 10%? Why or why not? Did the net operating income increase by 10%? Why or why not?

Solutions

Expert Solution

1. When the variable selling cost is changed to $900, the worksheet changes as show below:

The gross margin is $6,000; the same as it was before. It did not change because the variable selling expense is deducted after the gross margin, not before it on the traditional format income statement.

2. The new worksheet appears below:

The variable costs increased by 10% when the sales increased by 10%, however the fixed costs did not increase at all. By definition, total variable cost increases in proportion to activity whereas total fixed cost is constant. (In the real world, cost behavior may be messier.) The contribution margin also increased by 10%, from $5,000 to $5,500, because both of its components—sales and variable costs—increased by 10%. The net operating income increased by more than 10%, from $1,000 to $1,500, because even though sales and variable expenses increased by 10%, the fixed costs did not increase by 10%.


 

 

Related Solutions

1. Change all of the numbers in the data area of your worksheet so that it...
1. Change all of the numbers in the data area of your worksheet so that it looks like this: Data Selling price per unit $292 Manufacturing costs: Variable per unit produced: Direct materials $125 Direct labor $55 Variable manufacturing overhead $23 Fixed manufacturing overhead per year $172,800 Selling and administrative expenses: Variable per unit sold $7 Fixed per year $74,000 Year 1 Year 2 Units in beginning inventory 0 Units produced during the year 3,200 2,700 Units sold during the...
2. Change all of the numbers in the data area of your worksheet so that it...
2. Change all of the numbers in the data area of your worksheet so that it looks like this: A B C 1 2 3 4 5 6 7 Chapter 5: Applying Excel Data Unit sales 30,000 units Selling price per unit $30 per unit Variable expenses per unit $18 per unit Fixed expenses $288,000 If your formulas are correct, you should get the correct answers to the following questions. (a) What is the break-even in dollar sales? (b) What...
2. Change all of the numbers in the data area of your worksheet so that it...
2. Change all of the numbers in the data area of your worksheet so that it looks like this: A B C 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Chapter 4: Applying Excel Data Selling price per unit $334 Manufacturing costs: Variable per unit produced: Direct materials $135 Direct labor $54 Variable manufacturing overhead $26 Fixed manufacturing overhead per year $119,600 Selling and administrative expenses: Variable per unit sold...
2. Change all of the numbers in the data area of your worksheet so that it...
2. Change all of the numbers in the data area of your worksheet so that it looks like this: If your formulas are correct, you should get the correct answers to the following questions. A B C D 1 Chapter 5: Applying Excel 2 3 Data 4 Unit sales 80,000 units 5 Selling price per unit $20 per unit 6 Variable expenses per unit $14 per unit 7 Fixed expenses $384,000 8 (a) What is the break-even in dollar sales?...
2. Change all of the numbers in the data area of your worksheet so that it...
2. Change all of the numbers in the data area of your worksheet so that it looks like this: A B C D 1 Chapter 3: Applying Excel 2 3 Data 4 Unit sales 30,000 units 5 Selling price per unit $50 per unit 6 Variable expenses per unit $20 per unit 7 Fixed expenses $720,000 8 If your formulas are correct, you should get the correct answers to the following questions. (a) What is the break-even in dollar sales?...
2. Change all of the numbers in the data area of your worksheet so that it...
2. Change all of the numbers in the data area of your worksheet so that it looks like this: 3 Data 4 Selling price per unit $374 5 Manufacturing costs: 6   Variable per unit produced: 7     Direct materials $152 8     Direct labor $58 9     Variable manufacturing overhead $38 10   Fixed manufacturing overhead per year $166,400 11 Selling and administrative expenses: 12   Variable per unit sold $4 13   Fixed per year $98,000 14 15 Year 1 Year 2 16 Units in...
2. Change all of the numbers in the data area of your worksheet so that it...
2. Change all of the numbers in the data area of your worksheet so that it looks like this: 3 Data 4 Selling price per unit $374 5 Manufacturing costs: 6   Variable per unit produced: 7     Direct materials $152 8     Direct labor $58 9     Variable manufacturing overhead $38 10   Fixed manufacturing overhead per year $166,400 11 Selling and administrative expenses: 12   Variable per unit sold $4 13   Fixed per year $98,000 14 15 Year 1 Year 2 16 Units in...
2. Change all of the numbers in the data area of your worksheet so that it...
2. Change all of the numbers in the data area of your worksheet so that it looks like this: A B C 1 2 3 4 5 6 7 Chapter 5: Applying Excel Data Unit sales 50,000 units Selling price per unit $20 per unit Variable expenses per unit $14 per unit Fixed expenses $270,000 If your formulas are correct, you should get the correct answers to the following questions. (a) What is the break-even in dollar sales? (b) What...
1 If your variable cost per unit INCREASED, then your A selling price per unit would...
1 If your variable cost per unit INCREASED, then your A selling price per unit would decrease. B break-even units would decrease. C selling price per unit would increase. D break-even units would increase. 2 Which of the following explains the key difference between a traditional income statement and a contribution margin income statement? A Only the traditional income statement can correctly compute net income. B Only the contribution margin income statement can correctly compute net income. C Only the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT