In: Accounting
Cost of Goods Sold Budget
The controller of MingWare Ceramics Inc. wishes to prepare a cost of goods sold budget for September. The controller assembled the following information for constructing the cost of goods sold budget:
Direct materials: | Enamel | Paint | Porcelain | Total | ||||
Total direct materials purchases budgeted for September | $37,470 | $7,870 | $146,130 | $191,470 | ||||
Estimated inventory, September 1 | 2,380 | 5,710 | 9,520 | 17,610 | ||||
Desired inventory, September 30 | 2,670 | 2,430 | 6,410 | 11,510 | ||||
Direct labor cost: | Kiln Department | Decorating Department | Total | |||||
Total direct labor cost budgeted for September | $49,550 | $143,700 | $193,250 | |||||
Finished goods inventories: | Dish | Bowl | Figurine | Total | ||||
Estimated inventory, September 1 | $5,280 | $3,010 | $2,480 | $10,770 | ||||
Desired inventory, September 30 | 3,380 | 4,170 | 3,960 | 11,510 | ||||
Work in process inventories: | ||||||||
Estimated inventory, September 1 | $3,220 | |||||||
Desired inventory, September 30 | 1,800 | |||||||
Budgeted factory overhead costs for September: | ||||||||
Indirect factory wages | $74,300 | |||||||
Depreciation of plant and equipment | 10,640 | |||||||
Power and light | 4,720 | |||||||
Indirect materials | 3,310 | |||||||
Total | 92,970 |
Use the preceding information to prepare a cost of goods sold budget for September. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
MingWare Ceramics Inc. | |||
Cost of Goods Sold Budget | |||
For the Month Ending September 30 | |||
$ | |||
$ | |||
Direct materials: | |||
$ | |||
$ | |||
$ | |||
Direct labor | |||
$ | |||
Work in process inventory, September 30 | |||
$ | |||
$ |
Budgeted cost of goods sold | ||||||
Direct materials used: | ||||||
Beginning raw materials inventory | 17610 | |||||
Add:budgeted direct material purchase | 191470 | |||||
Total raw materials available | 209080 | |||||
Less: Ending raw materials inventory | 11510 | |||||
Direct materials used | 197570 | |||||
Direct labor | 193250 | |||||
Factory overhead | ||||||
Indirect factory wages | 74300 | |||||
Depreciation of plant and equipment | 10640 | |||||
Power and light | 4720 | |||||
Indirect materials | 3310 | |||||
Total manufacturing overhead | 92970 | |||||
Total manufacturing cost | 483790 | |||||
Add: Beginning work in process inventory | 3220 | |||||
487010 | ||||||
Les: Ending work in process inventory | 1800 | |||||
Cost of goods manufactured | 485210 | |||||
Add: beginning finished goods inventory | 10770 | |||||
Total goods available for sale | 495980 | |||||
Less:ending finished goods inventory | 11510 | |||||
Cost of goods sold | 484470 | |||||