50.1K

Verified Solution

Link Copied!

Change all of the numbers in the data area of your worksheet so that it looks like this:

$\backslash$table$[[,$A$,$B$,$C$],[1,$Chapter $6$: Applying Excel,,$],[2,,,],[3,$Data,,$],[4,$Selling price per unit,$277,],[5,$Manufacturing costs:,,$],[6,$Variable per unit produced:,,$],[7,$Direct materials,$121,],[8,$Direct labor,$51,],[9,$Variable manufacturing overhead,$31,],[10,$Fixed manufacturing overhead per year,$91,200,],[11,$Selling and administrative expenses:,,$],[12,$Variable per unit sold,$$,],[13,$Fixed per year,$39,000,],[14,,,],[15,,$Year $1,$Year $2],[16,$Units in beginning inventory,$0,],[17,$Units produced during the year,$2,400,1,900],[18,$Units sold during the year,$2,100,2,100]]$

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? $($Loss amounts should

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

Change all of the numbers in the data area of your worksheet so that it looks like this:

$\backslash$table$[[,$A$,$B$,$C$],[1,$Chapter $6$: Applying Excel,,$],[2],[3,$Data,,$],[4,$Selling price per unit,$277,],[5,$Manufacturing costs:,,$],[6,$Variable per unit produced:,,$],[7,$Direct materials,$121,],[8,$Direct labor,$51,],[9,$Variable manufacturing overhead,$31,],[10,$Fixed manufacturing overhead per year,$91,200,],[11,$Selling and administrative expenses:,,$],[12,$Variable per unit sold,$$,],[13,$Fixed per year,$39,000,],[\frac{14}{14}$

Answer & Explanation Solved by verified expert

See Answer