Having trouble with this problem, everytime i think i have the answer all of the numbers don't fit in the chart. can anybody help me out with this?

21. Beginning inventory, purchases, and sales data for widgets are as follows: (10 points) April 3 Invento 15 units 12 units 18 units 7 units 10 units S3 S27 11 Purchase 14 Sale 21 Purchase 25 Sale $25 Complete the inventory cost card assuming the business maintains a perpetual inventory system and calculates the cost of merchandise sold and ending inventory using LIFO Cost of Merchandise Purchases Sold Inventory Unit Total UnitTotal Unit Total Date Qty.CostCostQty.Cs Cost Qty.Cost Cost Total cost of Ending nventory value erchandise sold