Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you please fill the FIFO LIFO weighted average and speific ID charts. Required information {The following information applies to the questions displayed below. Warnerwoods

Can you please fill the FIFO LIFO weighted average and speific ID charts.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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 Activities Units Acquired at Cost Units sold at Retail March 1 Beginning inventory 160 units @ $52.20 per unit March 5 Purchase 255 units @ $57.20 per unit March 9 Sales 320 units @ $87.20 per unit March 18 Purchase 115 units @ $62.20 per unit March 25 Purchase 210 units @ $64.20 per unit March 29 Sales 190 units @ $97.20 per unit Totals 740 units 510 units 3. Compute the cost assigned to ending inventory using (a) FIFO. () LIFO. ( weighted average, and specific identification. For specific identification, units sold include 95 units from beginning inventory, 225 units from the March 5 purchase, 75 units from the March 18 purchase, and 115 units from the March 25 purchase. Saved Required information Perpetual Fifo Perpetual LIFO Weighted Average Specific Id Compute the cost assigned to ending inventory using FIFO. Perpetual FIFO Cost of Goods Sold Goods Purchased Cost per Date Cost per Cost per # of units sold Cost of Goods Sold Inventory Balance Inventory #of units unit Balanco 160 at $ 52 20 = $ 8,352.00 Hof units unit unit March 1 255) at $57.20 160 at 255) at $ 52.20 = $57.20 = $ 8,352.00 14,586.00 9 22,938.00 March 5 Total March 5 $ $ 5220 $57.20 160 at 160 at 8,352.00 9,152.00 17,504.00 0 at 95 at March 9 $ 5220 $57.20 = 5,434,00 $ 5.434.00 $ Total March 9 115 at $ 62,20 o at 95 at 115 at $ 52 20 $57.20 = $ 62.20 = March 18 5,434.00 7 153.00 $ 12,58700 Total March 18 OINT Tecl IR Required information $ 160 at 160) at $ 52 20 $57.20 $ 52.20 $ 57 20 = O at 95 at 8,352 00 9,152.00 17,504.00 March 9 5.434 00 $ 5,434,00 $ Total March 9 115) at $ 62 20 0 at 95) at 115 at $ 5220 $57.20 = S 62 20 = March 18 5,434 00 7.153.00 $ 12,587.00 Total March 18 210 at $ 64.20 0 at 95 at 115) at 210 at $52.20 $57.20 = 5 62 20 = $ 64 20 = March 25 5,434.00 7.153.00 13,482 00 $ 26,069.00 Total March 25 $ 0 at 95) at 95) at ol at $ 52.20 $ 5720 $ 62.20 $ 6420 0.00 5,434.00 5.909.00 o at 0 at 20 at 210 at $ 5220 $ 57 20 $62 20 = $ 64,20 = March 29 0.00 1.244.00 13.482.00 $ 14,726.00 $ 14,725.00 $ 11.343.00 28,847.00 Total March 20 Totals $ Perpetual LIFO > Goods Purchased Cost per #of units unit Perpetual LIFO Cost of Goods Sold Cost per Cost of Goods Sold unit of units Inventory Balance #of units Cost per Inventory Balance unit 160 at $ 52.20 = S 8,352.00 Date sold March 1 160 at 255 at $ 57 20 $ 52.20 = $ 57.20 = 255 at $ 8,352.00 14,586.00 $ 22,938.00 March 5 Total March 5 s 4.959.00 65 at 2551 al $ 52,20 $5720 95 at 0 at $ 3,393.00 14,586.00 $ 17,979 00 $ 52,20 = $57.20 = March 9 $ 4,959.00 Total March 9 $ 4,959.00 115 at $ 62.20 95 al o at 115 at $ 52 20 - $57 20 $ 62 20 March 18 7.153.00 $ 12,112.00 Total March 18 $ 4.959.00 210 at $64 20 95 at Olat 1151 at 210 at 552 20 $57 20 5 6220 $ 64 20 March 25 7.153.00 13.48200 $ 22,938.00 Total March 5 $ $ 4,959.00 1 65 at 255 at March 9 $ 52 20 $ 57 20 3,393.00 14,586.00 $ 17,979.00 95 at 0 at $ 52 20 = $ 57.20 = $ 4,959.00 Total March 9 951 at $ 115 at $ 62.20 4,959.00 $ 52 20 = $ 57.20 $ 62 20 = ol at 1151 at March 18 7,153.00 $ 12,112.00 Total March 18 s 4,959.00 210 at $ 64 20 95 at o al 115 at 2101 at $ 52.20 = $57.20 $ 62.20 - S 64 20 March 25 7.153.00 13,48200 $ 25,694 00 Total March 25 $ $ LA 4,959.00 March 29 0 at ol at Olat 1901 at $ 52,20 $ 57.20 $ 62.20 $ 6420 $ 0.00 0.00 0.00 12.198.00 $ 12.198.00 $ 30,177.00 95 at olar 115) at 20 at $ 52.20 - S 57.20 $ 62.20 = $ 64 20 - 7.153.00 1,284 00 $ 13,396,00 $13,396.00 Total March 29 Totals TCM Taire bar Average 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 Cost per Date Cost per #of units Inventory Balance unit Inventory Balance 52 20 = $ 8.35200 w of units sold # of units Cost per unit Cost of Goods Sold $ unit 1601 at March 1 255 at $ 57.20 March 5 160 at 255 at 415 at $ $ $ 52 20 57 20 = 55.27 = $ 8,352.00 14,58600 $ 22,938 00 Average March March 9 $ 5 95 at 55 271 = $ 17,686.40 55.27 - $ 5,250 65 320 at 115 at $ 6220 95 at 115 at March 18 $ $ $ $ 5,250 65 7.153.00 $ 12,403 65 210 at Average March 18 55.27 = 62.20 - 59.01 - 59,01 = 64 20 6161 210 at $ 64 20 March 25 210) at 210 at 420 at $ $ $ $ 12,392 10 13.48200 $ 25,874 10 Average March 25 s 230 at 6161 $ 14,170.30 $ 190) at 6161 March 29 Totals $ 11,705.00 $ 29, 392 30 Required informal Perpetual FIFO Perpetual UFO Weighted Average Specificid Compute the cost assigned to ending Inventory using specific identification. For specific identification, units sold include 95 units from beginning inventory, 225 Spurchase, 75 units from the March 18 purchase, and 115 units from the March 25 purchase. Date Cost per cost of Goods Sold 0.00 Specific Identification: Cost of Goods Sold of units sold unit $ 5220 5 $57.20 56220 $ 6420 $ Goods Purchased Goods Cost per of units unit Puchased 160 $ 5220 $8.352 255 at S 5720 14 585 115 5 62 20 = 7,153 210 at 564 20 $ 13.482 Inventory Balance of units Cost per Inventory Balance unit $ 5220 000 $57.20 $6220 56420 = $ 0.00 0.00 0.00 March 1 March 5 March 18 March 25 Totals RE 000

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

Connect For Financial Accounting Information For Decisions

Authors: Author

10th Edition

1260386937, 9781260386936

More Books

Students also viewed these Accounting questions