pls can u answer this question on an excel sheet and pls answer it step by step

Question 5 (20 marks) ABC Company has several processing departments. Costs to be accounted for in the assembly department for October were, $ 1,202,400. Work in Process Inventory, Oct 1 $29,000 Direct Materials $16,500 Conversion Costs $916,000 Direct Materials Added During Oct $100,000 DirectLabour $140,900 Manufacturing Overhead 25,000 units were in beginning work In process. I 425,000 units started this month. 35,000 units in ending Inventory. 40% complete In terms of conversion costs. 1005's of Direct Materials are added at the start. Instructions A. Determine the equivalent units of production and unit production costs for the assembly department. B. Determine the assignment of costs to goods completed and transferred out, and work in process inventory. C. Prepare a production cost report for the assembly department for October