I'm not sure if my table is filled out correctly and also not sure how to fill out the bottom table! any help is appreciated!

Required information [The following information applies to the questions displayed below) Hemming Company reported the following current-year purchases and sales for its only product. Date Activities Units Acquired at Cost January 1 Units sold at Retail Beginning inventory 200 units @ $10 $ 2,000 January 10 Sales March 14 150 units Purchase @ $40 350 units @ $15 5,250 March 15 Sales 300 units July 30 @ $40 Purchase 450 units @ $20 9,800 October 5 Sales 430 units October 26 @ $40 Purchase 100 units @ $25 2.500 Totals 1,100 units $ 18,750 889 units Ending inventory consists of 45 units from the March 14 purchase, 75 units from the July 30 purchase, and all 100 units from the October 26 purchase. Using the specific identification method, calculate the following. Ending inventory consists of 45 units from the March 14 purchase, 75 units from the July 30 purchase, and all 100 units from the October 26 purchase. Using the specific identification method, calculate the following a) Cost of Goods Sold using Specific Identification Available for Sale Date Activity # of units Cost Per Unit 200 Beginning Inventory Purchase January 1 March 14 July 30 October 26 350 Cost of Goods Sold Ending Inventory # of Ending Ending Cost Per Cost Per units COGS Inventory Inventory Unit Unit sold Units Cost o $ 10.00 $ 0 200 $ 10.00 $ 2,000 305 $ 15.00 4,575 45 $ 15.00 675 375 $ 20.00 7.500 75 $ 20.00 1,500 0 $ 25.00 0 100 $ 25.00 2,500 680 $ 12,075 420 $ 6,675 $ 10.00 $ 15.00 $ 20.00 $ 25.00 450 Purchase Purchase 100 1.100 b) Gross Margin using Specific identification Sales $ 35,200 Less: Cost of goods sold Equals: Gross profit