1. Use the data below.
2. Directions: Calculate cost of goods manufactured and cost of goods sold expense using T-accounts.
3. Prepare an Excel spreadsheet. Use formulas and cell references.

PLEASE EXPLAIN WHAT MATH YOU USED TO GET YOUR ANSWER SO I CAN UNDERSTAND

DATA for the current month of Jan 19xx:

	Beginning	Ending
Materials Inv.	$174,750	$152,030
WIP Inventory	$118,830	$103,380
Finished Goods Inv.	$89,120	$104,900
Other manufactruing costs:
Direct labor for April	$314,550
Materials purchased in April	$335,520
Factory overhead incurred in April	$80,380