Download the attached Excel File darr and complete each tab.

Tab INPUT $1$: Select the corresponding cost classification and category for each item

Tab INPUT $2$: Prepare a Statement of Cost of Goods Manufactured

Tab INPUT $3$: Prepare a Calculation of Cost of Goods Sold

For the numbers, you may use Excel formulas or type$-$in your numbers!

HINTS:

INPUT $1$: Factory Overhead is ALWAYS a PRODUCT cost, EXPENSES are ALWAYS PERIOD COSTS

The Statement of Cost of Goods Manufactured & calculation of Cost of Goods sold are listed in CH $18.$ An example is listed in last week's Overview & Hints under Modules

The calculation of Cost of Goods Sold is just portion of the income statement calculation. Below is a similar format however, you have a BEGINNING Inventory $($listed on the Excel file Instructions$)$:

Beginning Finished Goods Inventory

Cost of Goods Manufactured

Cost of Goods Available for Sale

Ending Finished Goods Inventory

Cost of Goods Sold

$\backslash$table$[[$$