Part $1$: Use the information in Part $1$ for STEM Company to complete a Cost of Goods Manufactured Statement and a Cost of Goods Sold Statement for the year ended $2025.$ All reports should be prepared in Excel with good form.

The following cost and inventory data were taken from the records of the STEM Company for the year $2025$: Costs incurred:

$\backslash$table$[[$Advertising Expense,$$,108,000,,],[$Depreciation$,$ factory equipment,,$36,000,,],[$Depreciation$,$ office equipment,,$84,000,,],[$Direct labor,,$96,000,,],[$Indirect labor,,$54,500,,],[$Maintenance$,$ factory equipment,,$20,000,,],[$Purchases of direct materials $($net$),,124,000,,],[$Rent$,$ factory building,,$84,000,,],[$Sales commissions,,$36,000,,],[$Supplies$,$ factory,,$1,800,,],[$Utilities$,$ factory,$$,9,600,,],[,,,,],[$Inventories:$,,,,],[,,$January $1,,$December $31],[$Direct materials,$$,9,900,$$$,12,100],[$Work in Process,,$6,600,,23,100],[$Finished Goods,$$,75,900,$$$,26,400]]$

Part $2$: Use only the information in Part $2$ to prepare a Contribution Margin Income Statement and a Gross Margin Income Statement for the month of July $2025.$ Assume the company produced and sold $15,000$ units and there were no units in inventory on July $1,2025.$ All reports should be prepared in Excel with good form.

The cost accountant for the STEM Company has provided you with the following information for the month of July:

$\backslash$table$[[,,],[,,$Variable Costs,$],[,,$Per unit,Total$],[$Direct labor,,$33\mathrm{.}00,],[$Direct materials Costs,,,$],[$manufacturing overhead,,$97\mathrm{.}46,],[$Marketing Costs,$17\mathrm{.}81,,],[$Administrative Costs,,$6\mathrm{.}36,132,000],[$Selling Price,$3\mathrm{.}34,60,000,],[,252,82,500,],[$Units produced and sold,,$15,000,]]$

Submission method: Please include all of your reports in the same excel file and upload your excel file to the assignments link on D$2$L$.$ Name the file Phaselfirstnamelastname.xls$.$ For example: PhaselEvelynMoney.xls$.$