Part 2 of 4 Problem 5-1A Perpetual: Alternative cost flows LO P1 [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 5 points for March SOM Units sold at Retail Date Activities Mar. 1 Beginning inventory Mar. 5 Purchase Mar Mar. 18 Purchase Mar. 25 Purchase Mar. 29 Sales Totals Units Acquired at Cost 230 units 553.60 per unit 290 units 558.60 per unit 150 units $63.60 per unit 280 units 165.60 per unit 390 units 558.60 per unit 260 units@ 98.60 per unit 650 units Goods Purchased # of units unit Cost per Cost of Goods Sold # of units Cost per Cost of Goods Sold sold unit Date March 1 Inventory Balance # of units Cost per Inventory Balance unit 230 @ $53.60 = $ 12,328.00 230 @ $ 53,60 = $ 12,328.00 290 @ $ 58,60 - 16,994.00 $ 520 $ 29,322.00 112 20 March 5 290 @ 558,60 Average March 9 March 18 Average March 25 March 29 Totals $ 0.00 Perpetual FIFO: Cost of Goods Sold Part 3 of 4 Goods Purchased # of units unit Cost per Date # of units sold Cost per Cost of Goods Sold March 1 25 points March 5 290 @ $ 58,60 00:13:44 March 9 $ 230 @ 290 @ 553.60 $ 58 60 12.328 00 16.99400 29.322.00 Inventory Balance Inventory Cost per # of units unit Balance 230 @ 553.60 $ 12,328.00 230 @ $53.60 $ 12.328.00 290 $58,60 16,994.00 $ 29,322.00 230 $53.60 $ 12,328.00 290 e $58.60 16.994.00 5 29 32200 230 553 60 $ 12.328.00 290 558 60 - 16.99400 150 563.60 9,54000 $ 38,06200 230 553.60 $12328.00 2901 558,601 16.99400 $ March 18 150 $63.60 March 25 280 $65 60 Required information $ 38,862.00 March 25 280 @ $65.60 230 @ 290 @ 150 280 @ $ 53.60 = $58,60 = $63.60 - $ 65,60 = $ 12,328.00 16,994.00 9,540.00 18.368.00 $ 57 230.00 $ 3:24 March 29 230 290 @ 150 @ 280 @ $53.60 $ 58.60 $63.60 5 65.60 12 328.00 16,994.00 9,540.00 18,368.00 57.230.00 86,552.00 230 @ 290 @ 150 280 @ $53.60 $ 58,60 $ 63,60 = $ 65,60 - $ 12,328,00 16.994.00 9,540.00 18,368 00 $ 57,230.00 $ 57,230.00 $ S Totals Perpetual LIFO > Required information Goods Purchased # of units unit Cost per W of units sold Cost of Goods Sold Cost per cost of Goods Sold unit Date Inventory Balance Cost per Inventory W of units unit Balance 230 @ $53.60 = $ 12,328.00 March 1 March 5 290 @ $58.60 230 @ 290 @ $53.60 = $58,60 = $ 12,328,00 16,994.00 $ 29,322.00 March 9 230 290 $53.60 $58.60 $ 12.328 00 16.994.00 $ 29,322.00 230 @ 290 @ $53.60 - $58,60 = $ 12.328.00 $ 16,994.00 $ 29,322.00 March 18 1501 $63.60 230 @ 290 150 $53.60 $ 58 60 - $63.60 $ 12.328.00 16.99400 9.540.00 $ 38,862.00 March 25 280 5 65 60 230 @ 290 $ 53.60 $ 58 60 - $ 12.328.00 16.99400 March 25 280 @ $ 65,60 230 @ 290 @ 150 @ 280 @ 553.60 = $ 58,60 = $63.60 = $ 65,60 $ 12,328.00 16,994 00 9,540.00 18,368 00 $ 57,230.00 March 29 19 230 @ 290 @ 150 @ 280 @ $53.60 5 58.60 563.60 565 60 $ 12.328 00 16,994.00 9,540.00 18.368.00 $ 57 230.00 $ 86.55200 230 290 @ 150 2801 $ 53.60 = 5 58 60 - $63.60 - 565 60 = $ 12,328,00 16,994 00 9,540.00 18,368 00 $ 57,230.00 $ 57.230.00 Totals Perpetual FIFO Weighted Average > Inventory Balance Cost per Inventory Balance Cost per Cost of Goods Sold Cost per cost of Goods Sold unit # of units Weighted Average Perpetual: Goods Purchased of Date units unit March 1 March 5 290 558 60 # of units sold unit $53.60 = 230 2301 290 @ 520 $53.60 = 5 58 60 = 5 112 20 $ 12,328 00 $ 12.328.00 16.99400 $ 29 32200 1 Average March March 18 Average March 25 do Part 2 of 4 Problem 5-1A Perpetual: Alternative cost flows LO P1 [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 5 points for March SOM Units sold at Retail Date Activities Mar. 1 Beginning inventory Mar. 5 Purchase Mar Mar. 18 Purchase Mar. 25 Purchase Mar. 29 Sales Totals Units Acquired at Cost 230 units 553.60 per unit 290 units 558.60 per unit 150 units $63.60 per unit 280 units 165.60 per unit 390 units 558.60 per unit 260 units@ 98.60 per unit 650 units Goods Purchased # of units unit Cost per Cost of Goods Sold # of units Cost per Cost of Goods Sold sold unit Date March 1 Inventory Balance # of units Cost per Inventory Balance unit 230 @ $53.60 = $ 12,328.00 230 @ $ 53,60 = $ 12,328.00 290 @ $ 58,60 - 16,994.00 $ 520 $ 29,322.00 112 20 March 5 290 @ 558,60 Average March 9 March 18 Average March 25 March 29 Totals $ 0.00 Perpetual FIFO: Cost of Goods Sold Part 3 of 4 Goods Purchased # of units unit Cost per Date # of units sold Cost per Cost of Goods Sold March 1 25 points March 5 290 @ $ 58,60 00:13:44 March 9 $ 230 @ 290 @ 553.60 $ 58 60 12.328 00 16.99400 29.322.00 Inventory Balance Inventory Cost per # of units unit Balance 230 @ 553.60 $ 12,328.00 230 @ $53.60 $ 12.328.00 290 $58,60 16,994.00 $ 29,322.00 230 $53.60 $ 12,328.00 290 e $58.60 16.994.00 5 29 32200 230 553 60 $ 12.328.00 290 558 60 - 16.99400 150 563.60 9,54000 $ 38,06200 230 553.60 $12328.00 2901 558,601 16.99400 $ March 18 150 $63.60 March 25 280 $65 60 Required information $ 38,862.00 March 25 280 @ $65.60 230 @ 290 @ 150 280 @ $ 53.60 = $58,60 = $63.60 - $ 65,60 = $ 12,328.00 16,994.00 9,540.00 18.368.00 $ 57 230.00 $ 3:24 March 29 230 290 @ 150 @ 280 @ $53.60 $ 58.60 $63.60 5 65.60 12 328.00 16,994.00 9,540.00 18,368.00 57.230.00 86,552.00 230 @ 290 @ 150 280 @ $53.60 $ 58,60 $ 63,60 = $ 65,60 - $ 12,328,00 16.994.00 9,540.00 18,368 00 $ 57,230.00 $ 57,230.00 $ S Totals Perpetual LIFO > Required information Goods Purchased # of units unit Cost per W of units sold Cost of Goods Sold Cost per cost of Goods Sold unit Date Inventory Balance Cost per Inventory W of units unit Balance 230 @ $53.60 = $ 12,328.00 March 1 March 5 290 @ $58.60 230 @ 290 @ $53.60 = $58,60 = $ 12,328,00 16,994.00 $ 29,322.00 March 9 230 290 $53.60 $58.60 $ 12.328 00 16.994.00 $ 29,322.00 230 @ 290 @ $53.60 - $58,60 = $ 12.328.00 $ 16,994.00 $ 29,322.00 March 18 1501 $63.60 230 @ 290 150 $53.60 $ 58 60 - $63.60 $ 12.328.00 16.99400 9.540.00 $ 38,862.00 March 25 280 5 65 60 230 @ 290 $ 53.60 $ 58 60 - $ 12.328.00 16.99400 March 25 280 @ $ 65,60 230 @ 290 @ 150 @ 280 @ 553.60 = $ 58,60 = $63.60 = $ 65,60 $ 12,328.00 16,994 00 9,540.00 18,368 00 $ 57,230.00 March 29 19 230 @ 290 @ 150 @ 280 @ $53.60 5 58.60 563.60 565 60 $ 12.328 00 16,994.00 9,540.00 18.368.00 $ 57 230.00 $ 86.55200 230 290 @ 150 2801 $ 53.60 = 5 58 60 - $63.60 - 565 60 = $ 12,328,00 16,994 00 9,540.00 18,368 00 $ 57,230.00 $ 57.230.00 Totals Perpetual FIFO Weighted Average > Inventory Balance Cost per Inventory Balance Cost per Cost of Goods Sold Cost per cost of Goods Sold unit # of units Weighted Average Perpetual: Goods Purchased of Date units unit March 1 March 5 290 558 60 # of units sold unit $53.60 = 230 2301 290 @ 520 $53.60 = 5 58 60 = 5 112 20 $ 12,328 00 $ 12.328.00 16.99400 $ 29 32200 1 Average March March 18 Average March 25 do