1) Compute equivalent units
Calculate the equivalent units of production
|
Particular |
Materials |
Conversion |
|
Units transferred for the next department |
6050 |
6050 |
|
Ending working process: |
||
|
Materials |
180 |
|
|
conversion |
135 |
|
|
Equivalent units of production |
6230 |
6185 |
Calculations
Units transferred for the next department = 6050*100% = 6050
Materials = 450*40% = 180
Conversion = 450*30% = 135
Calculate units completed and transferred
|
Particulars |
units |
|
Units of beginning working process |
300 |
|
Units started into production |
6200 |
|
Total units available |
6500 |
|
Less: units of closing working process |
450 |
|
Units completed and transferred |
6050 |
2) Calculate cost per equivalent units
Calculate cost per equivalent products
|
Particular |
Materials |
conversion |
|
Cost of beginning working process |
$10500 |
$6750 |
|
Cost added during the period |
$330912 |
$406408 |
|
Total cost |
$341412 |
$413158 |
|
Equivalent units of production |
6230 |
6185 |
|
Cost per equivalent units |
$54.80 |
$66.80 |
Cost per equivalent units = Total cost/ Equivalent units of production
Materials = 341412/6230 = 54.80
Conversion = 413158/6185 = 66.80
3) Assign cost
Costs of ending working process inventory and units transferred out
|
Particulars |
Materials |
Conversion |
total |
|
Ending working process inventory |
|||
|
Equivalent units of production |
180 |
135 |
|
|
Cost per equivalent unit |
$54.80 |
$66.80 |
|
|
Cost of ending working process inventory |
$9864 |
$9018 |
$18882 |
|
Units completed and transferred out |
|||
|
units transferred to the next department |
6050 |
6050 |
|
|
Cost per equivalent unit |
$54.80 |
$66.80 |
|
|
Cost of unit transferred out |
$331540 |
$404140 |
$735680 |
4) Prepare reconciliation
Cost reconciliation
|
Particulars |
Amount ($) |
|
Cost to be accounted for: |
|
|
Cost of beginning working process inventory |
$17250 |
|
Cost added to production during the period |
$737320 |
|
Total cost to be accounted for |
$754570 |
|
Cost accounted for as follows: |
|
|
Costs of ending working process inventory |
$18882 |
|
Cost of units transferred out |
$735688 |
|
Total cost accounted for |
$754570 |
Calculations
Cost of beginning working process inventory = 10500 + 6750 = 17250
Cost added to production during the period = 330912 + 406408 = 737320
A B с D E 1 9 Hayword, Inc. uses weighted average costing and has two...
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...
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...
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...
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...
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...
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...
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...
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...