052 2000 M N O P 25 Points A D F G K L 1 P17-2A Completo four steps nocessary to prepare a production cost report 2 Rosenthal Company manufacture bowling balls through two procesa Molding and packaging. In the Molding Department, the urethane, i plastics and other materials are molded into bowling balls. In the Packaging Department, the balls are placed in cations and went to the finished goods warehouse All materials are entered at the beginning of each proces Labor and facturing overhead are incuned uniformly thoughout each proces Hoduction and con data for the Molding Department during June 2017 are presented below. Production Data Meginning work in process units 0 Units started into production 22.000 Ending work in process units 2,000 11 Percent completending inventory 4096 12 11 CostData 14 Materials $198.000 Labor 55100 10 Overhead 31120 Total 5364400 10 19 Instructions 20 ) Prepare a schedule showing physical units of production 21 ) Determine the equivalent units of production for materials and conversion or 22 ) Compute the unit costs of production 23 (d) Desemine the costs to be assigned to the units transferred at and in process for June 24 ) Prepare a production cost report for the Molding Department for the month of June 25 26 NOTE! Enter a number in cells requesting a value; enter either a number or a formula in cells with a 27 28 15 17 Test 1 ch15-18-AC AUTOS Review Formulas View Tell me Home Insent Draw Page Layout Liberation Sans Poste BV 42 2000 A F B C D 29 30 a Prepare a schedule showing physical units of production 32 34 35 36 37 38 Units to be accounted for Work in process, June 1 Units started into production Total units Physical Units 22.000 22.000 22,000 39 Units accounted for Units transferred out Work in process, September 30 Total units 20,000 2,000 22,000 40 41 Determine the equivalent units of production for materials and conversion costs. Conversion Costs Materials 43 44 (6) 45 46 47 48 49 50 51 52 53 20.000 20,000 Equivalent units Transferred out Work in process, September 30 2,000 Times times Total units 2,000 100% 40% 2000 800 20,800 22.000 54 55 56 (c 57 Compute the unit costs of production Conversion Costs Materials 58 Total 60 61 62 63 64 Unit costs Work in Process Sept manufacturing costs Total cost Equivalent units Unit costs Test Problem P15-4A Value Value Value Value Value Value Value Value Value Test Problem P17:24 Test Problem P16-9A Test Problem P16-4A Enter Test 1 ch15-18- Draw Insert Page Layout Formulas Data Review View Tell me me Liberation Sans v 11 aste 1 2000 E F G H B D Compute the unit costs of production, Conversion Costs Materials Total Unit costs Work in Process Sept manufacturing costs Total cost Equivalent units Unit costs Value Value Value Value 2 Value Value Valug Value Value Determine the costs to be assigned to the units transferred out and in process for June. Conversion Costs Materials Total Cost of Units Transferred Out. Sept. Units Transferred out Unit costs Total Cost Value Value 2 Value Value 2 Cost of Work in Process, Sept. 30 Units in Work in Process Unit costs (a)+(b) Total Cost Valuc Value 2 Value Value Total Cost-Check number (c) Prepare a production cost report for the Molding Department for the month of June. 3 ROSENTHAL COMPANY Molding Department Production Cost Report For the Month Ended June 30, 2017 5 06 37 Equivalent Units Physical Conversion Costs 90 Quantities Materials Test Problem P15A Test Problemn P16-3A Test Problem P10.A Test Problem P17.2A Enter Test 1 ch15-18-ACC202. Excel Autolave Data Review Page Layout Home Formulas View Insert Tell me Draw Liberation Sans D Pasto 092 2000 H C D Units to be accounted for Work in process, June ! Started into production Total units Value Value 7 Units accounted for Transferred out Work in process, June 30 Total units Value Value ? Value Value ? Valec Value 7 92 93 94 95 SU 97 98 99 100 101 102 103 104 105 106 107 901 100 110 111 Total Coats Unit costs Total com Equivalent units Unit costs Value Value 2 Value Value 2 Costs to be accounted for Work in process, June ! Started into production Total costs Value Value 7 Cost Reconciliation Schedule Total Units Unit Cost Value Value ? 113 114 115 116 112 118 119 120 121 122 123 124 125 126 127 128 Value Valur Value Value Costs comied for Transdened out Work in process, June Costs or complete work in process Conversion costs Units started and completed Total cost transferred out Work in process, June 30 Materials 2.000 X 59.00) Conversion coats (100 X 5800) Total costs 7 Value Value Value Value 7 Test Problem P17-20 Test Problem Test Prostom PIGIA Test Problem P15-4A Test Problem P15 JA ENOT A Gu ACC chistest Home andert Draw Page Layout Formula Data Review View Tell me Liberation Sans 11 AA EES wrap text Number Peste Merge Center CC 2000 A C D 1 P17-2A Complete four shops necessary to prepare a production cost report Rosenthal Company manufactures bowling balls through two processes Molding and Packaging. In the Molding Department, the urethane, plastics and other materials are molded into bowling balls. In the Packaging Department, the balls are placed in carton and sent to the finished goods warehouse. All materials are entered at the beginning of each proceu. Labor and manufacturing overhead are incurred 5 uniformly throughout each proces. Production and cost data for the Molding Department during June 2017 are presented below. Production Data June Beginning work in process units 0 Units started into production 22.000 10 Ending work in process units 2,000 11 Percent completo-ending inventory 40% 13 Cost Data 14 Materials $195,000 15 Labor $53,600 16 Overhead $1121800 17 Total cost 5364,400 18 19 Instructions 20) Prepare a schedule showing physical units of production 21 () Determine the equivalent units of production for materials and conversion costs 22 Compute the unit costs of production 23 (d) Determine the costs to be assigned to the units transferred out and in process for Aune. 240 Prepare a production controport for the Molding Department for the month of June. 25 26 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". 27 28 29 -30 () 31 Prepare a schedule showing physical units of production 33 Physical Unit Inits to be accounted for Work in process, June 1 34 22,000 Test Problem 15-48 Test Problem PIGA Tout Pro P16-4A Test Problem P17A Tent Pabice P18-TA