Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please fix these charts. Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March Units Sold at

Please fix these charts.image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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 110 units @ $51.20 per unit 230 units @ $56.20 per unit Date March 1 March 5 March 9 March 18 March 25 March 29 270 units @ $86.20 per unit Activities Beginning inventory Purchase Sales Purchase Purchase Sales Totals 90 units @ $61.20 per unit 160 units @ $63.20 per unit 140 units @ $96.20 per unit 410 units 590 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 70 units from beginning inventory, 200 units from the March 5 purchase, 50 units from the March 18 purchase, and 90 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: Cost of Goods Sold Cost per Cost of Goods Sold unit Date Goods Purchased Cost per # of units unit # of units sold Inventory Balance # of units Cost per Inventory unit Balance 110 at $ 51.20 = $ 5,632.00 March 1 230 at $ 56.20 March 5 110 at 230 at $ 51.20 = $ 56.20 = $ 5,632.00 12,926.00 $ 18,558.00 Total March 5 at $ 0l at March 9 110 160 $ 51.20 $ 56.20 $ 51.20 $ 56.20 = at 5,632.00 8,992.00 14,624.00 = 70 at 3,934.00 $ 3,934.00 Total March 9 $ 90 at $ 61.20 0 at March 18 70 at 90 at $ 51.20 $ 56.20 = $ 61.20 = 3,934.00 5,508.00 $ 9,442.00 Total March 18 160 at $63.20 0 at 70 at March 25 $ 51.20 $ 56.20 = $ 61.20 = $ 63.20 90 at 3,934.00 5,508.00 10,112.00 $ 19,554.00 160 at Total March 25 0 at = $ 0 at 70 at = 0 at March 29 $ 51.20 $ 56.20 $ 61.20 $ 63.20 $ 51.20 $ 56.20 $ 61.20 = $ 63.20 = 70 at 0.00 3,934.00 4,284.00 0.00 8,218.00 = 20 at 160 at 1,224.00 10,112.00 0 at = $ Total March 29 Totals ulla $ 11,336.00 $ 11,336.00 $ 22,842.00 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 70 units from beginning inventory, 200 units from the March 5 purchase, 50 units from the March 18 purchase, and 90 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 LIFO. Perpetual LIFO: Cost of Goods Sold Date Goods Purchased Cost per # of units unit # of units sold Cost per Cost of Goods Sold Cost per unit Inventory Balance # of units Inventory unit Balance 110 at $ 51.20 = $ 5,632.00 March 1 230 at $ 56.20 110 at $ 51.20 = $ 5,632.00 March 5 230 at $ 56.20 = 12,926.00 Total March 5 $ 18,558.00 40 at $ 2,048.00 70 at $ 3,584.00 March 9 $ 51.20 $ 56.20 $ 51.20 = $ 56.20 = 230 at = 0 at 12,926.00 14,974.00 Total March 9 S $ 3,584.00 90 at $ 61.20 $ 3,584.00 70 at 0 at March 18 $ 51.20 = $ 56.20 $ 61.20 = 90 at 5,508.00 9,092.00 Total March 18 $ 160 at $63.20 70 at $ 3,584.00 0 at March 25 $ 51.20 = $ 56.20 $61.20 = $63.20 90 at 5,508.00 10,112.00 160 at Total March 25 $ 19,204.00 at $ 0.00 70 at = $ 3,584.00 0 at March 29 $ 51.20 $ 56.20 $61.20 $ 63.20 0 at 90 at $ 51.20 $ 56.20 $61.20 = $63.20 = at 0.00 0.00 8,848.00 8,848.00 = 140 at 20 at 5,508.00 1,264.00 $ 10,356.00 Total March 29 $ Totals $ 23,822.00 $ 10,356.00 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 70 units from beginning inventory, 200 units from the March 5 purchase, 50 units from the March 18 purchase, and 90 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 weighted average. (Round your average cost per unit to 2 decimal places.) Weighted Average Perpetual: Cost of Goods Sold Goods Purchased Inventory Balance Date Cost per # of units Cost per unit # of units sold Cost per unit Cost of Goods Sold # of units Inventory Balance unit 51.20 March 1 110 at $ $ 5,632.00 2300 at $ 56.20 110 at $ $ March 5 51.20 = 56.20 = 5,632.00 3,934.00 70 at $ Average March 5 180 at $ 54.58 $ 9,566.00 March 9 270 at $ 54.58 $ 14,736.60 70 at $ 54.58 $ 3,820.60 90 at $ 61.20 70 at $ 54.58 = $ 3,820.60 March 18 at $ 61.20 Average March 18 70 at $ 3,820.60 160 at $ 63.20 March 25 at $ 63.20 Average March 25 0 March 29 Totals $ 14,736.60 3. Compute the cost assigned to ending inventory using (a) FIFO, (6) LIFO, (C) weighted average, and (d) specific identification. For specific identification, units sold include 70 units from beginning inventory, 200 units from the March 5 purchase, 50 units from the March 18 purchase, and 90 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 70 units from beginning inventory, 200 units from the March 5 purchase, 50 units from the March 18 purchase, and 90 units from the March 25 purchase. Specific Identification: Goods Purchased Cost of Goods Sold Inventory Balance Date # of units Cost per cost of Goods Sold # of units Cost per unit $ 51.20 Goods Puchased $ 5,632 # of units sold 0 at unit March 1 110 at = $ 0.00 at March 5 Cost per Inventory Balance unit $ 51.20 = $ 0.00 $ 56.20 $ 61.20 0.00 230 at = 0 at $ 51.20 $ 56.20 $ 61.20 = $ 56.20 $ 61.20 at March 18 90 12,926 5,508 $ 10,112 at at = 0.00 at = March 25 160 at $ 63.20 = at $ 63.20 = at $ 63.20 = Totals $ 0.00 $ 0.00 4. Compute gross profit earned by the company for each of the four costing methods. For specific identification, units sold include 70 units from beginning inventory, 200 units from the March 5 purchase, 50 units from the March 18 purchase, and 90 units from the March 25 purchase. (Round weighted average cost per unit to two decimals and final answers to nearest whole dollar.) Gross Margin FIFO LIFO Weighted Average Specific ID Sales Less: Cost of goods sold Gross profit

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting For Decision Makers

Authors: Dr Peter Atrill, Eddie McLaney

6th Edition

0273731521, 9780273731528

More Books

Students also viewed these Accounting questions

Question

=+Show photos of consumers?

Answered: 1 week ago

Question

=+Exhibit children's artwork?

Answered: 1 week ago

Question

=+What kind of product or service would work in these locations?

Answered: 1 week ago