Question

Calculate cost of goods manufactured and cost of goods sold expense using T-accounts. Prepare an Excel...

Calculate cost of goods manufactured and cost of goods sold expense using T-accounts. Prepare an Excel spreadsheet. Refer back to Excel spreadsheet in Ch. 18 Study Materials. Use formulas and cell references. Be sure to view the Excel formulas in that file. Use Excel formulas when appropriate. Submit through Canvas Assignments. DATA for the current month of April 2018: Beginning Ending Materials Inv. $174,750 $152,030 WIP Inventory $118,830 $103,380 Finished Goods Inv. $89,120 $104,900 Other manufactruing costs: Direct labor for April $314,550 Materials purchased in April $335,520 Factory overhead incurred in April $80,380

Homework Answers

Answer #1

Cost of goods manufactured and cost of goods sold expense using T-accounts are as prepared below:

Raw Material Inventory
Particulars Amount Particulars Amount
Beg inventory 174,750 Work in process inventory 358,240
Purchases 335,520
510,270 358,240
Ending balance 152,030
Work in process inventory
Particulars Amount Particulars Amount
Beg Balance 118,830 Cost of goods manufactured 768,620
Direct Material 358,240
Direct Labour 314,550
Factory Overhead 80,380
872,000 768,620
Ending balance 103,380
Finished goods inventory
Particulars Amount Particulars Amount
Beg Balance 89,120 Cost of goods sold 752,840
Cost of goods manufactured 768,620
857,740 752,840
Ending balance 104,900
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Cost of Goods Sold, Cost of Goods Manufactured Glenville Company has the following information for April:...
Cost of Goods Sold, Cost of Goods Manufactured Glenville Company has the following information for April: Cost of direct materials used in production $ 56,000 Direct labor 65,000 Factory overhead 34,000 Work in process inventory, April 1 41,000 Work in process inventory, April 30 37,000 Finished goods inventory, April 1 24,000 Finished goods inventory, April 30 19,000 a. For April, determine the cost of goods manufactured. Using the data given, prepare a statement of Cost of Goods Manufactured. Glenville Company...
Exercise 01-15 Schedule of cost of goods manufactured and cost of goods sold LO P1, P2...
Exercise 01-15 Schedule of cost of goods manufactured and cost of goods sold LO P1, P2 Beck Manufacturing reports the following information in T-account form for 2019. Raw Materials Inventory Begin. Inv. 10,800 Purchases 56,500 Avail. for use 67,300 DM used 52,500 End. Inv. 14,800 Work in Process Inventory Begin. Inv. 15,600 DM used 52,500 Direct labor 32,300 Overhead 63,000 Manuf. costs 163,400 Cost of goods manuf. 150,300 End. Inv. 13,100 Finished Goods Inventory Begin. Inv. 17,500 Cost of goods...
Cost of Goods Sold Budget The controller of Pueblo Ceramics Inc. wishes to prepare a cost...
Cost of Goods Sold Budget The controller of Pueblo Ceramics Inc. wishes to prepare a cost of goods sold budget for April. 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 April $30,750 $6,460 $119,930 $157,140 Estimated inventory, April 1 1,170 2,810 4,680 8,660 Desired inventory, April 30 2,930 2,670 7,030 12,630 Direct labor cost: Kiln Department Decorating Department Total Total direct labor...
Cost of Goods Sold, Cost of Goods Manufactured Timbuk 3 Company has the following information for...
Cost of Goods Sold, Cost of Goods Manufactured Timbuk 3 Company has the following information for March: Cost of direct materials used in production $44,000 Direct labor 52,000 Factory overhead 26,000 Work in process inventory, March 1 30,000 Work in process inventory, March 31 38,000 Finished goods inventory, March 1 29,000 Finished goods inventory, March 31 21,000 a. For March, determine the cost of goods manufactured. Using the data given, prepare a statement of Cost of Goods Manufactured. Timbuk 3...
Cost of Goods Sold, Cost of Goods Manufactured. PLEASE EXPLAIN AND BOLD ANSWERS Timbuk 3 Company...
Cost of Goods Sold, Cost of Goods Manufactured. PLEASE EXPLAIN AND BOLD ANSWERS Timbuk 3 Company has the following information for March: Cost of direct materials used in production $44,000 Direct labor 54,000 Factory overhead 28,000 Work in process inventory, March 1 32,000 Work in process inventory, March 31 31,600 Finished goods inventory, March 1 23,000 Finished goods inventory, March 31 15,000 a. For March, determine the cost of goods manufactured. Using the data given, prepare a statement of Cost...
Schedules of Cost of Goods Manufactured and Cost of Goods Sold; Income Statement Nish Corporation has...
Schedules of Cost of Goods Manufactured and Cost of Goods Sold; Income Statement Nish Corporation has provided the following data for the month of April: Sales ............................................... $220,000 Raw materials purchases ............... $50,000 Direct labor cost ............................ $23,000 Manufacturing overhead cost ........ $59,000 Selling expense .............................. $18,000 Administrative expense ................. $43,000 Inventories: Beginning Ending Raw materials ........ $26,000 $35,000 Work in the process ..... $18,000 $22,000 Finished goods ....... $42,000 $29,000 Required: a. Prepare a Schedule of Cost of Goods...
Using the below information from Pennington Corp., prepare a schedule of cost of goods manufactured and...
Using the below information from Pennington Corp., prepare a schedule of cost of goods manufactured and a schedule of cost of goods sold. Assume Pennington closed underapplied or overapplied Overhead to Cost of Goods Sold. Sales $500,000 Direct Labor $125,000 Raw Material Purchases $300,000 Selling Expense $ 30,000 Administrative Expenses $125,000 Man OH applied to WIP $145,000 Actual Man OH $150,000 Inventories:                     Beginning      Ending Raw Materials                   $15,000        $16,000 Work in Process                $25,000       $15,000 Finished Goods                  $10,000        $12,000
Prepare the 2017 schedule of cost of goods manufactured for Barton Company using the following information....
Prepare the 2017 schedule of cost of goods manufactured for Barton Company using the following information. Direct materials $ 232,500 Direct labor 71,000 Factory overhead costs 25,200 Work in process, Dec. 31, 2016 158,200 Work in process, Dec. 31, 2017 152,500 Barton Company Schedule of Cost of Goods Manufactured For Year Ended December 31, 2017 Direct materials $158,200 25,000 Direct labor Factory overhead costs Total manufacturing costs 183,200 Total cost of work in process 183,200 Less: Work in process, December...
From the following data, prepare a statement of cost of goods manufactured for the year ended...
From the following data, prepare a statement of cost of goods manufactured for the year ended June 30, 2019: Factory depreciation.................................................... $ 12,000   Direct materials issued............................................... $ 50,000 Direct labor...................................................................... $ 80,000 Indirect labor................................................................... $ 42,000   Sales salaries................................................................... $ 48,000 Factory supplies used.................................................. $   5,000   Factory utilities............................................................. $ 24,000 Factory property taxes............................................... $ 11,000   Work in process inventory on July 1, 2018........ $ 22,000 Work in process inventory on June 30, 2019.... $ 24,000   Finished goods inventory on July 1,...
Statement of Cost of Goods Manufactured for a Manufacturing Company Cost data for Sandusky Manufacturing Company...
Statement of Cost of Goods Manufactured for a Manufacturing Company Cost data for Sandusky Manufacturing Company for the month ended January 31 are as follows: Inventories January 1 January 31 Materials $154,750 $134,630 Work in process 105,230 91,550 Finished goods 78,920 90,200 Direct labor $278,550 Materials purchased during January 297,120 Factory overhead incurred during January: Indirect labor 29,710 Machinery depreciation 17,950 Heat, light, and power 6,190 Supplies 4,950 Property taxes 4,330 Miscellaneous costs 8,050 a. Prepare a cost of goods...