If you could do it in excel and show your work that would be amazing. Thank you!

The transferred cost is 30000

Assembly Department Units DM CC Transferred In Work in process February 1 8000 $0 $16,800 $45,200 Started during February ? Completed during February 35000 Costs added during February $39,550 $136,500 ? Degree of completion DM CC BWIP 0% 50% Other information Direct materials are added at the beginning of the process CC added unformly across the process Please show the FIFO and Weighted Average report for this data. Thank you! Assembly Department Units DM CC Transferred In Work in process February 1 8000 $0 $16,800 $45,200 Started during February ? Completed during February 35000 Costs added during February $39,550 $136,500 ? Degree of completion DM CC BWIP 0% 50% Other information Direct materials are added at the beginning of the process CC added unformly across the process Please show the FIFO and Weighted Average report for this data. Thank you