Please show me how to get the answer step by step(write down the formulas/show the numbers from given information)

Prepare a production cost worksheet using weighted-average costing for the Finishing department to calculate the cost of product which is transferred out of the Finishing department at the end of the period and the balance remaining in WIP Finishing. (17 marks)

The Ludwig Factory produces expensive bags. The Ludwig Factory has two departments that process all the bags, Sewing and Finishing. Conversion costs are added evenly throughout both of the production processes. Direct materials are added at the beginning of the Sewing process During January, the beginning work in process in the Sewing department was 40% complete for conversion costs and 100% complete for direct materials. The beginning inventory included $6,000 for materials and $18,000 for conversion costs. Ending work- in-process inventory in the tanning department was 40% complete for conversion costs and 100% for direct materials. Beginning work in process in the Finishing department was 60% complete as to conversion. Beginning inventories included $7,000 for transferred-in costs and S10,000 for conversion costs. No direct materials were added in the Finishing department. Ending inventory was 30% complete Additional information about the two departments follows: Sewin Finishin eginning work-in-process units Units started this period nits transferred out this period Ending work-in-process units 5,00 14,00 16,00 4.0 18,000 $18,00 32,000 50,00 aterial costs added onversion costs S19,00 Transferred-out cost