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. Units Sold at Retail Units Acquired at Cost 70 units @ $50.40 per unit 210 units @ $55.40 per unit Date March 1 March 5 March 9 March 18 March 25 March 29 Activities Beginning inventory Purchase Sales Purchase Purchase Sales 230 units @ $85.40 per unit 70 units 120 units @ $60.40 per unit @ $62.40 per unit 100 units_@ $95.40 per unit 330 units Totals 470 units 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 50 units from beginning inventory, 180 units from the March 5 purchase, 30 units from the March 18 purchase, and 70 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 Date Googs Purcnased Cost per # of units unit # of units sold COST OT Goods Sola Cost per cost of Goods Sold unit inventory Balance Cost per Inventory # of units unit Balance 70 at $ 50.40 = $ 3,528.00 March 1 210 at $ 55.40 70 at March 5 $ 50.40 = $ 55.40 = 210 at $ 3,528.00 11,634.00 $ 15,162.00 Total March 5 70 at 0 at March 9 $ 50.40 $ 55.40 $ $ 160 at 3,528.00 8,864.00 12,392.00 $ 50.40 $ 55.40 = 50 at 2,770.00 $ 2,770.00 Total March 9 70 at $ 60.40 0 at $ 50.40 $ 55.40 = March 18 50 at 701 at $ 60.40 = 2,770.00 4,228.00 $ 6,998.00 Total March 18 120 at $ 62.40 0 at 501 at March 25 $ 50.40 $ 55.40 = $ 60.40 = $ 62.40 = 70 at 120 at 2,770.00 4,228.00 7,488.00 $ 14,486.00 Total March 25 at = $ 0 at $ 50.40 50 at 0 at $ 55.40 March 29 $50.40 $ 55.40 $ 60.40 $ 62.40 at = 0.00 2,770.00 4,228.00 0.00 6,998.00 70 at 4,228.00 $ 60.40 = $ 62.40 = at 120 at 7,488.00 Total March 29 $ $ 11,716.00 $ 11,716.00 Totals $ 19,390.00 Date # of units Cost per unit # of units sold Cost per unit Cost of Goods Sold # of units Cost per unit Inventory Balance $ 3,528.00 March 1 70 at $ 50.40 2101 at $ 55.40 701 at $ 50.40 = $ 3,528.00 March 5 210 at $ 55.40 = 11,634.00 Total March 5 $ 15,162.00 230 at $ 50.40 = $ 11,592.00 0 at $ 50.40 = March 9 210 at $ 55.40 160 at $ 55.40 = $ 11,634.00 $ 23,226.00 8,864.00 8,864.00 Total March 9 $ 70 at $ 60.40 0 at March 18 160 at 70 at $ 50.40 $ 55.40 = $ 60.40 = 8,864.00 4,228.00 $ 13,092.00 Total March 18 120 at $ 62.40 0 at $ 50.40 March 25 160 at 70 at $ 55.40 = $ 60.40 = $ 62.40 8,864.00 4,228.00 7,488.00 $ 20,580.00 120 at Total March 25 0 at $ 50.40 at 160 at 160 at March 29 70 $ 50.40 $ 55.40 = $ 60.40 = $ 62.40 $ 55.40 $ 60.40 $ 62.40 at $ 0.00 8,864.00 4,228.00 7,488.00 $ 20,580.00 111 70 at 120 at 8,864.00 4,228.00 7,488.00 120 at = Total March 29 $ 20,580.00 Totals $ 43,806.00 $ 20,580.00 Weighted Average Perpetual: Goods Purchased Cost of Goods Sold Inventory Balance Date Cost per # of units Cost per unit # of units sold Cost per unit Cost of Goods Sold of units unit Inventory Balance March 1 70 at $ 50.40 = 3,528.00 March 5 Average March 5 March 9 March 18 Average March 18 March 25 Average March 25 March 29 Totals $ 0.00 Specific Identification: Goods Purchased Cost of Goods Sold Inventory Balance Date Cost per Cost per # of units # of units sold # of units March 1 70 at = Cost per Cost of Goods Sold unit $ 50.40 0.00 $ 55.40 at = at Goods Puchased $ 3,528 11,634 4,228 $ 7,488 March 5 210 unit $ 50.40 $ 55.40 $ 60.40 $ 62.40 at II at Inventory Balance unit $ 50.40 = $ 0.00 $ 55.40 $ 60.40 = 0.00 $ 62.40 at II March 18 70 at II at II 0.00 at $ 60.40 $ 62.40 March 25 120 at = = at = at = Totals $ 0.00 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