having a little trouble with this problem, can someone figure it out?

chronological order, calculating new inventory on hand balances after each transaction. Once allo em 0 Requirements ind nou btal bst 1. Determine the amount that would be reported in ending merchandise inventory on July 15 using the FIFO inventory costing method. 2. Determine the amount that would be reported in ending merchandise inventory on July 15 using the LIFO inventory costing method. 3. Determine the amount that would be reported in ending merchandise inventory on July 15 using the weighted average inventory costing method. (Round all amounts to the nearest cent, $X.XX.) 2 Print Done SE T, calculating new inventory on hand culate the quantity and total cost of merchandise inventory pure 1 More Info C Jul. 2 Purchased 10 gallons @ $1.60 each 6 Purchased 2 gallons @ $1.90 each 8 Sold 4 gallons of milk to a customer 13 Purchased 2 gallons @ $2.35 each 14 Sold 4 gallons of milk to a customer Print Done 4 1.60 6.40 Requirement 2. Determine the amount that would be reported in ending merchandise inventory on July 15 using the LIFO inventory costing method Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the period. (Enter all amounts to the nearest cent, SX.XX. Enter the oldest inventory layers first) Purchases Cost of Goods Sold Inventory on Hand Unit Total Unit Total Unit Total Date Quantity Cost Cost Quantity Cost Cost Quantity Cost Cost Jul. 2 10 1.60 16 2 1.90 3.80 6 8 1.60 6.40 13 2.35 4.70 4 6.40 1.60 14 Totals 14