Arsenio Company manufactures a single product that goes through two processes, mixing and cooking. The following data pertain to the mixing department for August:
Work-in-process inventory, August 1 | |||
Conversion: 70% complete | 37,000 | units | |
Work-in-process inventory, August 31 | |||
Conversion: 50% complete | 36,000 | units | |
Units started | 63,000 | ||
Units completed and transferred out | ? | ||
Costs | |||
Work-in-process inventory, August 1 | |||
Material X | $ | 58,100 | |
Material Y | 84,000 | ||
Conversion | 118,120 | ||
Costs added during August | |||
Material X | 151,500 | ||
Material Y | 146,400 | ||
Conversion | 177,080 | ||
Material X is added at the beginning of work in the mixing department. Material Y is also added in the mixing department, but not until units are 60% complete with regard to conversion. Conversion costs are incurred uniformly during the process. The company uses the weighted-average cost method.
Required:
1. & 2. Calculate the equivalent units and costs per equivalent unit of material X, material Y, and conversion for the mixing department.
3. Calculate the cost of units transferred out.
4. Calculate the cost of the ending Work-in-Process Inventory.
Solution
Material X | Material Y | Conversion | |
Equivalent Units of Production | 100,000 | 64,000 | 82,000 |
Cost per equivalent Unit | $ 2.10 | $ 3.60 | $ 3.60 |
.
Cost of units Transferred out | $ 594,944.00 |
.
Cost of Ending Work in process inventory | $ 140,256.00 |
Working
Reconciliation of Units | ||
A | Opening WIP | 37,000 |
B | Introduced | 63,000 |
C=A+B | TOTAL | 100,000 |
D | Transferred | 64,000 |
E=C-D | Closing WIP | 36,000 |
.
Statement of Equivalent Units(Weighted average) | |||||||
Material X | Material Y | Conversion cost | |||||
Units | Complete % | Equivalent units | Complete % | Equivalent units | |||
Transferred | 64,000 | 100% | 64,000 | 100% | 64,000.0 | 100% | 64,000 |
Closing WIP | 36,000 | 100% | 36,000 | 0% | - | 50% | 18,000.00 |
Total | 100,000 | 100,000 | Total | 64,000.0 | Total | 82,000 |
.
Cost per Equivalent Units (Weighted average) | ||||
COST | Material X | Material Y | Conversion cost | TOTAL |
Beginning WIP Inventory Cost | $ 58,100.00 | $ 84,000 | $ 118,120 | $ 260,220 |
Cost incurred during period | $ 151,500.00 | $ 146,400 | $ 177,080 | $ 474,980 |
Total Cost to be accounted for | $ 209,600 | $ 230,400 | $ 295,200 | $ 735,200 |
Total Equivalent Units | 100,000.0 | 64,000.0 | 82,000.0 | |
Cost per Equivalent Units | $ 2.096 | $ 3.600 | $ 3.600 |
.
.
Statement of cost (Weighted average) | |||||
Cost | Equivalent Cost/unit | Ending WIP | Transferred | ||
Units | Cost Allocated | Units | Cost Allocated | ||
Material X | $ 2.10 | 36,000 | $ 75,456.00 | 64,000 | $ 134,144 |
Material Y | $ 3.60 | - | $ - | 64,000 | $ 230,400 |
Conversion cost | $ 3.60 | 18,000 | $ 64,800.00 | 64,000 | $ 230,400 |
TOTAL | $ 735,200 | TOTAL | $ 140,256 | TOTAL | $ 594,944 |
Arsenio Company manufactures a single product that goes through two processes, mixing and cooking. The following...
Arsenio Company manufactures a single product that goes through two processes, mixing and cooking. The following data pertain to the mixing department for August: 29,000 units 32,000 units 71,000 Work-in-process inventory, August 1 Conversion: 80% complete Work-in-process inventory, August 31 Conversion: 50% complete Units started Units completed and transferred out Costs Work-in-process inventory, August 1 Material x Material y Conversion Costs added during August Material X Material y Conversion $ 55,300 85,600 118,880 159, 200 104,800 334,720 Material X is...
Arsenio Company manufactures a single product that goes through two processes, mixing and cooking. The following data pertain to the mixing department for August: Work-in-process inventory, August 1 Conversion: 80% complete 36,000 units Work-in-process inventory, August 31 Conversion: 50% complete 38,000 units Units started 64,000 Units completed and transferred out ? Costs Work-in-process inventory, August 1 Material X $ 53,700 Material Y 85,000 Conversion 118,990 Costs added during August Material X 152,000 Material Y 107,200 Conversion 229,310 Material X is...
Arsenio Company manufactures a single product that goes through two processes, mixing and cooking. The following data pertain to the mixing department for August: Work-in-process inventory, August 1 Conversion: 70% complete 31,000 units Work-in-process inventory, August 31 Conversion: 50% complete 34,000 units Units started 69,000 Units completed and transferred out ? Costs Work-in-process inventory, August 1 Material X $ 60,900 Material Y 86,100 Conversion 119,860 Costs added during August Material X 154,500 Material Y 98,700 Conversion 228,740 Material X is...
Talamoto Co. manufactures a single product that goes through two processes – mixing and cooking. The following data pertains to the Mixing Department for September. 35,000 units 70% 13,000 units 50% 59,000 ? units Work-in-process Inventory Sept. 1 Conversion complete Work-in-process inventory Sept. 30 Conversion complete Units started into production in Sept. Units completed and transferred out Costs Work-in-process inventory Sept.1 Material P Material e Conversion Costs added in September Material P Materiale Conversion $ 99,000 90,000 99,000 $148,000 136,000...
Talamoto Co. manufactures a single product that goes through two processes – mixing and cooking. The following data pertains to the Mixing Department for September. 28,000 units 70% 16,000 units 50% 72,000 ? units Work-in-process Inventory Sept. 1 Conversion complete Work-in-process inventory Sept. 30 Conversion complete Units started into production in Sept. Units completed and transferred out Costs Work-in-process inventory Sept.1 Material P Materiale Conversion Costs added in September Material P Material e Conversion $120,000 110,000 165,000 $180,000 165,000 354,800...
Talamoto Co. manufactures a single product that goes through two processes – mixing and cooking. The following data pertains to the Mixing Department for September. 33,000 units 70% 22,000 units 50% 100,000 ? units Work-in-process Inventory Sept. 1 Conversion complete Work-in-process inventory Sept. 30 Conversion complete Units started into production in Sept. Units completed and transferred out Costs Work-in-process inventory Sept.1 Material P Material o Conversion Costs added in September Material P Materiale Conversion $167,000 153,000 167,000 $251,000 230,000 494,200...
Talamoto Co. manufactures a single product that goes through two processes Mixing Department for September. mixing and cooking. The following data pertains to the 28,000 units 70% 16,000 units 50% 72,000 ? units Work-in-process Inventory Sept. 1 Conversion complete Work-in-process inventory Sept. 30 Conversion complete Units started into production in Sept. Units completed and transferred out Costs Work-in-process inventory Sept. 1 Material P Material e Conversion Costs added in September Material P Material Q Conversion $120,000 110,000 165,000 $180,000 165,000...
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...
Weston Products manufactures an industrial cleaning compound that goes through three processing departments—Grinding, Mixing, and Cooking. All raw materials are introduced at the start of work in the Grinding Department. The Work in Process T-account for the Grinding Department for May is given below: Work in Process—Grinding Department Inventory, May 1 374,660 Completed and transferred to the Mixing Department ? Materials 585,210 Conversion 375,114 Inventory, May 31 ? The May 1 work in process inventory consisted of 131,000 pounds with...
Weston Products manufactures an industrial cleaning compound that goes through three processing departments—Grinding, Mixing, and Cooking. All raw materials are introduced at the start of work in the Grinding Department. The Work in Process T-account for the Grinding Department for May is given below: Work in Process—Grinding Department Inventory, May 1 178,000 Completed and transferred to the Mixing Department ? Materials 724,040 Conversion 402,000 Inventory, May 31 ? The May 1 work in process inventory consisted of 50,000 pounds with...