please help, i'm very lost
Required information Problem 5-1A (Algo) Perpetual: Alternative cost flows LO P3 [The following information applies to the questions displayed below.) Warnerwoods Company uses a perpetual Inventory system. It entered into the following purchases and sales transactions for March Date Activities Unito acquired at Coat Units sold at Retan March 1 Beginning inventory 230 units $53.60 per unit March 5 Purchase 290 units $58.60 per unit March 9 Sales 390 unito e $88.60 per unit March 18 Purchase 150 units $63.60 per unit March 25 Purchase 280 units 8 $65.60 per unit March 29 Sales 260 units $98.60 per unit Totala 950 unita 650 units 3. Compute the cost assigned to ending inventory using (2) FIFO, (B) LIFO, (c) weighted average, and (a specific identification. For specific identification, units sold include 130 units from beginning inventory, 260 units from the March 5 purchase, 110 units from the March 18 purchase, and 150 units from the March 25 purchase. Complete this question by entering your answers in the tabs below. Perpetual FIFO Perpetual LIFO Weighted Average Specific id Compute the cost assigned to ending inventory using FIFO. Perpetual FIFO Goods Purchased Cost of Goods Sold Date Cost per # of units # of units Cost per cost of Goods Sold unit sold unit March 1 Cost per Inventory Balance units Inventory unit Balanco 230 at $ 53.60 $ 12,328.00 230 at $53.60 - $ 12,328,00 290 at $ 58.60 16,994.00 $ 29,322.00 290 at $ 58.60 March 5 Total March 5 $ at March 9 230 at 160 at $ 53,60 $ 58,60 12,328.00 9,376.00 21,704.00 $ 53,60 $ 58,60 = 130 at 7,618.00 $ 7,618.00 Total March 9 $ Al 2901 at $ 58.60 March 5 230 at 290) at $ 53.60 = $ 58.60 = $ 12,328.00 16,994.00 $ 29,322.00 Total March 5 $ A at March 9 230 at 160 at $ 53.60 $ 58.60 12,328.00 9,376,00 21,704.00 $53.60 $ 58.60 = 130 at Total March 9 7,618.00 $ 7,618.00 $ 150 at $ 63.60 at March 18 130 at 150 at $ 53.60 $ 58.60 = $63.60 = 7,618.00 9,540.00 $ 17,158.00 Total March 18 280 at $ 65.60 at March 25 130 at 150) at 280 at $53.60 $ 58.60 = $63.60 = $65.60 - 7,618.00 9,540.00 18,368.00 $ 35,526.00 Total March 25 = 1 $ at at 1301 at 130 at 11 March 29 $53.60 $ 58.60 $63.60 $ 65.60 0.00 7,618.00 8,268.00 0.00 15,886.00 37,590.00 ## $53.60 $ 58.60 $ 63.60 = $ 65,60 - at 20 at 280) at at 1,272.00 18,368.00 $ 19,640.00 $ 19,640.00 $ Total March 29 Totals $ Perpetual LIFO: Cost of Goods Sold Date Goods Purchased Cost per # of units Cost per # of units sold Cost of Goods Sold Inventory Balance Cost per Inventory # of units unit Balance 230 at $ 53.60 - $ 12,328.00 unit unit March 1 $ 58.60 290) at $ 53,60 = $ 12,328.00 March 5 230 at 290) at $ 58.60 = 16,994.00 Total March 5 $ 29,322.00 11 en 130 at $ 6,968.00 March 9 100 at 290) at $ 53.60 $ 58.60 $ 5,360.00 16,994.00 $ 22,354.00 $ 53.60 = $ 58.60 = 11 at $ 6,968.00 Total March 9 at $ 130 150 6,968.00 at $63.60 at March 18 $53.60 = $ 58.60 $ 63.60 150 at 9,540.00 $ 16,508.00 Total March 18 $ 65.60 280 at 130 at $ $ 53,60 = 6,968.00 at March 25 150 at 280 at $ 58.60 $63.60 = $ 65.60 9,540.00 18,368.00 $ 34,876.00 Total March 25 7 52 An nnn 120l at 52 FORR Onl 100 at = $ 130 at $ 6,968.00 March 9 $ 53.60 $ 58,60 $ 5,360.00 16,994.00 $ 22,354.00 $ 53.60 = $ 58.60 = 290) at at Total March 9 $ 6,968.00 $ 63.60 150 at $ 6,968.00 130 at at March 18 $ 53.60 = $ 58.60 $63.60 = 150 at 9,540.00 $ 16,508.00 Total March 18 $ 280 at $ 65,60 6,968.00 March 25 130 at at 150 at 280 at $53.60 $58,60 $63.60 - $ 65,60 9,540.00 18,368.00 $ 34,876.00 Total March 25 at = $ 130 at $ 6,968.00 at at March 29 $ 53.60 $ 58.60 $63.60 $ 65,60 0.00 0.00 0.00 17,056.00 $ 17,056.00 $ 53.60 - $ 58.60 $ 63.60 $ 65,60 = at 260 at 150 at 20 at = 9,540.00 1,312.00 $ 17,820.00 Total March 29 Totals $ 39,410.00 $ 17,820.00 Weighted Average Perpetual Cost of Goods Sold Cost per unit Cost of Goods Sold Goods Purchased Cost per # of units unit Date # of units sold # of units Inventory Balance Cost per Inventory Balance unit $ 53.60 - $ 12,328.00 March 1 230 at 290 at $ 58.60 at $ 53.60 58.60 520 at $ March 5 Average March March 9 30.472.00 $ 30,472.00 520 at 390) at 56.38 $ 21.988.20 130 at $ 56.38 $ 7,329.40 150 at $63.60 $ 130 at 280 at 410 at $ $ 56.38 63.60 March 18 Average March 18 $ 7,329.40 17,808.00 $ 25,137.40 March 25 Average March 25 March 29 Totals $ 21,988.20 WYSTERY Yunawa Los Ven. Perpetual FIFO Perpetual LIFO Weighted Average Specific id Compute the cost assigned to ending inventory using specific identification. For specific identification, units sold include 130 units from beginning inventory. 260 ut 5 purchase, 110 units from the March 18 purchase, and 150 units from the March 25 purchase. Specific Identification: Goods Purchased Costel Goods Sold Inventory Balance Date #of units Cost per Goods of unite Cost per cost of Goods Sold unit cost per Inventory Balance Puchaned sold unit Hof units March 1 230 at $53.60 $ 12.328 at 553 60 5 0.00 at 553.80 - $ 0.00 March 5 290 at $ 58.00 - 16,994 $ 58.60 $ 58.60 March 18 150 at $63.60 9,540 at $63.60 0.00 at $63.60 = 0.00 March 25 280 at $ 65,60 $ 18,368 st 5 65.60 $ 65,60 Totals $ 0.00 $ 0.00 $ at al 1