Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I just need the specific identification chart completed, please fill in every box that has a little blue triangle! Required information [The following information applies

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
I just need the specific identification chart completed, please fill in every box that has a little blue triangle!
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 Acquired at Cost 100 units @ $50.00 per unit 400 units @ $55.00 per unit 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 420 units@ $85.00 per unit 120 units @ $60.00 per unit 200 units @ $62.00 per unit 160 units@ $95.00 per unit 580 units 820 units 3. Compute the cost assigned to ending inventory using (a) FIFO. (b) LIFO, (c) weighted average, and (d) specific identification. For specific identification, the March 9 sale consisted of 80 units from beginning inventory and 340 units from the March 5 purchase; the March 29 sale consisted of 40 units from the March 18 purchase and 120 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 Goods Purchased # of units unit Cost per Cost per Cost per # of units sold Date Cost of Goods Sold Inventory Balance # of units Inventory unit Balance 100 $ 50,00 $ 5,000.00 unit March 1 Perpetual FIFO: Cost of Goods Sold Goods Purchased # of units unit Date Cost per # of units sold Cost per unit Cost of Goods Sold March 1 March 5 400 @ $ 55.00 Inventory Balance Cost per Inventory # of units unit Balance 100 $ 50,00 - $ 5,000.00 1001 $ 50,00 - $ 5,000.00 400 @ $ 55.00 22,000.00 $ 27,000.00 0 @ $ 50.00 80 @ $ 55.00 4,400.00 $ 4,400.00 March 9 $ 100 320 @ $50.00 $55.00 5,000.00 17,600.00 22,600.00 $ March 18 120 $ 60,00 0 D 80 @ 120 @ $ 50.00 $ 55.00 $ 60.00 - 4,400.00 7,200.00 $ 11,600.00 March 25 200 @ $ 62.00 o 0 0 80 @ 120 200 @ $ 50.00 $ 55.00 $ 60.00 - $ 62.00 - 4,400.00 7,200.00 12,400.00 $ 24,000.00 March 29 o 80 80 @ o @ $50.00 = $ 55.00 $ 60.00 $ 6200 4,400.00 4,800.00 0,00 9,200.00 31,800.00 o 0 40 2001 $ 50.00 $ 55.00 $ 60.00 - $ 62.00 2.400.00 12,400.00 $ 14,800.00 $ Totals $ $ 14,800.00 Perpetual LIFO: Inventory Balance Goods Purchased #of units unit Cost per Cost of Goods Sold # of units sold unit Date Cost per cost of Goods Sold # of units Cost per Inventory Balance March 1 unit $ 50.00 100 @ $ 5,000.00 March 5 400 @ $ 55.00 $ 5,000.00 100 @ $ 50.00 = 400 @ $55.00 - 22,000.00 $ 27,000.00 March 9 # 20 @ 400 @ 4,000.00 $50.00 $55.00 $ 1.000.00 22,000.00 $ 23,000.00 4,000.00 March 18 120 @ $ 60.00 80 @ $50.00 $ o @ $55.00 - $ 80 @ $ 50.00 = 0 @ $ 55.00 120 @ $ 60.00 - $ 4,000.00 7,200.00 11,200.00 March 25 200 @ $ 62.00 $ 4,000.00 80 @ 0 @ 120 @ 200 @ $ 50.00 = $ 55.00 $ 60.00 - $ 62.00 7,200.00 12,400.00 23,600.00 $ March 29 $ $ 4,000.00 ole 0 o @ 1601 @ $50.00 $ 55.00 $ 60.00 $ 62.00 ### 0.00 0.00 0.00 9,920,00 9,920.00 80 0 @ 120 40 @ $ 50,00 - $ 55.00 $ 60.00 $ 62.00 = . 7,200.00 2.480.00 13,680,00 $ $ Totals $ 32,920.00 $ 13,680.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.) Weighted Average Perpetual: Goods Purchased Cost of Goods Sold Inventory Balance # of Cost per # of units Date Cost per Cost of Goods Sold Cost per # of units units Inventory Balance unit sold unit March 1 100 @ $ 50.00 - $5,000.00 March 5 400 @ $ 55.00 100 $ 50.00 - $ 5,000.00 400 @ $ 55.00 22,000.00 Average $ 54.00 - $ 27,000.00 March 9 420 @ 554.00 S 22,680.00 80 $ 54.00 $ 4,320,00 1201 $ 60.00 March 18 80 @ $ 54.00 $ 4,320.00 120 @ $ 60.00 - 7,200.00 200 $ 57.60 $ 11,520.00 Average March 25 200 @ $ 62,00 200 @ $57.60 = $ 11,520.00 200 @ $ 62.00 - 12,400.00 400 @ $59.80 = $ 23,920.00 500 March 29 160 @ $ 59.80 240 @ $59.80] = $ 14,352.00 $ $ 9,568.00 32,248.00 Totals Cost of Goods Sold Cost per Specific Identification: Goods Purchased Date #of units unit March 1 March 5 400 @ $55.00 # of units sold Cost per Cost of Goods Sold unit Inventory Balance Cost per # of units unit Inventory Balance 100 @ $50.00 = $ 5,000.00 @ $50.00 @ $ 55.00 March 9 March 18 March 25 March 29 Totals $ 0.00

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

After The Quality Audit Closing The Loop On The Audit Process

Authors: J. P. Russell, Terry Regel

2nd Edition

0873894863, 978-0873894869

More Books

Students also viewed these Accounting questions

Question

List four general control areas.

Answered: 1 week ago