Please show work in excel. Thank you!

The % of complettion are the same for beginning and ending

4 5 Assembly Department Units Transferred In DM CC 6 Work in process February 1 8000 $45,200 $0 $16,800 7 Degree of completion 100% 0% 50% 8 Transferred in 30000 9 Completed during February 35000 o Work in process February 30 3000 1 Costs added during February $39,550 $136,500 -2 Costs added during February $170,571.43 3 Costs added during February $170,500.00 24 Please show the FIFO and Weighted Average report for this data. Thank you! 25 Other information 26 Direct materials are added at the beginning of the process 27 CC added unformly across the process