Answer
Mixing Department
Production cost report-weighted average method
1 physical unit
| Particulars | units |
| Beginning work in process | 300 |
| Units started | 6,200 |
| Total units to be accounted | 6,500 |
| Units completed | 6,050 |
| Ending work in process | 450 |
| Total units to be accounted | 6,500 |
2 Equivalent units
| Direct material | Conversion cost | |
| Units completed | 6,050 | 6,050 |
| Ending work in process | 180 | 135 |
| Equivalent units | 6,230 | 6,185 |
Calculation of equivalent units
Direct material = 450 × 40% = 180 units
Conversion cost = 450 × 30% = 135 units
3 Cost per equivalent units
| Direct material | Conversion cost | |
| Total cost to be accounted | 341,412 | 413,158 |
| ÷ Equivalent units | 6,230 | 6,185 |
| Cost per equivalent units | 54.80 | 66.8 |
Calculations
Total cost in material = 10,500 + 330,912 = $341,412
Total cost in Conversion = 6,750 + 406,408 = $413,158
Cost per equivalent unit of material
= 341,412 / 6,230 = $54.80
Cost per equivalent unit of conversion cost
= 413,158 / 6,185 = $66.8
4 Cost of work in process inventory and unit transferred out
| Direct material | Conversion cost | Total | |
| Ending work in process inventory: | |||
| Equivalent unit of production | 180 | 135 | |
| Cost per equivalent unit | 54.80 | 66.8 | |
| Cost of ending work in process inventory | 9,864 | 9,018 | 18,882 |
| Units completed and transferred out: | |||
| Units transferred to next process | 6,050 | 6,050 | |
| Cost per equivalent units | 54.80 | 66.8 | |
| Cost of units transferred out (completed) | 331,540 | 404,140 | 735,680 |
Cost of Ending work in process
= (180 × 54.80) + (135 × 66.8) = $18,882
Cost per equivalent unit of Unit completed and transferred out
= (6,050 × 54.80) + (6050 × 66.8) = $735,680
5 Mixing Department cost reconciliation
| Cost to be accounted for: | |
| Cost of beginning work in process | 17,250 |
| Cost added to production | 737,320 |
| Total cost to be accounted for | 754,570 |
| Cost of units transferred out | 735,680 |
| Cost of Ending work in process | 18,882 |
| Total cost to be accounted for | 754,570 |
The above are the detailed presentations of production cost report under weighted average method of Mixing Department. Total cost of units transferred out is $735,680 and ending work in process inventory is $18,882.
If YOU are like the answer please upvote.
A1 for Hayword, Inc. uses weighted average costing and has two departments - mixing E >...
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...
F20 DE 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: 6011 405 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 period 12...
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...
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...
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 - Excel ? X - Sign In FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 8 Calibri - 11 - Á A = % Paste B I U , - > - A Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font B26 Hayword, Inc. uses weighted average costing and has two departments - mixing and packaging. 2 The following information relates to work in the mixing...
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...
Honeybutter, Inc., manufactures a product that goes through two departments prior to completion, the Mixing Department followed by the Packaging Department. The following information is available about work in the first department, the Mixing Department, during June. Percent Completed Units Materials Conversion 72.000 70% 358,500 Work in process, beginning 70% 40% Started into production Completed and transferred out Work in process, ending 348,500 82,000 75% 25% Materials Conversion Work in process, beginning $26,900 $ 9,400 Cost added during June $288,800...
THE ANSWERS ARE THE EXCEL FORMULAS NOT THE NUMBERS. PLEASE
PROVIDE THE EXCEL FORMULA THAT IS USED TO GET THE ANSWERS.
Saved 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. K 5. a Process Costing using the Weighted-Average Method - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW ? X...