In: Accounting
Builder Products, Inc., uses the weighted-average method in its process costing system. It manufactures a caulking compound that goes through three processing stages prior to completion. Information on work in the first department, Cooking, is given below for May:
Production data: | ||
Pounds in
process, May 1; materials 100% complete; conversion 90% complete |
88,000 | |
Pounds started into production during May | 530,000 | |
Pounds completed and transferred out | ? | |
Pounds in
process, May 31; materials 60% complete; conversion 40% complete |
65,000 | |
Cost data: | ||
Work in process inventory, May 1: | ||
Materials cost | $ | 106,000 |
Conversion cost | $ | 59,700 |
Cost added during May: | ||
Materials cost | $ | 551,120 |
Conversion cost | $ | 328,230 |
I want help on just doing Number 5. Thanks!
5. Prepare a cost reconciliation report for May.
Material | Conversion | Total | |||
1) | Equivalent Units | 592,000 | 579,000 | ||
2) | Cost per equivalent unit | 1.11 | 0.67 | ||
3) | Cost of Ending WIP | 43,290 | 17,420 | 60,710 | |
4) | Cost of Transferred Units | 613,830 | 370,510 | 984,340 | |
5) | Cost Reconciliation Report | ||||
Costs to be accounted for: | |||||
Total | Material | Conversion | |||
Costs in beginning inventory | 165,700 | 106,000 | 59,700 | ||
Cost added during the year | 879,350 | 551,120 | 328,230 | ||
Total cost to account for | 1,045,050 | 657,120 | 387,930 | ||
Total | Material | CC | |||
Cost Accounted for | |||||
Units completed and transfer | 984,340 | 613,830 | 370,510 | ||
Units in ending inventory | 60,710 | 43,290 | 17,420 | ||
Total Cost Accounted for | 1,045,050 | 657,120 | 387,930 | ||
Builder products inc. | |||||
Production Cost Report | |||||
Working Note 1: | |||||
Actual Units | |||||
Calculation of Physical UNITS: | |||||
Units in beginning inventory | 88,000 | ||||
Units started during the period | 530,000 | ||||
Units to be accounted for | 618,000 | ||||
Actual Units | Equivalent Units | ||||
Material | Conversion | ||||
Units Completed and Transferred | 553000 | 553000 | 553000 | ||
Units in ending inventory | 65000 | 39000 | 26000 | ||
Total accounted for | 618000 | 592000 | 579000 | ||
Working Note 2: | |||||
Costs to be accounted for: | |||||
Total | Material | Conversion | |||
Costs in beginning inventory | 165,700 | 106,000 | 59,700 | ||
Cost added during the year | 879,350 | 551,120 | 328,230 | ||
Total cost to account for | 1,045,050 | 657,120 | 387,930 | ||
Equivalent Units from above | 592000 | 579000 | |||
Cost per equivalent unit | 1.11 | 0.67 | |||