Kimbeth Manufacturing makes Dust Density Sensors (DDS), a safety device for the mining industry. The company uses a process costing system and has only a single processing department. The following information pertains to operations for the month of May 2020:
Units
Beginning work in process inventory: 16,000
Started into production during May: 100,000
Completed during May: 92,000
Ending work in process inventory: ?
The beginning work in process inventory was 60% complete with respect to materials and 20% complete with respect to conversion costs. The ending work in process inventory was 90% complete with respect to materials and 40% complete with respect to conversion costs. The costs were as follows:
Conversion Costs
Beginning work in process inventory: $54,560
Materials: $35,560
Costs incurred during May:
Conversion Costs: $468,000
Materials: $574,040
You are required to complete the process costing template (Excel) for Kimbeth Manufacturing for the month of May 2020 to determine the average unit cost, as well as the valuation for the completed goods and those still in process on May 31, 2020.