Log in
Accounting
1
answer
0
watching
469
views

Part 3: The Warnerwood Company

The Warnerwood Company uses a perpetual inventory system. Itentered the following purchases and sales transactions for Marchinto the system:

Date

Activities

Units Acquired at Cost

Cost per Unit

Units Sold at Retail

Price per unit

March 1

Beginning inventory

100 units

$50

March 5

Purchase

400 units

$55

March 9

Sales

420

$85

March 18

Purchase

120 units

$60

March 25

Purchase

200 units

$62

March 29

Sales

160 units

$95

Totals

820 units

580 units

Instructions:

Show all of your work in an Excel spreadsheet for the followingtasks:

Compute the number of units available for sale.

Compute the number of units in ending inventory.

Compute the cost assigned to ending inventory using (a) FIFO,(b) LIFO, and (c) weighted average. (Round the average cost perunit to 2 decimal places.)

Compute the gross profit earned by the company for each of thethree costing methods. (Round the average cost per unit to 2decimal places.)

Watch
1
answer
0
watching
469
views

For unlimited access to Homework Help, a Homework+ subscription is required.

Nelly Stracke
Nelly StrackeLv2
28 Sep 2019

Unlock all answers

Get 1 free homework help answer.
Already have an account? Log in
Share

Related questions

Required information

Problem 6-1A Perpetual: Alternative cost flows LO P1

[The following information applies to the questionsdisplayed below.]

Warnerwoods Company uses a perpetual inventory system. It enteredinto the following purchases and sales transactions forMarch.

Date

Activities

Units Acquired at Cost

Units Sold at Retail

Mar.

1

Beginning inventory

100

units

@ $50.00 per unit

Mar.

5

Purchase

400

units

@ $55.00 per unit

Mar.

9

Sales

420

units

@ $85.00 per unit

Mar.

18

Purchase

120

units

@ $60.00 per unit

Mar.

25

Purchase

200

units

@ $62.00 per unit

Mar.

29

Sales

160

units

@ $95.00 per unit

Totals

820

units

580

units

3. Compute the cost assigned to endinginventory using (a) FIFO, (b) LIFO, (c)weighted average, and (d) specific identification. Forspecific identification, the March 9 sale consisted of 80 unitsfrom beginning inventory and 340 units from the March 5 purchase;the March 29 sale consisted of 40 units from the March 18 purchaseand 120 units from the March 25 purchase.

Complete this questions by entering your answers in thebelow tabs.

Perpetual FIFO

Perpetual LIFO

Weighted Average

Specific Id

Compute the cost assigned to ending inventory using FIFO.

Perpetual FIFO:

Goods Purchased

Cost of Goods Sold

Inventory Balance

Date

# of units

Cost per unit

# of units sold

Cost per unit

Cost of Goods Sold

# of units

Cost per unit

Inventory Balance

March 1

100

@

$50.00

=

$5,000.00

March 5

March 9

March 18

March 25

March 29

Totals

$0.00

$0.00

Complete this questions by entering your answers in thebelow tabs.

Perpetual FIFO

Perpetual LIFO

Weighted Average

Specific Id

Compute the cost assigned to ending inventory using LIFO.

Perpetual LIFO:

Goods Purchased

Cost of Goods Sold

Inventory Balance

Date

# of units

Cost per unit

# of units sold

Cost per unit

Cost of Goods Sold

# of units

Cost per unit

Inventory Balance

March 1

100

@

$50.00

=

$5,000.00

March 5

March 9

March 18

March 25

March 29

Totals

$0.00

Perpetual FIFO

Weighted

Complete this questions by entering your answers in thebelow tabs.

Perpetual FIFO

Perpetual LIFO

Weighted Average

Specific Id

Compute the cost assigned to ending inventory using weightedaverage. (Round your average cost per unit to 2 decimalplaces.)

Weighted Average Perpetual:

Goods Purchased

Cost of Goods Sold

Inventory Balance

Date

# of units

Cost per unit

# of units sold

Cost per unit

Cost of Goods Sold

# of units

Cost per unit

Inventory Balance

March 1

100

@

$50.00

=

$5,000.00

March 5

Average

March 9

March 18

Average

March 25

March 29

Totals

$0.00

Perpetual LIFO

Compute the cost assigned to ending inventory using specificidentification. For specific identification, the March 9 saleconsisted of 80 units from beginning inventory and 340 units fromthe March 5 purchase; the March 29 sale consisted of 40 units fromthe March 18 purchase and 120 units from the March 25 purchase.

Specific Identification:

Goods Purchased

Cost of Goods Sold

Inventory Balance

Date

# of units

Cost per unit

# of units sold

Cost per unit

Cost of Goods Sold

# of units

Cost per unit

Inventory Balance

March 1

100

@

$50.00

=

$5,000.00

March 5

March 9

March 18

March 25

March 29

Totals

$0.00

Weighted Average

Sp

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
Mar. 1 Beginning inventory 160 units @ $52.20 per unit
Mar. 5 Purchase 255 units @ $57.20 per unit
Mar. 9 Sales 320 units @ $87.20 per unit
Mar. 18 Purchase 115 units @ $62.20 per unit
Mar. 25 Purchase 210 units @ $64.20 per unit
Mar. 29 Sales 190 units @ $97.20 per unit
Totals 740 units 510 units

4.Compute gross profit earned by the company for each of the four costing methods. For specific identification, the March 9 sale consisted of 95 units from beginning inventory and 225 units from the March 5 purchase; the March 29 sale consisted of 75 units from the March 18 purchase and 115 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 Avg. Cost Spec. ID
Sales
Less: Cost of goods sold
Gross profit

I need help filling the table!!

Montoure Company uses a perpetual inventory system. It enteredinto the following calendar-year 2013 purchases and salestransactions.

Date Activities Units Acquired at Cost Units Sold atRetail
Jan. 1 Beginning inventory 600 units @ $ 60/unit
Feb. 10 Purchase 480 units @ $ 57/unit
Mar. 13 Purchase 120 units @ $ 42/unit
Mar. 15 Sales 785 units @ $ 80 /unit
Aug. 21 Purchase 180 units @ $ 65/unit
Sept. 5 Purchase 470 units @ $ 63/unit
Sept. 10 Sales 650 units @ $ 80 /unit



Totals 1,850 units 1,435 units

Compute the cost assigned to ending inventory using (a)FIFO, (b) LIFO, (c) weighted average, and(d) specific identification. For specific identificationunits sold consist of 600 units from beginning inventory, 380 fromthe February 10 purchase, 120 from the March 13 purchase, 130 fromthe August 21 purchase, and 205 from the September 5 purchase.(Round your average cost per unit to 2 decimalplaces.)

Compute gross profit earned by the company for each of the fourcosting methods. (Round your average cost per unit to 2decimal places.)

Weekly leaderboard

Home
Homework Help 3,900,000
Accounting 580,000
Start filling in the gaps now
Log in