instructions: Doofenshmir vil Inc uses the perlodic inventory system. They make quarterly purchases of inventory as outlined below. Doofenshmirtz uses the FIFO Inventory method. However, the CEO, Heine, would like you to calculate Cogs and ending inventory for each of the three methods: FIFO, LIFO, and weighted average, in order to assist management in deciding to keep or change the method. Complete the tables and answer two questions below Description Beginning Inventory Jan. 31 Purchase April 31 Purchase July 31 Purchase Oct. 31 Purchase 2020 Sales Ending Inventory of Units 1,200 14,000 10,000 12,400 5,500 40,000 3.100 Cost per Unit $4,50 $4.65 $4.75 $5.00 $4.90 Total Cost $5,400 $65,100 $47,500 $62,000 $26,950 FINAL STEP Beg Inventory Purchases COGAFS End. Inventory COGS FIFO $5,400 $201.550 $206.950 LIFO $5,400 $201.550 $206,950 Weighted Avy $5,400 $201.550 $206,950 Description Oct. 21 Purchase FIFO Ending Inventory Nof Units Cost per unit Totol Cost UFO Ending Inventory of Units Cost per Unit Total Cost Description Beg, inventory Man 31 Purchase Total Total 3,100 50 3.100 SO The inventory costing method that results in the lowest COGS : The inventory costing method that results in the highest ending inventory is 43.100 Weighted Average Ending inventory Total Cost of Units Available Total Units Available Rate per Unit Rof Units in Inding Inv. S$ in Ending Inventory 3,100 3 0 1 2