Solve problem #2. Please use an excel or some chart.

Problem #1 ABC Company uses a perpetual inventory system and the information for Product LG58x is shown below. Complete a perpetual inventory sheet for this product using the First-in, First-out (FIFO) Method. March 3rd Inventory 24 units @ $4.00 March 5th Purchased 30 units @ $4.10 March 10th Purchased 24 units @ $4.12 March 18th Sold 10 units @ $11.75 March 20th Sold 30 units @ $11.75 March 28th Purchased 12 units @ $4.15 March 31 st Sold 20 units @ $11.75 Problem #2 Complete a perpetual inventory sheet for the product in the first problem (above) using the Last-in, First-out (LIFO) Method