CHALLE SSN 30% 3 Data 4 Beginning work in process mentary Units process Completion with respect to manas Completos with respect to contra Casten the beginning work process o ry Matenas cost 10 Como Cost 11 Units stated to production during the period 12 Coats added to production during the period 13 Materials cost 14 Come cost 15 Ending work process s tory 16 U process 17 Completion with respect tomaten 18 Compowth ipect to c on 59.500 $ $TS 5.000 5368 600 $350 900 100 25 20 Erafmolento che il mare below 22 Weighted Average method Equivalent this of Production 25 Units transferred to the next dap a t 27 Ending work process o ry 28 23 Dom 30 Euraient unts of production Coste per Equivalent Unit Materiais HR Cost of beginning work process motory 3 Costs added during the period 35 Total com 37 Equaient units of production as Cost per essent 40 Costs of Ending Work in Process Investory and the Unies Transferred Out als 42 Ending work in process motory 43 Equaient units of production 46 Cest per equat unt 45 Coot of ending work in proceso rectory 46 47 Usts completed and transferred out 45 Units tranned to the next department 49 Cost per equalot unt 50 Cast of units transferred out Cost Reconciliation 53 Costs to be accounted for 56 Cest of beginning work in process motory SS Casts asided to production during the period 56 Total cost to be accounted for 37. Cests accounted for as follows Cest of ending work in processinentory $ Cost of w hatred out 60 Total cour account for 52 47 Uits completed and transferred out 48 transfered to the net department 49 Cost per t unt 50 Cast of us and out Cost Reconcilio 53 Costs to be accounted to 54 Cost of b ongo processary 5 Cousasted to production during the end 56 Total cost to be accounted for 32. Cous accounted was fotos 5 Custofanding process inntory Cost of red out 60 Total Record to You should proceed to the requirements below only after completing your worksheet. Required: 1. Check your worksheet by changing the beginning work in process inventory to 100 units, the units started into production during the period to 2.500 units, and the units in ending work in process inventory to 200 units, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the cost per equivalent unit for materials should now be $152.50 and the cost per equivalent unit for conversion Process Costing should be $145.50. If you do not get these answers, find the errors in your worksheet and correct them. How much is the total cost of the units transferred out? Did it change? Why or why not? Enter the following data from a different company into your worksheet: 2. 200 100% 20 Beginning work in process inventory: Units in process........ Completion with respect to materials Completion with respect to conversion ... Costs in the beginning work in process inventory: Materials cost ...... Conversion cost .... Units started into production during the period Costs added during the period: Materials cost ...... Conversion cost ..... Ending work in process inventory: Units in process....... Completion with respect to materials. Completion with respect to conversion ... $2.000 $800 1,800 $18.400 $38,765 100 100% 30% What is the cost of the units transferred out? What happens to the cost of the units transferred out in part (2) above if the percentage com- pletion with respect to conversion for the beginning inventory is changed from 20% to 40% and everything else remains the same? What happens to the cost per equivalent unit for con version? Explain. Ch_4 Student Form Chapter 4: Applying Excel 200 55% 30% Data Beginning work in process inventory Units in process Completion with respect to materials Completion with respect to conversion Costs in the beginning work in process inventory Materials cost Conversion cost Units started into production during the period Costs added to production during the period: Materials cost Conversion cost Ending work in process inventory Units in process Completion with respect to materials Completion with respect to conversion $9,600 $5,575 5,000 $368,600 $350.900 400 40% 25% Enter a formula into each of the cells marked with a ? below Weighted Average method: Conversion Equivalent Units of Production Materials Units transferred to the next department Ending work in process inventory: Materials Conversion Equivalent units of production Costs per Equivalent Unit Materials Conversion Cost of beginning work in process inventory Costs added during the period Total cost Equivalent units of production Cost per equivalent unit Costs of Ending Work in Process Inventory and the Units Transferred Out Materials Conversion Ending work in process inventory: Equivalent units of production Cost per equivalent unit Cost of ending work in process inventory Units completed and transferred out Units transferred to the next department Cost per equivalent unit Cost of units transferred out Cost ReconclNation Costs to be accounted for Cost of beginning work in process inventory Costs added to production during the period Total cost to be accounted for Costs accounted for as follows: Cost of ending work in process inventory Cost of units transferred out Total cost accounted for Cost Reconciliation 53 Costs to be accounted for 54 Cost of beginning work in process inventory 55 Costs added to production during the period 56 Total cost to be accounted for 57 Costs accounted for as follows 58 Cost of ending work in process inventory 59 Cost of units transferred out 60 Total cost accounted for 44 Chapter 4 Form. che You should proceed to the requirements below only after completing your worksheet. Required: Check your worksheet by changing the beginning work in process inventory to 100 units, the units started into production during the period to 2.500 units, and the units in ending work in process inventory to 200 units, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the cost per equivalent unit for materials should now be $152.50 and the cost per equivalent unit for conversion LemOVO BEST should be $145.50. If you do not get these answers, find the errors in your worksheet and correct them. How much is the total cost of the units transferred out? Did it change? Why or why not? Enter the following data from a different company into your worksheet: 1.800 Beginning work in process inventory: Units in process..... 200 Completion with respect to materials .... . 100% Completion with respect to conversion ... 20% Costs in the beginning work in process inventory: Materials cost ........ .. $2,000 Conversion cost .... ................... $800 Units started into production during the period ...... Costs added during the period: Materials cost...... .. $18,400 Conversion cost ... $38.765 Ending work in process inventory: Units in process.... 100 1 009 Completion with respect to materials 2 Completion with respect to conversion ................. SSSSSSSS What is the cost of the units transferred out? What happens to the cost of the units transferred out in part (2) above if the percentage com- pletion with respect to conversion for the beginning inventory is changed from 20% to 40% and everything else remains the Nile? What happens to the cost per equivalent unit for con version? Explain. ... 30% OR CHALLE SSN 30% 3 Data 4 Beginning work in process mentary Units process Completion with respect to manas Completos with respect to contra Casten the beginning work process o ry Matenas cost 10 Como Cost 11 Units stated to production during the period 12 Coats added to production during the period 13 Materials cost 14 Come cost 15 Ending work process s tory 16 U process 17 Completion with respect tomaten 18 Compowth ipect to c on 59.500 $ $TS 5.000 5368 600 $350 900 100 25 20 Erafmolento che il mare below 22 Weighted Average method Equivalent this of Production 25 Units transferred to the next dap a t 27 Ending work process o ry 28 23 Dom 30 Euraient unts of production Coste per Equivalent Unit Materiais HR Cost of beginning work process motory 3 Costs added during the period 35 Total com 37 Equaient units of production as Cost per essent 40 Costs of Ending Work in Process Investory and the Unies Transferred Out als 42 Ending work in process motory 43 Equaient units of production 46 Cest per equat unt 45 Coot of ending work in proceso rectory 46 47 Usts completed and transferred out 45 Units tranned to the next department 49 Cost per equalot unt 50 Cast of units transferred out Cost Reconciliation 53 Costs to be accounted for 56 Cest of beginning work in process motory SS Casts asided to production during the period 56 Total cost to be accounted for 37. Cests accounted for as follows Cest of ending work in processinentory $ Cost of w hatred out 60 Total cour account for 52 47 Uits completed and transferred out 48 transfered to the net department 49 Cost per t unt 50 Cast of us and out Cost Reconcilio 53 Costs to be accounted to 54 Cost of b ongo processary 5 Cousasted to production during the end 56 Total cost to be accounted for 32. Cous accounted was fotos 5 Custofanding process inntory Cost of red out 60 Total Record to You should proceed to the requirements below only after completing your worksheet. Required: 1. Check your worksheet by changing the beginning work in process inventory to 100 units, the units started into production during the period to 2.500 units, and the units in ending work in process inventory to 200 units, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the cost per equivalent unit for materials should now be $152.50 and the cost per equivalent unit for conversion Process Costing should be $145.50. If you do not get these answers, find the errors in your worksheet and correct them. How much is the total cost of the units transferred out? Did it change? Why or why not? Enter the following data from a different company into your worksheet: 2. 200 100% 20 Beginning work in process inventory: Units in process........ Completion with respect to materials Completion with respect to conversion ... Costs in the beginning work in process inventory: Materials cost ...... Conversion cost .... Units started into production during the period Costs added during the period: Materials cost ...... Conversion cost ..... Ending work in process inventory: Units in process....... Completion with respect to materials. Completion with respect to conversion ... $2.000 $800 1,800 $18.400 $38,765 100 100% 30% What is the cost of the units transferred out? What happens to the cost of the units transferred out in part (2) above if the percentage com- pletion with respect to conversion for the beginning inventory is changed from 20% to 40% and everything else remains the same? What happens to the cost per equivalent unit for con version? Explain. Ch_4 Student Form Chapter 4: Applying Excel 200 55% 30% Data Beginning work in process inventory Units in process Completion with respect to materials Completion with respect to conversion Costs in the beginning work in process inventory Materials cost Conversion cost Units started into production during the period Costs added to production during the period: Materials cost Conversion cost Ending work in process inventory Units in process Completion with respect to materials Completion with respect to conversion $9,600 $5,575 5,000 $368,600 $350.900 400 40% 25% Enter a formula into each of the cells marked with a ? below Weighted Average method: Conversion Equivalent Units of Production Materials Units transferred to the next department Ending work in process inventory: Materials Conversion Equivalent units of production Costs per Equivalent Unit Materials Conversion Cost of beginning work in process inventory Costs added during the period Total cost Equivalent units of production Cost per equivalent unit Costs of Ending Work in Process Inventory and the Units Transferred Out Materials Conversion Ending work in process inventory: Equivalent units of production Cost per equivalent unit Cost of ending work in process inventory Units completed and transferred out Units transferred to the next department Cost per equivalent unit Cost of units transferred out Cost ReconclNation Costs to be accounted for Cost of beginning work in process inventory Costs added to production during the period Total cost to be accounted for Costs accounted for as follows: Cost of ending work in process inventory Cost of units transferred out Total cost accounted for Cost Reconciliation 53 Costs to be accounted for 54 Cost of beginning work in process inventory 55 Costs added to production during the period 56 Total cost to be accounted for 57 Costs accounted for as follows 58 Cost of ending work in process inventory 59 Cost of units transferred out 60 Total cost accounted for 44 Chapter 4 Form. che You should proceed to the requirements below only after completing your worksheet. Required: Check your worksheet by changing the beginning work in process inventory to 100 units, the units started into production during the period to 2.500 units, and the units in ending work in process inventory to 200 units, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the cost per equivalent unit for materials should now be $152.50 and the cost per equivalent unit for conversion LemOVO BEST should be $145.50. If you do not get these answers, find the errors in your worksheet and correct them. How much is the total cost of the units transferred out? Did it change? Why or why not? Enter the following data from a different company into your worksheet: 1.800 Beginning work in process inventory: Units in process..... 200 Completion with respect to materials .... . 100% Completion with respect to conversion ... 20% Costs in the beginning work in process inventory: Materials cost ........ .. $2,000 Conversion cost .... ................... $800 Units started into production during the period ...... Costs added during the period: Materials cost...... .. $18,400 Conversion cost ... $38.765 Ending work in process inventory: Units in process.... 100 1 009 Completion with respect to materials 2 Completion with respect to conversion ................. SSSSSSSS What is the cost of the units transferred out? What happens to the cost of the units transferred out in part (2) above if the percentage com- pletion with respect to conversion for the beginning inventory is changed from 20% to 40% and everything else remains the Nile? What happens to the cost per equivalent unit for con version? Explain. ... 30% OR