In: Accounting
Cost of Goods Sold Budget
Delaware Chemical Company uses oil to produce two types of plastic products, P1 and P2. Delaware budgeted 28,200 barrels of oil for purchase in June for $76 per barrel. Direct labor budgeted in the chemical process was $235,800 for June. Factory overhead was budgeted at $385,800 during June. The inventories on June 1 were estimated to be:
Oil | $16,500 |
P1 | 11,100 |
P2 | 9,400 |
Work in process | 13,700 |
The desired inventories on June 30 were:
Oil | $18,200 |
P1 | 10,100 |
P2 | 9,000 |
Work in process | 14,100 |
Use the preceding information to prepare a cost of goods sold budget for June. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
Delaware Chemical Company | |||
Cost of Goods Sold Budget | |||
For the Month Ending June 30 | |||
Finished goods inventory, June 1 | $fill in the blank 2 | ||
Work in process inventory, June 1 | $fill in the blank 4 | ||
Direct materials: | |||
Direct materials inventory, June 1 | $fill in the blank 6 | ||
Direct materials purchases | fill in the blank 8 | ||
Cost of direct materials available for use | $fill in the blank 10 | ||
Direct materials inventory, June 30 | fill in the blank 12 | ||
Cost of direct materials placed in production | $fill in the blank 14 | ||
Direct labor | fill in the blank 16 | ||
Factory overhead | fill in the blank 18 | ||
Total manufacturing costs | fill in the blank 20 | ||
Total work in process during the period | $fill in the blank 22 | ||
Work in process inventory, June 30 | fill in the blank 24 | ||
Cost of goods manufactured | fill in the blank 26 | ||
Cost of finished goods available for sale | $fill in the blank 28 | ||
Finished goods inventory, June 30 | $fill in the blank 30 | ||
Cost of goods sold |
Cost of Goods Sold Budget | ||||
For the Month Ending June 30 | ||||
Finished goods inventory, June 1 | 20500 | =11100+9400 | ||
Work in process inventory, June 1 | 13700 | |||
Direct materials: | ||||
Direct materials inventory, June 1 | 16500 | |||
Direct materials purchases | 2143200 | =28200*76 | ||
Cost of direct materials available for use | 2159700 | |||
Direct materials inventory, June 30 | -18200 | |||
Cost of direct materials placed in production | 2141500 | |||
Direct labor | 235800 | |||
Factory Overhead | 385800 | |||
Total manufacturing costs | 2763100 | |||
Total work in process during the period | 2776800 | |||
Work in process inventory, June 30 | -14100 | |||
Cost of goods manufactured | 2762700 | |||
Cost of finished goods available for sale | 2783200 | |||
Finished goods inventory, June 30 | -19100 | =10100+9000 | ||
Cost of goods sold | 2764100 |