Solution:
1. Compute Equivalent units. | |||
Mixing Department | |||
Equivalent units of production | |||
Materials | Conversion | ||
Units transferred to next department | 6050 | 6050 | |
Ending Work in process: | |||
Materials | 180 | ||
Conversion | 135 | ||
Equivalent units of production | 6230 | 6185 | |
2. Compute cost per equivalent unit. | |||
Mixing Department | |||
Cost per Equivalent unit | |||
Materials | Conversion | ||
Cost of beginning work in process | 10500 | 6750 | |
Cost added during the period | 332150 | 407645 | |
Total cost | 342650 | 414395 | |
Equivalent units of production | 6230 | 6185 | |
Cost per Equivalent unit | 55.00 | 67.00 | |
3. Assign costs. | |||
Mixing Department | |||
Costs of ending work in process inventory and the units transferred out | |||
Materials | Conversion | Total | |
Ending Work in process inventory: | |||
Equivalent units of production | 180 | 135 | |
Cost per Equivalent unit | 55.00000 | 67.00000 | |
Cost of Ending Work in process inventory | 9900 | 9045 | 18945 |
Units completed and transferred out: | |||
Units transferred to next department | 6050 | 6050 | |
Cost per Equivalent unit | 55.00000 | 67.00000 | |
Cost of Units transferred out | 332750 | 405350 | 738100 |
4. Prepare Reconciliation. | |||
Mixing Department | |||
Cost reconciliation | |||
Costs to be accounted for: | |||
Cost of Beginning Work in process inventory | 17250 | ||
Cost added to production during the period | 739795 | ||
Total cost to be accounted for | 757045 | ||
Costs accounted for as follows: | |||
Cost of Ending Work in process inventory | 18945 | ||
Cost of Units transferred out | 738100 | ||
Total cost accounted for | 757045 |
F20 DE 1 Hayword, Inc, uses weighted average costing and has two departments - mixing and...
E C D 1 Hayword, Inc. uses weighted average costing and has two departments - mixing and packaging. 2 The following information relates to work in the mixing department for the month of July: 300 60% 40% 4 Work in process, July 1: 5 Units in process 6 Percent completed with respect to materials 7 Percent completed with respect to conversion 8 Cost in the beginning inventory: 9 Materials cost 10 Conversion cost 11 Units started into production during the...
A1 for Hayword, Inc. uses weighted average costing and has two departments - mixing E > 9 А B с D 1 Hayword, Inc. uses weighted-average costing and has two departments - mixing and packaging. 2 The following information relates to work in the mixing department for the month of July: 3 4 Work in process, July 1: 5 Units in process 300 6 Percent completed with respect to materials 60% 7 Percent completed with respect to conversion 40% 8...
A B с D E 1 9 Hayword, Inc. uses weighted average costing and has two departments - mixing and packaging. 2 The following information relates to work in the mixing department for the month of July: 3 4 Work in process, July 1: 5 Units in process 300 6 Percent completed with respect to materials 60% 7 Percent completed with respect to conversion 40% 8 Cost in the beginning inventory: Materials cost $10,500 10 Conversion cost $6,750 11 Units...
hayword, inc. uses weighted-average costing and has two departments and has provided data related to its mixing department for the month of July. I need to know what keys to press into the spreadsheet as well. Thank you! Hayword, Inc. uses weighted-average costing and has two departments and has provided data related to its mixing department for the month of July. The Controller has asked you prepare a cost reconciliation report and provide the related computations. Use the information included...
Can you please help me with the boxes highlighted in yellow Thank you! 1 Hayword, Inc. uses weighted average costing and has two departments - mixing and packaging. 2 The following information relates to work in the mixing department for the month of July: 3 300 60% 40% $10,500 $6,750 6,200 4 Work in process, July 1: 5 Units in process 6 Percent completed with respect to materials 7 Percent completed with respect to conversion 8 Cost in the beginning...
Process Costing using the Weighted-Average Method 1. Compute the equivalent units of production using the weighted-average method. 2. Compute the cost per equivalent unit using the weighted average method. 3. Assign costs to units using the weighted-average method 4. Prepare a cost reconciliation report. KOS ? x . HOME Process Costing using the Weighted-Average Method - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW - 5 Sign In FILE INSERT Paste IU - 23 - A Alignment Number Cells Editing Conditional...
Answers must be inputted by a formula Hayword, Inc. uses weighted average costing and has two departments and has provided data related to its mixing department for the month of July. The Controller has asked you prepare a cost reconciliation report and provide the related computations. Use the information Included in the Excel Simulation and the Excel functions described below to complete the task • Cell Reference: Allows you to refer to data from another cell in the worksheet. From...
All answers must be entered as a formula. Click OK to begin. OK B18 30% 1 2 в DE Hayword, Inc. uses weighted average costing and has two departments - mixing and packaging. The following information relates to work in the mixing department for the month of July: 300 60% 40% 4 Work in process, July 1: 5 Units in process 6 Percent completed with respect to materials 7 Percent completed with respect to conversion 8 Cost in the beginning...
Sunspot Beverages, Ltd., of Fiji uses the weighted-average method in its process costing system. It makes blended tropical fruit drinks in two stages. Fruit juices are extracted from fresh fruits and then blended in the Blending Department. The blended juices are then bottled and packed for shipping in the Bottling Department. The following information pertains to the operations of the Blending Department for June. Percent Completed Units Materials Conversion Work in process, beginning 20,000 100% 75% Started into production 180,000...
Calibri 11 1 Paste BIU- - A % A Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font A1 X Hayword, Inc. uses weighted average costing and has two departments - mixing 5 aints A D E 6 eBook 7 References B Percent completed with respect to materials 60% Percent completed with respect to conversion 40% 8 Cost in the beginning inventory: 9 Materials cost $10,500 10 Conversion cost S6,750 11 Units started into production...