Please fill out this Excel sheet. Some of my answers might be incorrect; this is for managerial accounting.
SUNN COMPANY
For the year ended December 31, 2018
Raw materials inventory, beginning: $60,000
Raw materials purchases: $313,000
Raw materials available for use: $373,000
Less raw materials inventory, ending: $78,000
Sales: $1,630,000
Cost of goods sold
Finished goods inventory, beginning
Cost of goods manufactured
Goods available for sale
Less finished goods inventory, ending
Cost of goods sold
Gross profit
Selling expenses
Direct labor: $15,000
Total factory overhead: $1,114,000
Manufacturing costs incurred: $1,129,000
Cost of work in process, December 31, 2018
Total manufacturing cost: $295,000
Cost of goods sold: $250,000
Raw materials available for use: $16
Total cost of work in process: $17
Operating expenses: $18
Total manufacturing costs: $19
Net income: $84%
