Can you please help me with the boxes highlighted in yellow
Thank you!
1) compute equivalent units of production(weighted average method)
Particular | material | conversion |
Units transferred to next department (note 1) |
[6050×100%completion] 6050 |
[6050×100%completion] 6050 |
Ending work in process | ||
Material |
[450×40%] 180 |
|
Conversion |
[450×30%] 135 |
|
TOTAL | 6230 | 6185 |
units transferred to next department=opening balance+units started into production during month-
ending inventory
=300+6200-450=6050
Units transferred to next department =6050
2) compute cost per equivalent units
Particular | material | conversion |
(a)Cost of beginning work in process | $10500 | $6750 |
(b)Cost added during month | $330912 | $406408 |
(c)total cost[a+b] | $341412 | $413158 |
(d) equivalent unit | 6230 | 6185 |
Cost per equivalent unit [c/d] | $54.8 | $66.8 |
3) compute cost of ending inventory and units transferred
Particular | material | conversion | total |
Ending work in process inventory | |||
(a) Equivalent units of production | 180 | 135 | 315 |
(b)Cost per Equivalent unit | $54.8 | $66.8 | |
Cost of ending wip inventory[a×b] | $9868 | $9022 | |
Units completed and transferred out | |||
(a) Units transferred to next department | 6050 | 6050 | |
(b) Cost per Equivalent unit | $54.8 | $66.8 | |
Cost of units transferred out[a×b] | $331540 | $404140 |
5) prepare reconciliation
Cost to be accounted for | |
(a)cost of beginning work in process | $17250 |
(b)Cost added to production | $737320 |
Total cost to be accounted for | $754570 |
Costs accounted for as follow | |
Cost of ending wip | $18890 |
Cost of unit's transferred out | $735680 |
Total cost accounted for | $754570 |
ALL THE BEST
PLEASE DO SUPPORT US
.... ANY DOUBT PLEASE COMMENT BELOW
... THANK YOU
Can you please help me with the boxes highlighted in yellow Thank you! 1 Hayword, Inc....
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...
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...
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...
please answer in yellow box and enter Excel formulas. 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 5. FILE Process Costing using the Weighted-Average Method - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW HOME INSERT Sign In -11AA2 Paste B I U A Alignment Number Conditional Format as Cell...
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...
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...
Need answers in EXCEL Formula Format (ex: =SUM(B13,B14) for each yellow highlighted cell IMPORTANT Need answers in EXCEL Formula Format (ex: =SUM(B13,B14) for each yellow highlighted cell, thank you in advance. 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...
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...
Chapter 4: Applying Excel Data Beginning work in process inventory: Units in process 200 Completion with respect to materials 100% Completion with respect to conversion 40% Costs in the beginning work in process inventory: Materials cost $2,000 Conversion cost $800 Units started into production during the period 1,800 Costs added to production during the period: Materials cost $18,400 Conversion cost $38,765 Ending work in process inventory: Units in process 100 Completion with respect to materials 100% Completion with respect to...