Select cell A$8.$

Enter a nested IF statement comparing the total of all cells in the debit column of the Raw Materials Inventory account with the total of all cells in the credit column of the Raw Materials T$-$account which returns either the ending debit balance in the T$-$account, or $$ if the ending balance is not a debit.$$ Formula must use SUM four times.

Select cell B$8.$

Enter a nested IF statement comparing the total of all cells in the credit column of the Raw Materials Inventory account with the total of all cells in the debit column of the Raw Materials T$-$account which returns either the ending credit balance in the T$-$account, or $$ if the ending balance is not a credit. Formula must use SUM four times.

Copy the formulas in cells A$8$ through B$8$ to the remaining T$-$accounts, cells D$8$:E$8,$ A$14$:B$14,$ D$14$:E$14,$ and A$20$:B$20.$

Determine the amount of Direct Materials used.

Select cell E$23$ and enter a formula for Direct Materials used in the current period.

Determine the amount of Indirect Materials used.

Select cell E$24$ and enter a formula for the amount of Indirect Materials used in the current period.

Determine the amount of Direct Labor used.

Select cell E$25$ and enter a formula for Direct Labor used in the current period.

Determine the amount of Indirect Labor used.

Select cell E$26$ and enter a formula for Indirect Labor used in the current period.

Determine the Cost of Goods Manufactured.

Select cell E$27$ and enter a formula for Cost of Goods Manufactured in the current period.

Determine the Cost of Goods Sold $($ignoring the amount of any over$-$ or underapplied overhead$).$

Select cell E$28$ and enter a formula for Cost of Goods Sold in the current period.

Determine the amount of Actual Overhead Incurred.

Select cell E$29$ and enter a formula for Actual Overhead Incurred in the current period.

Determine the amount of Overhead Applied.

Select cell E$30$ and enter a formula for the amount of Overhead Applied in the current period.

Determine the amount of Over$-$ or Under$-$Applied Overhead.

Select cell E$31$ and enter a formula for the amount of Over$-$ or Under$-$Applied Overhead in the current period. Formula must return a positive value.

Determine if Overhead is Over$-$ or Under$-$Applied.

Select cell E$32.$

Click the Logical button $[$Formulas tab$/$Functional Library group$]$

Select IF in the list to open the Function Arguments dialog box.

Logical$\_$test: Must reference cells E$29$ and E$30$ and include $$ or $>.$

Determine the overhead application rate assuming overhead is applied as a function of direct labor cost.

Select cell E$33.$

Using only cells E$23$ through E$32,$ enter a formula for the overhead application rate.

Determine the Cost of Goods Sold after the amount of any over$-$ or underapplied overhead is closed.

Select cell E$34$

Using only cells E$23$ through E$33$ and enter a formula for Cost of Goods Sold in the current period. I NEED THE FORMULAS PLEASE