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