I have this as a homework and i don't understand how to do it can you please explain it for me in excel sheet form , thank you

Question 2 The records of Fremont Corporation's initial and unaudited accounts show the following ending inventory balances, which must be adjusted to actual costs. Units Unaudited Costs Work-in-process Inventory 120.000 $ 793.152 Finished goods inventory 20.000 337,560 As the auditor, you have learned the following information. Ending work-in-process inventory is 40 percent Page 342 complete with respect to conversion costs. Materials are added at the beginning of the manufacturing process, and overhead is applied at the rate of 80 percent of the direct labor costs. There was no finished goods inventory at the start of the period. The following additional information is also available. Costs Units Direct Materials Direct Labor Beginning inventory (80% complete as to labor) 80,000 $ 240,000 $ 546,000 Units started 400,000 Current costs 1.560.000 2.208,000 Units completed and transferred to finished goods inventory 360,000 Required Prepare a production cost report for Fremont using the weighted average method. (Him; You will need to calculate equivalent units for three categories: materials, labor, and overhead.) 12 O W