Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Required information [The following information applies to the questions displayed below.] Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and
Required information [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 March 1 March 5 March 9 March 18 March 25 March 29 Activities Beginning inventory Purchase Sales Purchase Purchase Sales Totals Units Acquired at Cost 240 units @ $53.80 per unit 295 units @ $58.80 per unit Units Sold at Retail 155 units @ $63.80 per unit 290 units @ $65.80 per unit 980 units 400 units $88.80 per unit 270 units @ $98.80 per unit 670 units Perpetual FIFO Perpetual LIFO Weighted Average Specific Id Compute the cost assigned to ending inventory using FIFO. Goods Purchased Perpetual FIFO: Cost of Goods Sold Date # of units Cost per # of units unit sold Cost per unit Cost per Cost of Goods Sold # of units unit March 1 240 at $ 53.80 = 295 at $58.80 240 at March 5 295 at $ 58.80 = Inventory Balance Inventory Balance $ 12,912.00 $53.80 $ 12,912.00 17,346.00 Total March 5 $ 30,258.00 240 at $ 53.80 = $ March 9 0 at $ 58.80 = 12,912.00 0.00 0 at 135 at $ 53.80 $ 58.80 = Total March 9 $ 12,912.00 7,938.00 $ 7,938.00 155 at $63.80 March 18 0 at 135 at 0 at $ 53.80 $ 58.80 = $ 63.80 7,938.00 Total March 18 $ 7,938.00 290 at $65.80 0 at 135 at $ 53.80 $ 58.80 = March 25 155 at $ 63.80 = 290 at $ 65.80= 7,938.00 9,889.00 19,082.00 Total March 25 $ 36,909.00 0 at 135 at $ 53.80 = $ $ 58.80 = 0.00 7,938.00 March 29 135 at $ 63.80 = 8,613.00 0 at O at 155 at $ 53.80 $ 58.80 $ 63.80 = 0 at $ 65.80 = 0.00 290 at $ 65.80= Total March 29 Totals $ 16,551.00 $ 29,463.00 9,889.00 19,082.00 $ 28,971.00 $ 28,971.00 Perpetual FIFO Perpetual LIFO Weighted Specific Id Average Compute the cost assigned to ending inventory using LIFO. March 1 March 5 Goods Purchased Perpetual LIFO: Cost of Goods Sold Date Cost per # of units # of units unit sold unit Cost per Cost of Goods Sold # of units 240 at Total March 5 March 9 Total March 9 March 18 Total March 18 March 25 Total March 25 March 29 Total March 29 Totals $ 0.00 Inventory Balance Cost per unit $ 53.80= Inventory Balance $ 12,912.00 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.) March 1 Weighted Average Perpetual: Goods Purchased Cost of Goods Sold Date # of units Cost per unit # of units sold Inventory Balance Cost per Cost per unit Cost of Goods Sold # of units Inventory Balance unit 240 at $ 53.80 = $ 12,912.00 March 5 Average March 5 March 9 March 18 Average March 18 March 25 Average March 25 March 29 Totals $ 0.00 < Perpetual LIFO Specific Id> 3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. For specific identification, units sold include 135 units from beginning inventory, 265 units from the March 5 purchase, 115 units from the March 18 purchase, and 155 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 specific identification. For specific identification, units sold include 135 units from beginning inventory, 265 units from the March 5 purchase, 115 units from the March 18 purchase, and 155 units from the March 25 purchase. Specific Identification Goods Available for Sale Cost of Goods Sold Ending Inventory Date # of units Cost per Cost of Goods Available for unit # of units sold Cost per unit Cost of Goods Sold # of units in ending Cost per unit Ending Inventory Sale inventory $ 0 $ 0.00 $ 0 $ 0.00 $ 0 0 0.00 0 0.00 0 0 0.00 0 0.00 0 0 0.00 0 0 $ 0 0 $ 0 0 $ 0 March 1 March 5 March 18 March 25 Total < Weighted Average Specific Id >
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