Calculating ending work in process
I have calculated the following information and cannot recall how to calculate the ending work in process without knowing the number of units either sold or finished (ending).
Inventory balances: January 1
Beginning Ending
Raw materials $30,000 $70,000
Work in process $50,000
Finished goods $90,000
Total Inventory 170,000
Schedule of Cost of Goods Manufactured
For the Quarter Ended June 30
Direct Materials
Beg raw materials inventory $30,000
Add: Purchase of raw materials $420,000
Raw Materials Available $450,000
Deduct: Ending raw materials inventory $70,000
Raw Materials used in production $380,000
Direct Labor $130,000
Manufacturing overhead
Total Manufacturing Overhead cost $520,000
Total Manufacturing cost $1,030,000
Add: Beginning work in process inventory $50,000
$1,080,000
Deduct: Ending work in process inventory :confused:
Cost of goods manufactured $1,080,000
Income Statement
For the Quarter Ended June 30
Sales $1,350,000
Cost of goods sold:
Beginning finished goods inventory $90,000
Add: Cost of Goods Manufactured $870,000
Goods available for sale $960,000
Deduct: Ending goods Inventory $170,000 $790,000
Gross Margin $540,000 40% of sales
Selling and Administrative Expenses:
Selling expense unknown
Administrative expense unknown
Net Operating Income unknown