Please complete the following questions, please. provide spreadsheet.

\fEstimated D Manufacturing overhead Direct labor costs Direct labor hours Machine hours Department E K 1,050,000 1,500,000 840,000 1,500,000 1,412,500 508,500 113,000 125,000 45,200 452,000 565,000 120,000 Job cost sheet D Direct material Used Direct labor costs Manufacturing overhead cost incurr Direct labor hours Machine hours Department E K 158,200 142,380 135,600 124,300 111,870 140,120 9,040 12,430 38,420 50,850 88,140 42,375 89,270 3,955 10,400 Compute the predetermined overhead rate for each department. Department D Department E Department K Department D Department E Department K Department D Department E Department K 70.00% 12.00 per direct labor hour 7.00 per machine hour Manufacturing Cost 388,720 415,840 203,315 Manufacturing overhead 16950 Underapplied 9040 Overapplied 16470 Underapplied No i) ii) iii) Account Titles and Explanation Debit Raw Material Inventory Accounts Payable (To record purchase of raw materials) Factory Labor Cash (To record factory labor costs incurred) Manufacturing Overhead Accumulated Depreciation -Equipment Accounts Payable (To record manufacturing overhead costs incurred) Work in Process Inventory Manufacturing Overhead Raw Material Inventory (To record assignment of direct materials) Work in Process Inventory Manufacturing Overhead Factory Labor (To record assignment of factory labor) Work in Process Inventory Manufacturing Overhead (To record assignment of manufacturing overhead) Finished Good Inventory Work in Process Inventory (To record completion of jobs) Cash Sale (To record sale of goods) Cost of Good Sold Finished Good Inventory (To record the cost of goods sold) Credit 6101 6101 5478 5478 1370 872 498 6102 1868 7970 3984 1494 5478 4980 4980 17232 17232 23531 23531 17232 17232 b) 6/1 6/30 c) Balance DirectMaterial Direct Labor Overhead Applied Balance WORK IN PROCESS INVENTORY 6897 June 6102 3984 4980 4731 Completed Work Balance in Work in Process Inventory Cost of Unfinished Job : 4731 4731 Koss Working Beginning Work in Process DirectMaterial Direct Labor Manufacturing Overhead Total Cost of Good Sold Gannon Rosenthal Linton 1,643.00 2,508.00 1,370.00 623.00 1,046.00 448.00 1,307.50 560.00 5,366.50 4,139.00 17,232.00 2,746.00 1,619.00 1,494.00 1,867.50 7,726.50 17232 Koss 2,490.00 996.00 1,245.00 4,731.00 Total 6,897.00 6,102.00 3,984.00 4,980.00 21,963.00 No 1 2 3 4 5 6 7 8 9 Account Titles and Explanation Raw Material Inventory Accounts Payable Work in Process Inventory Manufacturing Overhead Raw Material Inventory Factory Labor Factory Wages Payable Employer Payroll Taxes Payable Work in Process Inventory Manufacturing Overhead Factory Labor Manufacturing Overhead Accounts Payable Depreciation Expenses Accumulated Depreciation-Building Work in Process Inventory Manufacturing Overhead Finished Good Inventory Work in Process Inventory Accounts Receivable Sale (To record the sale ) Cost of Good Sold Finished Good Inventory (To record the cost of the sale) Debit Credit 54460 54460 33530 6990 40520 58590 50280 8310 52050 6540 58590 84210 84210 8210 8210 78075 78075 90550 90550 107950 107950 79060 79060 Compute the manufacturing overhead rate for the year. Manufacturing overhead rate b) Manufacturing Overhead 2.20 per machine hour 4544 Underapplied Overehead c) Prepare the adjusting entry to assign the under or over-applied overhead for the year to cost of goods sold Account Title and Explanation Debit Credit Cost of Good Sold 4544 Manufacturing Overhead 4544 Working Manufacturing overhead rate Manufacturing overhead rate Manufacturing overhead rate Actual Manufacturing Overhead Manufacturing Overhead Applied Underapplied Overhead = Estimated Manufacturing Overhead/Estimated Machine Hour =277860/126300 2.20 296924 292380 4544 st of goods sold ted Machine Hour Case A Direct Material Used Direct Labor Manufacturing Overhead applied Total Manufacturing Cost Work in Process 1/1/14 Total Cost of Work in Process Work in Process 12/31/14 Cost of Good Manufactured Case B 60647 (a) 51300 41553 153500 55400 (b) 208900 10100 ( c) 198800 Working Manufacturing Overhead applied Percentage of Direct Labor Cost =41553/51300 Manufacturing Overhead applied Percentage of Direct Labor Cost 81.00% 85400 147700 119637 (d) 352737 (e) 19600 372337 (f) 15000 357337 (g) Case C 66000 85,193 (h) 69,007 (i) 220200 18800 239000 (j) 12400 (k) 226600 (a) Determine the cost of each job. Lynn Brian Mike 11090 12760 6320 (b) Indicate the balance of the Service Contracts in Process account at the end of November. Balance in service contracts in process account 11090 (c) Calculate the ending balance of the Operating Overhead account for November. Balance in operating overhead account 640 Working Lynn Direct materials Auditor labor costs Auditor hours Overhead Cost Applied Total Cost Brian Mike Total 710 6310 74 4070 500 7310 90 4950 270 3520 46 2530 11550 11090 12760 6320 30170 *Exercise 16-11 (Part Level Submission) The Polishing Department of Harbin Company has the following production and manufacturing cost data for September. Materials are entered at the beginning of the process. Production: Beginning inventory 1,800 units that are 100% complete as to materials and 30% complete as to conversion costs; units started during the period are 37,000; ending inventory of 6,300 units 10% complete as to conversion costs. Manufacturing costs: Beginning inventory costs, comprised of $20,650 of materials and $45,590 of conversion costs; materials costs added in Polishing during the month, $184,990; labor and overhead applied in Polishing during the month, $126,950 and $258,150, respectively. *(a) Compute the equivalent units of production for materials and conversion costs for the month of September. The equivalent units of production Materials Conversion Costs Attempts: 0 of 3 used *(b) The parts of this question must be completed in order. This part will be available when you complete the part above. *(c) The parts of this question must be completed in order. This part will be available when you complete the part above. Copyright 2000-2016 by John Wiley & Sons, Inc. or related companies. All rights reserved. *Exercise 16-6 The Cutting Department of Cassel Company has the following production and cost data for July. 1. 2. Production Costs Transferred out 12,800 units. Beginning work in process complete as to conversion Labor Started 4,700 units that are 60% costs and 100% complete as to materials at July 31. $0 Materials 59,500 Manufacturing overhead 19,790 14,574 Materials are entered at the beginning of the process. Conversion costs are incurred uniformly during the process. (a) Determine the equivalent units of production for (1) materials and (2) conversion costs. Total equivalent units of production Materials Conversion Costs (b) Compute unit costs. (Round unit costs to 2 decimal places, e.g. 2.25.) Materials $ Conversion costs $ Prepare a cost reconciliation schedule. Cost Reconciliation Costs accounted for Transferred out $ Work in process, July 31 Materials Conversion costs Total costs $ $ Question Attempts: 0 of 3 used Copyright 2000-2016 by John Wiley & Sons, Inc. or related companies. All rights reserved. Estimated D Manufacturing overhead Direct labor costs Direct labor hours Machine hours Department E K 1,050,000 1,500,000 840,000 1,500,000 1,412,500 508,500 113,000 125,000 45,200 452,000 565,000 120,000 Job cost sheet D Direct material Used Direct labor costs Manufacturing overhead cost incurre Direct labor hours Machine hours Department E K 158,200 142,380 135,600 124,300 111,870 140,120 9,040 12,430 38,420 50,850 Compute the predetermined overhead rate for each department. Department D Department E Department K Department D Department E Department K Department D Department E Department K 70.00% 12.00 per direct labor hour 7.00 per machine hour Manufacturing Cost 388,720 415,840 203,315 Manufacturing overhead 16950 Underapplied 9040 Overapplied 16470 Underapplied 88,140 42,375 89,270 3,955 10,400 No i) ii) iii) Account Titles and Explanation Debit Raw Material Inventory Accounts Payable (To record purchase of raw materials) Factory Labor Cash (To record factory labor costs incurred) Manufacturing Overhead Accumulated Depreciation -Equipment Accounts Payable (To record manufacturing overhead costs incurred) Work in Process Inventory Manufacturing Overhead Raw Material Inventory (To record assignment of direct materials) Work in Process Inventory Manufacturing Overhead Factory Labor (To record assignment of factory labor) Work in Process Inventory Manufacturing Overhead (To record assignment of manufacturing overhead) Finished Good Inventory Work in Process Inventory (To record completion of jobs) Cash Sale (To record sale of goods) Cost of Good Sold Finished Good Inventory (To record the cost of goods sold) Credit 6101 6101 5478 5478 1370 872 498 6102 1868 7970 3984 1494 5478 4980 4980 17232 17232 23531 23531 17232 17232 b) 6/1 6/30 Balance DirectMaterial Direct Labor Overhead Applied Balance WORK IN PROCESS INVENTORY 6897 June 6102 3984 4980 4731 Completed Work 17232 c) Balance in Work in Process Inventory Cost of Unfinished Job : Koss 4731 4731 d) Stellar Inc. Cost of Goods Manufactured Schedule For the Month Ended June 30, 2014 Work in process, June 1 Direct materials used 6102 Direct labor 3984 Manufacturing overhead applied 4980 Total Manufacturing Cost Total cost of work in process Less: Work in process, June 30 Cost of goods manufactured 6897 15066 21963 4731 17232 Working Beginning Work in Process DirectMaterial Direct Labor Manufacturing Overhead Gannon Rosenthal Linton 1,643.00 2,508.00 1,370.00 623.00 1,046.00 448.00 1,307.50 560.00 Koss 2,746.00 1,619.00 1,494.00 1,867.50 2,490.00 996.00 1,245.00 Total 6,897.00 6,102.00 3,984.00 4,980.00 Total Cost of Good Sold 5,366.50 17,232.00 4,139.00 7,726.50 4,731.00 21,963.00 No 1 2 3 4 5 6 7 8 9 Account Titles and Explanation Raw Material Inventory Accounts Payable Work in Process Inventory Manufacturing Overhead Raw Material Inventory Factory Labor Factory Wages Payable Employer Payroll Taxes Payable Work in Process Inventory Manufacturing Overhead Factory Labor Manufacturing Overhead Accounts Payable Depreciation Expenses Accumulated Depreciation-Building Work in Process Inventory Manufacturing Overhead Finished Good Inventory Work in Process Inventory Accounts Receivable Sale (To record the sale ) Cost of Good Sold Finished Good Inventory (To record the cost of the sale) Debit Credit 54460 54460 33530 6990 40520 58590 50280 8310 52050 6540 58590 84210 84210 8210 8210 78075 78075 90550 90550 107950 107950 79060 79060 Compute the manufacturing overhead rate for the year. Manufacturing overhead rate b) Manufacturing Overhead 2.20 per machine hour 4544 Underapplied Overehead c) Prepare the adjusting entry to assign the under or over-applied overhead for the year to cost of goods sold Account Title and Explanation Debit Credit Cost of Good Sold 4544 Manufacturing Overhead 4544 Working Manufacturing overhead rate Manufacturing overhead rate Manufacturing overhead rate Actual Manufacturing Overhead Manufacturing Overhead Applied Underapplied Overhead = Estimated Manufacturing Overhead/Estimated Machine Hour =277860/126300 2.20 296924 292380 4544 Case A Direct Material Used Direct Labor Manufacturing Overhead applied Total Manufacturing Cost Work in Process 1/1/14 Total Cost of Work in Process Work in Process 12/31/14 Cost of Good Manufactured Case B 60647 (a) 51300 41553 153500 55400 (b) 208900 10100 ( c) 198800 Working Manufacturing Overhead applied Percentage of Direct Labor Cost =41553/51300 Manufacturing Overhead applied Percentage of Direct Labor Cost 81.00% Case C 85400 147700 119637 (d) 352737 (e) 19600 372337 (f) 15000 357337 (g) 66000 85,193 (h) 69,007 (i) 220200 18800 239000 (j) 12400 (k) 226600 (a) Determine the cost of each job. Lynn Brian Mike 11090 12760 6320 (b) Indicate the balance of the Service Contracts in Process account at the end of November. Balance in service contracts in process account 11090 (c) Calculate the ending balance of the Operating Overhead account for November. Balance in operating overhead account 640 Working Lynn Direct materials Auditor labor costs Auditor hours Overhead Cost Applied Total Cost Brian Mike Total 710 6310 74 4070 500 7310 90 4950 270 3520 46 2530 11550 11090 12760 6320 30170 *Do It! Review 16-4 In March, Kelly Company had the following unit production costs: materials $11 and conversion costs $9. On March 1, it had zero work in process. During March, Kelly transferred out 28,680 units. As of March 31, 4,060 units that were 50% complete as to conversion costs and 100% complete as to materials were in ending work in process. (a) Compute the total units to be accounted for. Total units (b) Compute the equivalent units of production. The equivalent units of production Materials Conversion costs (c) Prepare a cost reconciliation schedule, including the costs of materials transferred out and the costs of materials in process. Cost Reconciliation Schedule Costs accounted for Transferred out $ Work in process, March 31 Materials Conversion costs Total costs $ $ Question Attempts: 0 of 3 used Copyright 2000-2016 by John Wiley & Sons, Inc. or related companies. All rights reserved. *Exercise 16-13 The Welding Department of Thorpe Company has the following production and manufacturing cost data for February 2014. All materials are added at the beginning of the process. Manufacturing Costs Beginning work in process Materials Conversion costs Materials $17,870 14,880 Labor Production Data $32,750 184,915 52,650 Overhead Beginning work in process 14,980 units, 1/10 complete Units started 46,470 Units transferred out Ending work in process 48,760 12,690 units, 1/5 complete 76,104 Prepare a production cost report for the Welding Department for the month of February. (Round unit costs to 2 decimal places, e.g. 2.25 and all other answers to 0 decimal places, e.g. 1,225.) Quantities Units to be accounted for Work in process, February 1 Started into production Physical Units THORPE MANUFACTURING COMPANY Welding Department Production Cost Report For the Month Ended February 28, 2014 Equivalent Units Conversion Materials Costs Total units Units accounted for Transferred out Work in process, February 28 Total units Costs Unit costs Total Costs Equivalent units Unit costs Costs to be accounted for Work in process, February 1 Started into production Total costs Cost Reconciliation Schedule Conversion Costs Materials Total $ $ $ $ $ $ $ $ Costs accounted for $ Transferred out Work in process, February 28 Materials Conversion costs Total costs $ $ Question Attempts: 0 of 3 used Copyright 2000-2016 by John Wiley & Sons, Inc. or related companies. All rights reserved. *Exercise 16-3 The ledger of Custer Company has the following work in process account. Work in ProcessPainting 5/1 Balance 3,730 5/31 Labor 3,830 5/31 5/31 5/31 Materials Overhead Balance 6,210 5/31 Transferred out ? 1,350 ? Production records show that there were 480 units in the beginning inventory, 30% complete, 1,580 units started, and 1,540 units transferred out. The beginning work in process had materials cost of $2,920 and conversion costs of $1,650. The units in ending inventory were 40% complete. Materials are entered at the beginning of the painting process. (a) How many units are in process at May 31? Work in process, May 31 units (b) What is the unit materials cost for May? (Round unit cost to 3 decimal places, e.g. 2.257.) The unit materials cost for May $ (c) What is the unit conversion cost for May? (Round unit cost to 3 decimal places, e.g. 2.257.) The unit conversion cost for May $ (a) What is the total cost of units transferred out in May? (Round answer to 0 decimal places, e.g. 1,225.) The total cost of units transferred out in May $ (b) What is the cost of the May 31 inventory? (Round answer to 0 decimal places, e.g. 1,225.) Work in process $ Copyright 2000-2016 by John Wiley & Sons, Inc. or related companies. All rights reserved. Question Attempts: 0 of 3 used *Exercise 16-4 Schrager Company has two production departments: Cutting and Assembly. July 1 inventories are Raw Materials $4,420, Work in ProcessCutting $3,590, work in ProcessAssembly $11,600, and Finished Goods $32,160. During July, the following transactions occurred. 1. Purchased $62,960 of raw materials on account. 3. Incurred $71,480 of manufacturing overhead; $42,970 was paid and the remainder is unpaid. 2. 4. 5. 6. 7. 8. 9. Incurred $61,710 of factory labor. (Credit Wages Payable.) Requisitioned materials for Cutting $16,450 and Assembly $9,470. Used factory labor for Cutting $34,070 and Assembly $27,640. Applied overhead at the rate of $20 per machine hour. Machine hours were Cutting 1,720 and Assembly 1,760. Transferred goods costing $68,790 from the Cutting Department to the Assembly Department. Transferred goods costing $135,250 from Assembly to Finished Goods. Sold goods costing $152,300 for $201,920 on account. Journalize the transactions. (Credit account titles are automatically indented when amount is entered. Do not indent manually.) No. Account Titles and Explanation 1. 2. 3. 4. 5. 6. Debit Credit 7. 8. 9. (To record the cost of goods sold.) (To record the sale.) Question Attempts: 0 of 3 used Copyright 2000-2016 by John Wiley & Sons, Inc. or related companies. All rights reserved. *Problem 16-3A (Part Level Submission) Seagren Industries Inc. manufactures in separate processes furniture for homes. In each process, materials are entered at the beginning, and conversion costs are incurred uniformly. Production and cost data for the first process in making two products in two different manufacturing plants are as follows. Cutting Department Plant 1 T12-Tables Production DataJuly Work in process units, July 1 Plant 2 C10-Chairs 0 Units started into production Work in process units, July 31 0 22,800 19,200 60 80 3,600 Work in process percent complete Cost DataJuly Work in process, July 1 600 $0 Materials $0 456,000 Labor 345,600 281,040 132,000 124,800 Overhead 116,040 $861,840 Total $593,640 *(a) For each plant: (1) Compute the physical units of production. Units to be accounted for T12 Tables C10 Chairs (2) Compute equivalent units of production for materials and for conversion costs. T12 Tables Materials Conversion Costs C10 Chairs (3) Determine the unit costs of production. (Round unit costs to 0 decimal places, e.g. 25.) Unit costs-T12 Tables $ Materials Unit costs-C10 Chairs $ $ $ Conversion Costs (4) Show the assignment of costs to units transferred out and in process. T12 Tables $ $ Total Costs Costs accounted for: Transferred out $ Work in process Materials Conversion costs $ Total costs $ C10 Chairs Costs accounted for: Transferred out $ Work in process Materials Conversion costs Total costs $ $ Attempts: 0 of 3 used *(b) The parts of this question must be completed in order. This part will be available when you complete the part above. Copyright 2000-2016 by John Wiley & Sons, Inc. or related companies. All rights reserved. *Problem 16-6A (Part Level Submission) Hamilton Processing Company uses a weighted-average process cost system and manufactures a single producta premium rug shampoo and cleaner. The manufacturing activity for the month of October has just been completed. A partially completed production cost report for the month of October for the mixing and cooking department is shown below. *(a) Prepare a schedule that shows how the equivalent units were computed so that you can complete the \"Quantities: Units accounted for\" equivalent units section shown in the production cost report, and compute October unit costs. (Round unit costs to 2 decimal places, e.g. 2.25.) Quantities Units to be accounted for Work in process, October 1 (all materials, 70% conversion costs) Started into production Total units Units accounted for Transferred out Work in process, October 31 (60% materials, 40% conversion costs) Total units accounted for Costs Unit costs Total Costs Equivalent units Unit costs Physical Units HAMILTON PROCESSING COMPANY Mixing and Cooking Department Production Cost Report For the Month Ended October 31 Equivalent Units Conversion Materials Costs 21,800 163,500 185,300 130,800 54,500 185,300 Conversion Costs Materials Total $261,600 $114,450 $376,050 $ $ $ Costs to be accounted for Work in process, October 1 Started into production Total costs $32,700 343,350 $376,050 Attempts: 0 of 3 used *(b) The parts of this question must be completed in order. This part will be available when you complete the part above. Copyright 2000-2016 by John Wiley & Sons, Inc. or related companies. All rights reserved. \fa) Materials Total equivalent units of production Conversion Costs 17500 b) Materials 3.40 Conversion Costs 2.20 Prepare a cost reconciliation schedule. Cost Reconciliation Costs accounted for Transferred out Work in process, July 31 Materials Conversion costs Total costs 15620 71680 15,980 6204 22,184 93864 a) Materials The equivalent units of production b) Unit Cost 38800 Conversion Costs 33130 5.30 Conversion Costs 13.00 Materials