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

Raw materials inventory Work in process inventory-Cutting Work in process inventory-Stitching Finished goods inventory Beginning Inventory $ 96,000 223,500 Ending Inventory $ 116,350 60,500 243,300 200,100 150,500 44,250 The following additional information describes the company's production activities for May. Direct materials Raw materials purchased on credit Direct materials used-Cutting Direct materials used-Stitching Direct labor Direct labor-Cutting Direct labor-Stitching Factory Overhead (Actual costs) Indirect materials used Indirect labor used Other overhead costs Factory Overhead Rates Cutting Stitching Sales $ 115,000 26,250 $ 24,600 98,400 $ 68,400 58,600 65,000 (150% of direct materials used) (120% of direct labor used) $ 976,000 Requirement General Journal General Ledger Trial Balance Raw Materials Cost of Goods Mfg Cutting Cost of Goods Mfg Stitching Cost of Goods Sold Gross Profit Verify the ending balance in raw materials inventory. Materials used should be indicated…

A process manufacturer's first production department reports the following. Beginning work in process inventory Units started this period Conversion Costs added this period. Direct materials Conversion Total costs to account for Units 80,000 406,000 384,000 102,000 Completed and transferred out Ending work in process inventory The first production department reports the cost information below. Beginning work in process inventory Direct materials $184,444 1,327,279 885,242 Cost per equivalent unit of production: FIFO method Direct Materials Conversion Percent Complete 65% 46,359 $ 230,803 Equivalent units of production Cost per equivalent unit of production (rounded to 2 decimals) 858 2,212,521 $ 2,443,324 Percent Complete 35% Compute the department's costs per equivalent unit of production for both direct materials and conversion. Note: Round "Cost per EUP" to 2 decimal places. 358 Direct Materials Conversion

The following data show the units in beginning work in process inventory, the number of units started, the number of units transferred, and the percent completion of the ending work process for conversion. Given that materials are added at the beginning of the process. Beginning Quarter WIP Transferred Conversion (%) 134,350 133,550 25 522 132,593 132,515 24 337 133,245 133,432 20 487 134,845 134,032 23 What are the equivalent units for material and conversion costs for each quarter using the weighted-average method? Assume that the quarters are independent. Quarter 1 Quarter 2 Quarter 3 Quarter 4 1 2 3 4 - Started Out Units for material costs Units for conversion costs