Question

In: Accounting

Cost of Goods Sold Budget The controller of MingWare Ceramics Inc. wishes to prepare a cost...

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
$
$

Solutions

Expert Solution

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

Related Solutions

From the following details provided by Barry, Inc., prepare the cost of goods sold budget for...
From the following details provided by Barry, Inc., prepare the cost of goods sold budget for the year (complete the below table). Direct materials per unit                                                                          $65 Direct labor hours per unit                                                              2 hours Direct labor rate per hour                                                                         $50 Manufacturing overhead cost per direct labor hour                        $20 Beginning inventory units                                                                   1,000 Sales price per unit                                                                                  $250                                                                               First          Second             Third          Fourth                                                                        Quarter         Quarter         Quarter        Quarter Units expected to be sold:                         15,000           18,000           21,000           24,000            Barry, Inc. expects...
Prepare a Schedule of Cost of Goods Manufactured and a Schedule of Cost of Goods Sold...
Prepare a Schedule of Cost of Goods Manufactured and a Schedule of Cost of Goods Sold and Income Statement; this ie the jouranl entries Pre-determined manufacturing overhead rate = Total estimated manufacturing overheads / Estimated direct labor hours = = $3600/12 hours = $300 per direct labor hour Step 2: Cost Sheet Job # 1 Direct materials $ Table top 2000 Legs ($650 x 4) 2600 Drawer 0 4600 Direct labor cost @ $20 per hour (3x2x$30) 180 Manufacturing overheads...
Calculation of Cost of Goods Sold: Periodic Inventory System Prepare the cost of goods sold section...
Calculation of Cost of Goods Sold: Periodic Inventory System Prepare the cost of goods sold section for Adams Gift Shop. The following amounts are known: Beginning merchandise inventory $27,050 Ending merchandise inventory 22,550 Purchases 77,125 Purchases returns and allowances 4,055 Purchases discounts 5,745 Freight-in 230 Adams Gift Shop Cost of Goods Sold Cost of goods sold: $ $ $ $ $ Cost of goods sold $
1) Prepare a Cost of Goods Manufactured Statement and determine Cost of Goods Sold using the...
1) Prepare a Cost of Goods Manufactured Statement and determine Cost of Goods Sold using the following information: IF YOU DO NOT LABEL YOUR ANSWERS, YOU WILL NOT RECEIVE CREDIT Beginning Raw Materials Inventory $1,000 Beginning Work-In-Process Inventory $2,000 Beginning Finished Goods Inventory $3,000 Ending Raw Materials Inventory $1,500 Ending Work-In-Process Inventory $2,500 Ending Finished Goods Inventory $3,500 Raw Materials Purchases $1,250 Direct Labor $750 Factory Overhead $750 2) Prepare journal entries, if necessary, for the following as of the...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $119,000 $151,000 $190,000 Manufacturing costs 50,000 65,000 68,000 Selling and administrative expenses 42,000 45,000 72,000 Capital expenditures _ _ 46,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $129,000 $164,000 $213,000 Manufacturing costs 54,000 71,000 77,000 Selling and administrative expenses 37,000 44,000 47,000 Capital expenditures _ _ 51,000 The company expects to sell about 12% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the...
Cash Budget The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget...
Cash Budget The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: January February March Sales $89,000 $105,000 $144,000 Manufacturing costs 37,000 45,000 52,000 Selling and administrative expenses 26,000 28,000 32,000 Capital expenditures _ _ 35,000 The company expects to sell about 12% of its merchandise for cash. Of sales on account, 70% are expected to be collected in full in the month...
Cash Budget The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: March April May Sales $130,000 $155,000 $205,000 Manufacturing costs 55,000 67,000 74,000 Selling and administrative expenses 38,000 42,000 45,000 Capital expenditures _ _ 49,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $126,000 $160,000 $205,000 Manufacturing costs 53,000 69,000 74,000 Selling and administrative expenses 37,000 43,000 45,000 Capital expenditures _ _ 49,000 The company expects to sell about 15% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $120,000 $146,000 $197,000 Manufacturing costs 50,000 63,000 71,000 Selling and administrative expenses 35,000 39,000 43,000 Capital expenditures _ _ 47,000 The company expects to sell about 15% of its merchandise for cash. Of sales on account, 65% are expected to be collected in the month following the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT