please follow the format of the columms

For both parts (1) and (2), assume that the company uses perpetual inventory and that there are 200 units left in ending inventory. (1) Prepare the attached chart 1 using the specific identification method. For the March 15 sale, assume that all 300 units came from the March 14 purchase. For the October5 sale, assume that 40 units came from beginning inventory, 30 came from the March 14 purchase, and the rest from the July 30 purchase. For the specific identification example, you do not have to adjust to the physical count (you do in practice, I'm just not having you do it here). (2) Prepare the attached chart 2 using the FIFO cost flow assumption. Adjust to the physical count. ii 1 a A6 3 Exercise 6-7 Perpetual: Inventory costing methods-FIFO and LIFO P1 Hemming Co. reported the following current-year purchases and sales for its only product. Units Sold at Retail 150 units @ $40 Date Activities Units Acquired at Cost Jan. 1 Beginning inventory 200 units @ $10 - $2,000 Jan. 10 Sales Mar. 14 Purchase 350 units @ $15 5,250 Mar. 15 Sales July 30 Purchase 450 units @ $20 = 9.000 Oct. 5 Sales Oct 26 Purchase 100 units @ $25 = 2.500 Totals 1,100 units $18.750 300 units @ $40 430 units $40 880 units Page 246 Required Hemming uses a perpetual inventory system. Determine the costs assigned to ending inventory and to cost of Chart 1-Specific Identification Date Sales Purchases Inventory Cost of Goods Sold Inventory Balance Beginning Balance Jan 10 Sale March 14 Purchase March 15 Sale July 30 Purchase October 5 Sale