$2$ of $2$

Now change all of the dollar amounts in the data area of your worksheet so that it looks like this:

$\backslash$table$[[,$A$,$B$],[1,$Chapter $1$: Applying Excel,,,$],[2,,,,],[3,$Data,,,$],[4,$Sales,$$,92,000,],[5,$Variable costs:,$$,46,000,],[6,$Cost of goods sold,$$,4,600,],[7,$Variable selling,$$,4,400,],[8,$Variable administrative,,,$],[9,$Fixed costs:,$$,2,500,],[10,$Fixed selling,$$,1,500,],[11,$Fixed administrative,,,$]]$

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

a$.$ What is the gross margin now?

b$.$ What is the net operating income now?

c$.$ What is the contribution margin now?