Do not do the Specific Identification method for either problem. Thank You!

And pls use excel.

Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. (For specific identification, the March 9 sale consisted of 80 units from beginning inventory and 340 units from the March 5 purchase; the March 29 sale consisted of 40 units from the March 18 purchase and 120 units from the March 25 purchase.) Date Activities Units Acquired at Cost Units Sold at Retail Mar. 9 420 units @ $85.00 per unit Mar. 1 Beginning inventory 100 units @ $50.00 per unit Mar. 5 Purchase 400 units @ $55.00 per unit Sales Mar. 18 Purchase 120 units @ $60.00 per unit Mar. 25 Purchase 200 units @ $62.00 per unit Mar. 29 Sales Totals 820 units 160 units @ $95.00 per unit 580 units Required 1. Compute cost of goods available for sale and the number of units available for sale. 2. Compute the number of units in ending inventory. 3. Compute the cost assigned to ending inventory using (a) FIFO, (6) LIFO, (c) weighted average, and (d) specific identification. (Round all amounts to cents.) Check (3) Ending inventory: FIFO, $14,800; LIFO, $13,680; WA, $14,352 4. Compute gross profit earned by the company for each of the four costing methods in part 3. (4) LIFO gross profit, $17,980 Problem 5-2AA Periodic: Alternative cost flows @ P3 Refer to the information in Problem 5-1A and assume the periodic inventory system is used. Required 1. Compute cost of goods available for sale and the number of units available for sale. 2. Compute the number of units in ending inventory. 3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. (Round all amounts to cents.) 4. Compute gross profit earned by the company for each of the four costing methods in part 3