Please do 17-38 in excel and show work.

17-38 FIFO method (continuation of 17-36). 1. Do Problem 17-36 using the FIFO method of process costing. Explain any difference between the cost per equivalent unit in the assembly department under the weighted average method and the FIFO method. 2. Should Hoffman's managers choose the weighted-average method or the FIFO method? Explain briefly. 17-36 Weighted-average method. Hoffman Company manufactures car seats in its Boise plant. Each car seat passes through the assembly department and the testing department. This problem focuses on the assembly department. The process-costing system at Hoffman Company has a single direct-cost category (direct materials) and a single indirect-cost category (conversion costs). Direct materials are added at the beginning of the process. Conversion costs are added evenly during the process. When the assembly de- partment finishes work on each car seat, it is immediately transferred to testing. Hoffman Company uses the weighted-average method of process costing. Data for the assembly de- partment for October 2017 are as follows: Direct Materials $1,248,000 Conversion Costs $ 241,650 Work in process, October 1a Started during October 2017 Completed during October 2017 Work in process, October 315 Total costs added during October 2017 Physical Units (Car Seats) 4,000 22,500 26,000 500 $4,635,000 $2,575,125 Degree of completion: direct materials,?%; conversion costs, 45%. Degree of completion: direct materials,?%; conversion costs, 65%. 1. For each cost category, compute equivalent units in the assembly department. Show physical units in the first column of your schedule. 2. What issues should the manager focus on when reviewing the equivalent-unit calculations? 3. For each cost category, summarize total assembly department costs for October 2017 and calculate the cost per equivalent unit. 4. Assign costs to units completed and transferred out and to units in ending work in process