**Please create an excel and show all the works**

**Please use correct report format above**

Because most of the parts for its irrigation systems are standard, Waterways handles the majority of its manufacturing as a process cost system. There are multiple process departments. Three of these departments are the Molding, Cutting, and Welding departments. All items eventually end up in the Packaging Department, which prepares items for sale in kits or individually. The following information is available for the Molding department for January. 20,500 80% 30% Work in process beginning: Units in process Stage of completion for materials Stage of completion for labor and overhead Costs in work in process inventory: Materials Labor Overhead Total costs in beginning work in process $167,280 67,080 17,180 $251,540 60,000 57,800 Units started into production in January Units completed and transferred in January Costs added to production: Materials Labor Overhead Total costs added into production in January Work in process ending: Units in process Stage of completion for materials Stage of completion for labor and overhead $280,812 293,471 60,780 $635,063 22,700 50% 10% WATERWAYS CORPORATION Molding Department Production Report For the Month of January Physical Units Equivalent Units Conversion Materials Costs Quantities Units to be accounted for Work in process, Jan. 1 20,500 Started into production 60,000 Total units 80500 Units accounted for Transferred out 57,800 57,800 Work in process, Jan. 31 57,800 22,700 80500 C 11350 Total units 80500 6 69150 9150 L Materials Conversion Costs Total Costs Unit costs Costs in January Equivalent units Unit costs Costs to be accounted for Work in process, Jan. 1 $ 251,540 Started into production 635,063 Total costs 886603 Cost Reconciliation Schedule Costs accounted for Transferred out Work in process, Jan. 31 Materials Conversion costs Total costs 886603