PR6-2A LIFO perpetual inventory. I kinda know how to do it but not really. The excel spreadsheet is what I need to fillout and I have the start but im missing numbers

Funky party supplies March 31, 2016

OBJ. 2, 3 PR 6-2A LIFO perpetual inventory The beginning inventory at Funky Party Supplies and data on purchases and sales for a three-month period are shown in Problem 6-1A. Instructions 1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 5, using the last-in, first-out method 2. Determine the total sales, the total cost of merchandise sold, and the gross profit from sales for the period. J. Dermine the cading inventory cost as of March 1. 2016