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.

Data for the current month of June 2017:

	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