*****please do all of these 4 parts clear enough to understand as it was posted here before but could not understand so i am reposting it here. ****If you cant provide clear enough or cant do all 4 parts ****please leave for another expert to do it besides doing this and wasting my time. thank you. if possible then please do in some type of excel boxes so i could understand well or know what number goes where. thank you

2 1 of 2 Required information Use the following information for the Exercises below. (The following information applies to the questions displayed below: Laker Company reported the following January purchases and sales data for its only product. Date Activities Unite Aquired at cost Une sold til Jan. 1 Beginning inventory 145 unitse 3700 11,015 Jan. 10 Sales 105 $16.00 Jan. 20 Purchase 70 unitat 16.00 - 420 Jan. 25 Sales 35 units. $16.00 Jan. 30 Purchase 190 E 15.50 - 1,049 Totale 405 units 52,480 190 wts d Bo The Company uses a perpetual inventory system. For specific identification, ending inventory consists of 215 units, where 190 are from the January 30 purchase, 5 are from the January 20 purchase, and 20 are from beginning inventory H Exercise 5-3 Perpetual: Inventory costing methods LO P1 D Required: 1. Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification 2. Determine the cost assigned to ending inventory and to cost of goods sold using weighted average 3. Determine the cost assigned to ending inventory and to cost of goods sold using FIFO 4. Determine the cost assigned to ending inventory and to cost of goods sold using LIFO References Complete this question by entering your answers in the tabs below. Required Required 2 Required) Required Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification (Round cost per un to cena places) Specific dentification Available for Sale Unit UNE Cost Activity Purchase Date Cost of Goods Sold Ending weten Ending Ending Unt Unit Cost Sold COGS Cost Per Inventory Inventory Unit Una Com 125 $ 700 875 2015 700 140 65 16.00 5 390 5$ 8.00 $ 30 110 190 $ 125 215 5 10 Beginning inventory Purchase Purchase 145 $ 7.00 70 58.00 100 405 Jan 20 Jan 30 Required 2 ) Next > 4182 (Required 2 Required 1 Required 2 Required 3 Required 4 Determine the cost assigned to ending Inventory and to cost of goods sold using LIFO. (Round cost per unit to 2 decimal places.) Perpetual LIFO Goods Purchased # of Cost units per unit Cost of Goods Sold # of units Cost Cost of Goods sold per unit Sold Cost per Date Inventory Balance # of units Inventory unit Balance 145 @ $ 7.00 $ 1,015.00 January 1 January 10 January 20 January 25 January 30 Totals Required