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$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$