Using excel to compute the direct material purchased, cost of goods manufactured (COGM), and ending inventory of finished goods based on the following information for July:

Raw material account:

Beginning inventory: $1,000

Ending inventory: $300

Used: $900

Work-in-process:

Beginning inventory: $200

Direct labor: $2,000

Overhead: $600

Ending inventory: $700

Finished Goods

Beginning inventory: $800

Cost of Goods Sold: $2,500