Chapter $6$: Applying Excel: Exercise $($Algo$)($Part $2$ of $2)$

$2.$ 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,,,$],[\backslash$table$[[2],[3]]],[3,$Data,,,$],[4,$Selling price per unit,,$349,],[$Manufacturing costs:$],[\backslash$table$[[6],[7]],$Variable per unit produced:,,,$],[$Direct materials,,$156,],[\backslash$table$[[8],[9]],$Direct labor,$-,58,],[$Variable manufacturing overhead,,$36,],[10,$Fixed manufacturing overhead per year,,$$,150,000,],[\backslash$table$[[11],[12]],$Selling and administrative expenses:,,,$],[$Variable per unit sold,,$$,],[\backslash$table$[[13],[14],[15]],$Fixed per year,,$60,000,],[,,,],[,,$Year $1,$Year $2],[\backslash$table$[[16],[17]],$Units in beginning inventory,,$0,],[18,$Units produced during the year,,$3,000,2,500],[$Units sold during the year,,$2,700,2,700]]$

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 costinq$?($Loss amounts should be indicated with a minus sign.$)$

Prev

$2$

of $2$

Next