Please use excel to create a Schedule of Cost of Goods Manufactured below using the following date; Beginning raw materials inventory Beginning work-in-process inventory Beginning finished goods inventory Raw Materials Purchased Wages Paid Applied Manufacturing Overhead Ending raw materials inventory Ending work-in-process inventory Ending finished goods inventory 40,000 70,000 250,000 285,000 155,000 450,000 50,000 100,000 225,000

Please use excel to create a Schedule of Cost of Goods Manufactured below using the following date; Beginning raw materials inventory Beginning work-in-process inventory Beginning finished goods inventory Raw Materials Purchased Wages Paid Applied Manufacturing Overhead Ending raw materials inventory Ending work-in-process inventory Ending finished goods inventory 40,000 70,000 250,000 285,000 155,000 450,000 50,000 100,000 225,000

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter2: Accounting For Materials

Section: Chapter Questions

Problem 10E

See similar textbooks

Similar questions

From beginning to end, place these items in the order of the flow of goods. A. cost of goods sold B. raw materials inventory C. finished goods inventory D. work in process inventory
Refer to the data in Problem 6.31. Assume that the FIFO method is used. Required: 1. Prepare a physical flow schedule. 2. Calculate equivalent units of production for direct materials and conversion costs. 3. Compute unit cost. Round to three decimal places. 4. Calculate the cost of goods transferred to Painting at the end of the month. Calculate the cost of ending inventory.
Which document lists the inventory that will be removed from the raw materials inventory? A. job cost sheet B. purchase order C. materials requisition form D. receiving document
Given the following information, prepare a production report with materials added at the beginning and ending work in process inventory being 80% complete with regard to conversion costs.
Cost of materials issuances under the FIFO method An incomplete subsidiary ledger of materials inventory for May is as follows: A. Complete the materials issuances and balances for the materials subsidiary ledger under FIFO. B. Determine the materials inventory balance at the end of May. C. Journalize the summary entry to transfer materials to work in process. D. Explain how the materials ledger might be used as an aid in maintaining inventory quantities on hand.
Complete the information in the cost computations shown here: Raw materials Beginning inventory Purchases Materials available for use Ending inventory Materials used in production Work in process inventory Beginning inventory Materials used in production Direct labor Overhead applied Manufacturing costs incurred Ending inventory Cost of goods manufactured Finished goods inventory Beginning inventory Cost of goods manufactured Goods available for sale Ending inventory Cost of goods sold $341 1,533 323 $931 1,536 $22,450 936 $25,008 $21,792
Use the included information about Raw Materials Inventory (RM), Work in Process Inventory (WIP), Finished Goods Inventory (FG), and the Income Summary (IS). Determine the total conversion costs added. 1 2 3 4 5 6 7 1 00 RM B Bal T1 T2 T3 T4 E Bal 8 9 FG 10 B Bal 11 T1 12 T2 13 T3 14 T4 15 E Bal 2 Debits 4300 29 050 Debits 4800 45 592 3 Credits 28 000 Credits 33 500 4 5 WIP B Bal DM DL FOH CGM E Bal IS Rev CGS V Op Exp F Op Exp NIBT 6 Debits 8920 28 000 17 430 11 130 Debits 33 500 5130 7960 7 Credits 45 592 Credits 66 200
n the Raw Materials Inventory T-account, insert amounts for beginning and ending balances along with purchases and indirect materials used. Solve for direct materials used in the period. Compute the cost of direct labor used for the period. In the Work in Process Inventory T-account, insert amounts for beginning and ending balances along with direct materials used (from part 1), direct labor used (from part 2), and applied overhead. Solve for cost of goods manufactured in the period. In the Finished Goods Inventory T-account, insert amounts for beginning and ending balances along with cost of goods manufactured (from part 3). Solve for cost of goods sold in the period (do not consider any under- or overapplied overhead). In the Factory Overhead T-account, insert amounts for indirect materials used, indirect labor used, other overhead costs, and applied overhead. Solve for underapplied or overapplied overhead.
Use the following data to calculate the cost of goods sold for the period: Beginning Raw Materials Inventory Ending Raw Materials Inventory Beginning Work in Process Inventory Ending Work in Process Inventory Beginning Finished Goods Inventory Ending Finished Goods Inventory Cost of Goods Manufactured for the period $290,800. $250,800. $246,800. $242,800. $258,800. $ 30,800 70,800 40,800 46,800 72,800 68,800 246,800
Compute cost of goods sold using the following information. Finished goods inventory, beginning Work in process inventory, beginning Work in process inventory, ending Cost of goods manufactured Finished goods inventory, ending Cost of Goods Sold is Computed as: Cost of goods sold $ 374,000 86,500 77,100 932,800 334,000 Min
Use the following data to calculate the cost of goods sold for the period: Beginning Raw Materials Inventory Ending Raw Materials Inventory Beginning Work in Process Inventory Ending Work in Process Inventory Beginning Finished Goods Inventory Ending Finished Goods Inventory Cost of Goods Manufactured for the period Multiple Choice O $258,900. O $242,900 $290,900. $250,900. $246,900. $ 30,900 70,900 40,900 46,900 72,900 68,900 246,900
Compute ending work in process inventory for a manufacturer using the following information. Raw materials purchased Direct materials used Direct labor used Factory overhead Work in process inventory, beginning Cost of goods manufactured Ending Work in Process Inventory is Computed as: Work in process inventory, beginning Total manufacturing costs Total cost of work in process Work in process inventory, ending $ 128,800 72,800 58,000 99,900 26,800 234,000