Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(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
(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 Units Sold at Retail Date Activities Mar. 1 Beginning inventory Mar. 5 Purchase Mar. 9 Sales Mar. 18 Purchase Mar. 25 Purchase Mar. 29 Sales Totals Units Acquired at Cost 180 units@ $52.60 per unit 265 units @ $57.60 per unit 125 units @ $62.60 per unit 230 units @ $64.60 per unit 340 units @ $87.60 per unit 210 units @ $97.60 per unit 550 units 800 units blem 5-1A Part 3 ompute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. For cific identification, the March 9 sale consisted of 105 units from beginning inventory and 235 units from the March 5 purchase; the ch 29 sale consisted of 85 units from the March 18 purchase and 125 units from the March 25 purchase. Complete this question by entering your answers in the tabs below. petual FIFO Perpetual LIFO Weighted Average Specific Id mpute the cost assigned to ending inventory using FIFO. 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 # of Cost per # of units Cost Date Cost of Goods Sold units unit sold per unit March 1 March 5 265 @ $ 57.60 Inventory Balance Cost # of units Inventory per unit Balance 180 @ $ 52.60 = $ 9,468.00 180 @@ $ 52.60 = $57.60 = 265 $ 9,468.00 15,264.00 $ 24,732.00 March 9 $ 52.60 $ 105 180 @ 160 @ $ 52.60 = $ 57.60 = $ 57.60 9,468.00 9,216.00 18,684.00 Il 105 @ $ 5,523.00 6,048.00 $ 11,571.00 $ March 18 125 @ $ 62.60 105 @ 105 @ 125 @ $ 52.60 = $57.60 = $ 62.60 = $ 5,523.00 6,048.00 7,825.00 $ 19,396.00 March 25 230 @ $ 64.60 125 @ 105 @ 125 @ 230 @ $ 52.60 = $57.60 = $ 62.60 = $ 64.60 = $ 6,575.00 6,048.00 7,825.00 14,858.00 $ 35,306.00 March 29 $ 52.60 $ 0.00 125 105 @ = a | | $ 57.60 $ 62.60 $ 64.60 105 @ 6,048.00 6,573.00 0.00 1.00 31,305.00 $ 52.60 = $57.60 = $ 62.60 = $ 64.60 = 230 @ 20 @ 230 @ $ 6,575.00 13,248.00 1,252.00 14,858.00 $ 35,933.00 $ 35,933.00 $ Totals $ Perpetual FIFO Perpetual LIFO Weighted Average Specific Id Compute the cost assigned to ending inventory using LIFO. Perpetual LIFO: Cost of Goods Sold Goods Purchased # of Cost per units unit Cost Date # of units sold Cost of Goods Sold Inventory Balance Cost Inventory # of units Balance $ 52.60 = $ 9,468.00 per unit per unit March 1 180 @ March 5 265 @ $ 57.60 a) 180 $ 52.60 = 265 @ $57.60 = $ 9,468.00 15,264.00 $ 24,732.00 March 9 $ 3,945.00 105 $ 52.60 = 75 @ 265 @ $ 52.60 $57.60 15,264.00 105 @ $ 57.60 = $ 5,523.00 $ 6,048.00 $ 11,571.00 $ 19,209.00 March 18 125 @ $ 62.60 $ 52.60 = 105 @ 105] @ 125 @ $57.60 = $ 62.60 = $ 5,523.00 6,048.00 7,825.00 $ 19,396.00 March 25 230 a) $ 64.60 $ 52.60 = 125 @ 105 @ 125 @ 230 @ $57.60 = $ 62.60 = $ 64.60 $ 6,575.00 6,048.00 7,825.00 14,858.00 $ 35,306.00 March 29 $ 52.60 II 230 @ $ 57.60 105 @ 210 @ 210 @ 210 @ 210 @ $ 11,046.00 12,096.00 13,146.00 13,566.00 $ 49,854.00 $ 52.60 = $57.60 = $ 62.60 = $ 64.60 = $ 62.60 125 @ $ 12,098.00 6,048.00 7,825.00 1,292.00 $ 27,263.00 $ 64.60 11 20 @ Totals $ 69,063.00 $ 27,263.00 Romotuoliro NAL.bod A 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 weighted average. (Round your average cost per unit to 2 decimal places.) Weighted Average Perpetual: Goods Purchased # of Date Cost per units unit March 1 March 5 $ 57.60 Cost of Goods Sold # of units Cost Cost of Goods sold per unit Sold Inventory Balance Cost # of units per unit Inventory Balance 180 @ $ 52.60 = $ 9,468.00 265 @ 180 @ 265 @ $ 52.60 = $ 57.60 = $ 55.58 = $ 9,468.00 15,264.00 $ 24,732.00 Average 445 @ March 9 340 @ $ 55.58 $ 18,897.20 105 @ $ 55.58= $ 5,835.90 March 18 125 @ $62.60 105 @ 125 @ 230 $55.58 = $ 62.60 = $ 55.58 = $ 5,835.90 7,825.00 $ 13,660.90 Average March 25 230 @ $ 64.60 230 @ 230 @ $ 55.58 = $ 64.60 = $ 64.60 = $ 12,783.40 14,858.00 $ 27,641.40 460 March 29 210 @ $ 62.00 250 @ $ 62.00 = $ 15,500.00 $ 13,020.00 $ 31,917.20 Totals Perpetual FIFO Perpetual LIFO Weighted Average Specific Id Compute the cost assigned to ending inventory using specific identification. For specific identification, the March 9 sale consisted of 105 units from beginning inventory and 235 units from the March 5 purchase; the March 29 sale consisted of 85 units from the March 18 purchase and 125 units from the March 25 purchase. Specific Identification: Goods Purchased # of Date Cost per units unit March 1 Cost of Goods Sold # of units Cost Cost of Goods sold per unit Sold # of units Inventory Balance Cost Inventory Balance per unit $ 52.60 = $ 9,468.00 180 @ March 5 March 9 March 18 March 25 March 29 Totals $ 0.00
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started