please use FIFO method instead of wighted Avergae Method.

19-39 Weighted average method, inspection at 80% completion. [Excel template) (LO 3) Ottawa Manufacturing is a furniture manufacturer with two departments: moulding and finishing. The company uses the weighted-average method of process costing. In August, the following data were recorded for the finishing department: Units of beginning work-in-process inventory Percentage completion of beginning work-in-process units Cost of direct materials in beginning work-in-process Units started Units completed Units in ending inventory Percentage completion of ending work-in-process units Spoiled units Total costs added during current period: Direct materials Direct manufacturing labour Manufacturing overhead Work-in-process, beginning: Transferred-in costs Conversion costs Cost of units transferred in during current period 12,500 25% $ 0 87,500 62,500 25,000 95% 12,500 $819,000 $794,500 $770,000 $103,625 $ 52,500 $809,375 Conversion costs are added evenly during the process. Direct materials costs Conversion costs are added evenly during the process. Direct materials costs are added when production is 90% complete. The inspection point is at the 80% stage of production. Normal spoilage is 10% of all good units that pass inspection. Spoiled units are disposed of at zero net disposal value. Required For August, summarize total costs to account for, and assign these costs to units completed and transferred out (including normal spoilage), to abnormal spoilage, and to units in ending work-in-process