specific id.. asap in spreadsheet form please

6 Required information IThe following information applies to the questions displayed below.] Warnerwoods Company uses a perpetual inventory system. It entered into the following Part 3 of 4 purchases and sales transactions for March. 120 units$51.40 per unit Mar. 1 Beginning inventory Mar. 5 Purchase Mar. 9 Sales Mar. 18 Purchase Mar. 25 Purchase Mar.29 Sales $56.40 per unit 00:3334 280 unitse s86 95 units $61.40 per unit 170 units $63.40 per unit 150 units 430 units $96.40 per unit Totals 620 units 3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO. (c)weighted average, and (d) spe identification. For specific identification, the March 9 sale consisted of 75 units from beginning inventory and 205 units from the March 5 purchase; the March 29 sale consisted of 55 units from the March 18 purchase and 95 units from the March 25 purchase. elow tabs. Complete this questions by entering your answers in the b