Very confused, please help

7-2A

The beginning inventory at Funky Party Supplies and data on purchases and sales for a three-month period are shown (see attachment)

1. Record the inventory, purchases and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated (see attachment), 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.

3. Determine the ending inventory cost as of March 31, 2016

\fProblem 7-2A Name: Section: Score: Instructions Key Code: 0% [Key code here] Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (*) will appear to the right of an incorrect entry. In part 1, only final inventory cost - Column K - will be graded. 1. Date Jan. 1 10 28 30 Feb. 5 10 16 28 Quantity Purchases Unit Cost Total Cost Cost of Merchandise Sold Unit Total Quantity Cost Cost Quantity 2,500 Inventory Unit Cost $60.00 $ Total Cost 150,000 Mar. 5 14 25 30 31 Balances 2. Total sales Total cost of goods sold Gross profit 3. Ending inventory cost