I'm trying to prepare a production cost report and my numbers aren't adding up. I think my WIP calculations are incorrect.

E2-6 A job cost sheet of Battle Company is given below. JOB NO. ITEM FOR Date 7/10 12 15 22 24 27 31 469 White Lion Cages Tesla Company Job Cost Sheet Quantity Date Requested Date Completed Direct Materials $ 828 900 2,000 7/2 7/31 Direct Labor $ Manufacturing Overhead 440 380 $ 528 456 1.2 1.2 648 1,632 1.2 1,600 1,500 $ Cost of completed job: 4,828 Direct materials Direct labor Manufacturing overhead Total cost Unit cost $ 540 1,360 $ $ $ $ 4,828 1,360 1,632 7,820 3.91 Instructions (a) Answer the following questions. (1) What are the source documents for direct materials, direct labor, and manufacturing overhead costs assigned to this job? The source documents are materials requisition slips, labor time sheets, and predetermined overhead rates. (2) What is the predetermined manufacturing overhead rate? The predetermined manufacturing overhead rate is 1.2 or 120%. (3) What are the total cost and the unit cost of the completed job? The total cost of the job is $7,820 and the unit cost is $3.91. (b) Prepare the entry to record the completion of the job. 7/31 Finished Goods Inventory 7,820 Work in Process Inventory (To record completion of Job No. 469) 7,820 E2-9 At May 31, 2005, the accounts of Yellow Knife Manufacturing Company show the following. 1. May 1 inventoriesfinished goods $12,600, work in process $14,700, and raw materials $8,200. 2. May 31 inventoriesfinished goods $11,500, work in process $17,900, and raw materials $7,100. 3. Debit postings to work in process were: direct materials $62,400, direct labor $32,000, and manufacturing overhead applied $48,000. 4. Sales totaled $200,000. Instructions (a) Prepare a condensed cost of goods manufactured schedule. Yellow Knife Manufacturing Cost of Goods Manufactured Schedule For the Month Ended May 31, 2005 Work in process, May 1 Direct materials used Direct labor Manufacturing overhead applied Total manufacturing costs Total cost of work in process Less: Work in process, May 31 Cost of goods manufactured 14,700 62,400 32,000 48,000 142,400 157,100 17,900 139,200 (b) Prepare an income statement for May through gross profit. Yellow Knife Manufacturing Income Statement (Partial) For the Month Ended May 31, 2005 Sales Costs of goods sold Finished goods inventory, May 1 Cost of goods manufactured Cost of goods available for sale Less: Finished goods inventory, May 31 Cost of goods sold Gross Profit 200,000 12,600 139,200 151,800 11,500 140,300 59,700 (c) Indicate the balance sheet presentation of the manufacturing inventories at May 31, 2005. Yellow Knife Manufacturing Balance Sheet (Partial) May 31, 2005 Inventories Finished goods Work in Process Raw materials 11,500 17,900 7,100 36,500 E3-5 The Sanding Department of Han Furniture Company has the following production and manufacturing cost data for April 2005. Production: 12,000 units finished and transferred out; 3,000 units started that are 100% complete as to materials and 40% complete as to conversion costs. Manufacturing costs: Materials: $36,000.0 labor: $30,000 overhead: $37,320 Instructions Prepare a production cost report. There is no beginning work in process. 67320 26928 Physical Units Units accounted for Completed and transferred out Work in process, April 30 Total units 12,000 3,000 15,000 Materials 100% 40% Equivalent Units Conversion Costs Work in Process, Apr 1 Units started into production during APR 0 15,000 15,000 0 15,000 15,000 100% Units transferred out Work in process, April 30 Direct Materials: 3,000x100% Conversion costs: 3,000x40% Total equivalent units 12,000 12,000 100% Work in process, April 30 Direct materials cost Total materials cost 26,928 36,000 62,928 3,000 15,000 total materials cost/total equivalent units labor overhead total conversion cost 1,200 13,200 100% 40% 2.40 30,000 37,320 67,320 Total conversion cost/total equivalent units: 5.10 total manufacturing cost per unit: 7.50 Cost Reconciliation Schedule Costs accounted for Transferred out (12,000 x 7.5) Work in process, April 30 Materials (15,000 x 2.4) Conversion costs (13,200 x 5.1) Total costs 90,000 36,000 67,320 193,320 Han Furniture Company - Sanding Department Production Cost Report For the Month Ended April 30, 2005 Equivalent Units QUANTITIES Units to be accounted for Work in process, Apr 1 Started into production Total units Units accounted for Transferred out Work in process, Apr 30 Total units COSTS Unit costs Costs in April Equivalent Units Unit costs Costs to be accounted for Work in Process, Apr 1 Started into production Total costs Cost Reconciliation Schedule Costs accounted for Transferred out (12,000 x 7.50) Work in process, Apr 30 Materials Conversion costs Total costs Physical Units Materials Conversion Costs 0 15,000 15,000 12,000 3,000 15,000 12,000 3,000 15,000 12,000 1,200 13,200 36,000 15,000 2.40 67,320 13,200 5.10 103,320 7.50 0 103,320 103,320 90,000 36,000 67,320 103,320