Figure 1. Spreadsheet for organizing quantitative case data Group Member Names: Process Costing Case - Accompanying Spreadsheet - Complete the yellow/blank cells -INCLUDE FORMULAS Process Costing - Assembly Department - JUNE Information regarding inventory production for the Assembly Department for June is as follows: Direct Materials Costs in June for 41,300 Units 5 716,555 Direct Labor Costs incurred in June 276,612 Factory Overhead costs incurred in June 149,520 Work completed in June: 35,700 units Ending Work in Progress, June 30:5,600 units, 30% completed Equivalent Units of Equivalent Units Production for of Production for Materials Conversion Costs Whole Units Category Started in May: Completed in June Started in June: Completed in June Started in June: Completed in July TOTAL 35,700 5,600 41,300 ..) Materials cost per equivalent unit b.) Conversion cost per equivalent unit c) Cost per unit of finished goods started in May: completed in June c.) Total cost of all finished goods started in May: completed in June Cost per unit of finished roods started and completed in June 4.) Total cost of all finished goods started and completed in June Cost per unit of the work in progress inventory on June 30 1.) Total cost of the work in process inventory on June