Please finish the chart and use the LIFO method to determine gross profit.

Requirement 2. Prepare a perpetual inventory record, using the LIFO inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit. Begin by computing the cost of goods sold and cost of ending merchandise inventory 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 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 May 1 155 $ 71 $ 11,005 Quantity Cost Cost 95 $ 40 $ 3,800 95 $ 40 $ 3,800 155 $ 71 $ 11,005 - 70$ 40 155 $ 25 $ 71 $ 11,005 40 Totals Data Table May 5 Purchase 13 Sale 155 crates @ 180 crates @ 193 crates @ 200 crates @ $ $ $ $ 71 each 104 each 75 each 106 each 18 Purchase 26 Sale Print Print Done Done