Answers using excel please?

ing the entries that have already been posted. Assume labor costs are accrued and not yet paid. P18-43B Preparing a production cost report, second department with Learning Objectives 2, 4,6 beginning WIP; decision making Sea Worthy uses three processes to manufacture lifts for personal watercrafts: forming a lift's parts from galvanized steel, assembling the lift, and testing the completed lift. The lifts are transferred to finished goods before shipment to marinas across the country. 1. Cost per EUP CC $11.00 Sea Worthy's Testing Department requires no direct materials. Conversion costs are incurred evenly throughout the testing process. Other information follows for October 2018: Beginning Work-in-Process Inventory Transferred in from Assembling Department during the period Completed during the period Ending Work-in-Process Inventory (40% complete for conver- 2,300 units 6,800 units 4.100 units 5,000 units sion work) COSTS Beginning Work-in-Process Inventory (transferred in costs, 111,500 $93,400; conversion costs, $18,100) Transferred in from the Assembly Department during the 671,000 period Conversion costs added during the period 49,000