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,,,$],[2],[3,$Data,,,$],[4,$Selling price per unit,$$,293,],[5,$Manufacturing costs:,,.,$],[6,$Variable per unit produced:,,,$],[7,$Direct materials,$$,136,],[8,$Direct labor,$$,77,],[9,$Variable manufacturing overhead,$$,\mathrm{.}24,],[10,$Fixed manufacturing overhead per year,$$,87,400,],[11,$Selling and administrative expenses:,,,$],[12,$Variable per unit sold,$$,4,],[13,$Fixed per year,$$,35,000,],[14],[15,$&$,,$ear $1,$Year $2],[16,$Units in beginning inventory,,$0,],[17,$Units produced during the year,,$2,300,1,900],[18,$Units sold during the year,,$2,000,2,000]]$