Department #1 has 3,000 units of product on beginning inventory, 45% complete to labor and overhead with $9,000 of material costs, $4,547 of labor costs, and $8,950 of overhead costs incurred. Department #1 started enough material to make 47,000 units of product. This material cost a total of $141,000. There was $171,453 of labor charged into Department #1 during the period. Overhead is applied at $5 per machine hour and there were 51,010 machine hours incurred. There were 40,000 units of product finished in this department and transferred to Department 2. There are 10,000 units still in process in Department #1, 100% complete to materials and 40% complete to labor and overhead. Test Data: In Department #2, there is additional material added which cost a total of $83,000 this period. The labor charged to this department was S81,850 representing 10,000 hours and overhead is applied in this department at $16.50 per direct labor hour. Transferred to finished goods were 33,000 units. There were 12,000 units on ending inventory and they are 60% of the way through the department. The material in this department is added at the beginning of the process. Inspection occurs at halfway through the department. Department #2 had 5,000 units on beginning inventory, 80% complete to labor and overhead with $64,100 transfer-in costs, $11,500 materials cost, $8,600 labor costs, and $15,900 overhead costs incurred. Required: Prepare a complete production report for each department using Average cost flow a Three worksheets a. Data worksheet all information given above b. Department 1 worksheet all numbers pulled from data worksheet c. Department 2 worksheet all numbers pulled from data worksheet except one number needed from department 1 Department AVERAGE PROCESS COSTING Product Flow Units to Account For Units Accounted For Beginning Work in Process Units started transferred in this period Completed and transferred out Ending Inventory Total units Total units accounted for to account for Equivalent Units of Production Transfer-In Direct Materials mversion Units completed and transferred out Equivalent Units of ending work in process Direct Materials Corversion Equivalent Units of Production Cost per Equivalent Unit Costs of beginning work in process inventory Costs incurred this period Transfer-In Direct Materials nversion Total Total Costs Divided by Equivalent Units of Production Cost per EUP Cost Assignment Costs of Units completed and transferred out Transfer-In Costs Direct Materials Corversion Costa of Units completed this period Costs of ending work in process inventory Transfer-In Costa Direct Materials Conversion Costs of ending work in process inventory Total Costs Accounted for