Question

In: Accounting

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 year 2,900 2,900

If your formulas are correct, you should get the correct answers to the following questions.

(a) What is the net operating income (loss) in Year 1 under absorption costing?

(b) What is the net operating income (loss) in Year 2 under absorption costing?

(c) What is the net operating income (loss) in Year 1 under variable costing?

(d) What is the net operating income (loss) in Year 2 under variable costing?

(e) The net operating income (loss) under absorption costing is less than the net operating income (loss) under variable costing in Year 2 because (You may select more than one answer.)

  • Units were left over from the previous year.unanswered
  • The cost of goods sold is always less under variable costing than under absorption costing.unanswered
  • Sales exceeded production so some of the fixed manufacturing overhead of the period was released from inventories under absorption costing.unanswered

3. Make a note of the absorption costing net operating income (loss) in Year 2.

  At the end of Year 1, the company’s board of directors set a target for Year 2 of the net operating income of $70,000 under absorption costing. If this target is met, a hefty bonus would be paid to the CEO of the company. Keeping everything else the same from part (2) above, change the units produced in Year 2 to 5,400 units.

(a) Would this change result in a bonus being paid to the CEO? Yes or No?

(b) What is the net operating income (loss) in Year 2 under absorption costing?

(c) Would this doubling of production in Year 2 be in the best interests of the company if sales are expected to continue to be 2,900 units per year? yes or no?

Solutions

Expert Solution

1)
Absorbtion Costing Income Statement
Units 2,900 2900
Year 1 Year 2
Revenue $     8,46,800.00 $   8,46,800.00
Less: Manufacturing costs
Direct materials $     3,62,500.00 $   3,62,500.00
Direct labor $     1,59,500.00 $   1,59,500.00
Variable manufacturing overhead $        66,700.00 $      66,700.00
Fixed manufacturing overhead per year $     1,56,600.00 $   1,82,600.00
Gross Profit $     1,01,500.00 $      75,500.00
Less: Selling and administrative expenses:
Variable selling and administrative exp. $        20,300.00 $      20,300.00
Fixed selling and administrative $        74,000.00 $      74,000.00
Net operating Income $          7,200.00 $     -18,800.00
Variable Costing Income Statement
Units 2,900 2,900
Year 1 Year 2
Revenue $     8,46,800.00 $   8,46,800.00
Less: Manufacturing costs
Direct materials $     3,62,500.00 $   3,62,500.00
Direct labor $     1,59,500.00 $   1,59,500.00
Variable manufacturing overhead $        66,700.00 $      66,700.00
Variable selling and administrative exp. $        20,300.00 $      20,300.00
Contribution Margin $     2,37,800.00 $   2,37,800.00
Fixed manufacturing overhead per year $     1,72,800.00 $   1,72,800.00
Fixed selling and administrative $        74,000.00 $      74,000.00
Net operating Income $         -9,000.00 $       -9,000.00
e) The net operating income (loss) under absorption costing is less than the net operating income (loss) under variable costing in Year 2 because (You may select more than one answer.)
Units were left over from the previous year.
The cost of goods sold is always less under variable costing than under absorption costing.
Sales exceeded production so some of the fixed manufacturing overhead of the period was released from inventories under absorption costing.
All are correct.


Related Solutions

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...
The company is considering a project involving the purchase of new equipment. Change the data area of your worksheet to match the following
A B C 1 2 3 4 5 6 7 8 9 10 11 12 13 Chapter 7: Applying Excel           Data     Example E     Cost of equipment needed $360,000   Working capital needed $30,000   Overhaul of equipment in four years $25,000   Salvage value of the equipment in five years $30,000   Annual revenues and costs:     Sales revenues $430,000   Cost of goods sold $245,000   Out-of-pocket operating costs...
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...
1. A six-sided die is weighted so that all even numbers have an equal chance of...
1. A six-sided die is weighted so that all even numbers have an equal chance of coming up when the die is rolled, all odd numbers have an equal chance of coming up, and each even number is three times as likely to come up as each odd number. This die is rolled once. What is the probability of rolling a 3? What is the probability of rolling a 6? What is the probability of rolling an even number? 2....
Here is the algorithm: 1. Assume that all numbers are prime from 2..n, so put them...
Here is the algorithm: 1. Assume that all numbers are prime from 2..n, so put them in the list (2 is the smallest number, so if n is less than 2, the list should be empty). 2. Make the first item be current. 3. Leave in the current item. Then, take out all of its multiples (since any multiple will have that number as a factor). 4. Make current be the next element in primes. 5. If there are no...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT