Question

In: Accounting

The Wright Company recorded the following inventory information during the month of October: UNITS UNIT COST...

The Wright Company recorded the following inventory information during the month of October:

UNITS

UNIT COST

TOTAL COST

UNITS ON HAND

Balance on October 1

2,000

$1.00

$2,000

2,000

Purchased on October 8

1,200

$3.00

$3,600

3,200

Sold on October 20

1,500

1,700

Purchased on October 22

2,000

$4.00

$8,000

3,700

Sold on October 28

2,200

1,500

Purchase on October 29

1,000

$5.00

$5,000

2,500

Part B: Using the partially computed tables on the next three pages, compute the cost of goods sold and the cost of the 2,500 units in ending inventory under each of the assumptions given above.

LIFO – Perpetual

Date

Purchases

Sales

Inventory on Hand

Units

Cost

Total

Units

Cost

Total

Units

Cost

Total

10/1

2,000

$1.00

$2,000

10/8

Purchased 1,200 units

1,200

$3.00

$3,600

2,000

1,200

3,200

$1.00

$3.00

$2,000

$3,600

$5,600

10/20

Sold 1,500 units

1,200

   300

1,500

$3.00

$1.00

$3,600

$   300

$3,900

1,700

$1.00

$1,700

10/22

Purchased 2,000 units

10/28

Sold 2,200 units

10/29

Purchased 1,000 units

TOTALS

Solutions

Expert Solution

Date

Purchases

Sales

Inventory on Hand

Units

Cost

Total

Units

Cost

Total

Units

Cost

Total

10/1

2,000

$1.00

$2,000

10/8

Purchased 1,200 units

1,200

$3.00

$3,600

2,000

1,200

3,200

$1.00

$3.00

$2,000

$3,600

$5,600

10/20

Sold 1,500 units

1,200

   300

1,500

$3.00

$1.00

$3,600

$   300

$3,900

1,700

$1.00

$1,700

10/22

Purchased 2,000 units

2,000 $4.00 $8,000

1,700

2,000

3,700

$1.00

$4.00

$1,700

$8,000

$9,700

10/28

Sold 2,200 units

2,000

200

2,200

$4.00

$1.00

$8,000

$200

$8,200

1,500 $1.00 $1,500

10/29

Purchased 1,000 units

1,000 $5.00 $5,000

1,500

1,000

2,500

$1.00

$5.00

$1,500

$5,000

$6,500

TOTALS

4,200 $16,600 3,700 $12,100 2,500 $6,500
Cost of goods sold = $12,100, Ending inventory = $6,500

Related Solutions

AU Company has the following inventory transactions for the month of March: Units Unit Cost Beginning,...
AU Company has the following inventory transactions for the month of March: Units Unit Cost Beginning, Mar. 1 10,000 15 Purchases, Mar. 10 20,000 18 Sold, Mar. 15 15,000 Purchases, Mar. 18 5,000 23 Sold, Mar. 25 6,000 The company uses the perpetual inventory system. Determine the cost of inventory on March 31 and cost of goods sold under: Inventory Cost Flow Ending Inventory Cost of Goods Sold First in, first out (FIFO) Moving Average Last in, first out (LIFO)
EBECEDE Company has the following inventory transactions for the month of February: Units Unit Cost Beginning,...
EBECEDE Company has the following inventory transactions for the month of February: Units Unit Cost Beginning, Feb. 1 10,000 40 Purchases, Feb. 10 10,000 43 Sold, Feb. 15 15,000 Purchases, Feb. 18 5,000 44 Sold, Feb. 25 2,000 The company uses the perpetual inventory system. Determine the cost of inventory on February 29 and cost of goods sold under: Inventory Cost Flow Ending Inventory Cost of Goods Sold (COGS First in, first out (FIFO) Weighted Average Last in, first out...
Inventory Costing Methods Morrison Inc. reported the following information for the month of October: Inventory, October...
Inventory Costing Methods Morrison Inc. reported the following information for the month of October: Inventory, October 1 58 units @ $22 Purchase: October 7 57 units @ $23 October 18 58 units @ $24 October 27 46 units @ $25 During October, Morrison sold 138 units. The company uses a periodic inventory system. Required: What is the value of ending inventory and cost of goods sold for October under the following assumptions. ASSUMPTIONS: 1. Of the 138 units sold, 49...
Coopers Company reported the following information: Units Unit Cost Units Sold Jan 1 Beginning inventory 190...
Coopers Company reported the following information: Units Unit Cost Units Sold Jan 1 Beginning inventory 190 $50 Mar 8 Sale 100 Apr 10 Purchase 320 55 Jun 20 Sale 240 Oct 10 Purchase 570 60 Nov 30 Sale 450 Total Selling price per unit during the year: $75    790 Required Complete the following table. Cost Total Periodic Perpetual Date Purchased per Unit Cost Sold FIFO Weighted Average Units $ $ Units Units $ $ Units $ $
Tess Company's inventory records show the following data for the month of May: Units Unit Cost...
Tess Company's inventory records show the following data for the month of May: Units Unit Cost Inventory, May 1 200 $2.00 Purchases: May 8 200 3.00 May 15 100 4.00 The company uses a periodic inventory system. A physical inventory on May 30 shows 150 units on hand. Assuming FIFO (First-In-First-Out) inventory costing, calculate the cost of goods sold. a. $1,100 b. $850 c. $700 d. $980
Shellhammer Company's inventory records show the following data for the month of September: Units Unit Cost...
Shellhammer Company's inventory records show the following data for the month of September: Units Unit Cost Inventory, September 1 100 $3.34 Purchases: September 8 450 3.50 September 18 350 3.70 A physical inventory on September 30 shows 200 units on hand. Calculate the value of the ending inventory and cost of goods sold if the company uses weighted average inventory costing and a periodic inventory system. (Round cost per unit to 2 decimal places and ending inventory and cost of...
LL company budgeted 100,000 units for production during 2019. The following cost per unit information is...
LL company budgeted 100,000 units for production during 2019. The following cost per unit information is available: direct material = $5, direct labour = $10, variable manufacturing overhead = $4, variable selling per unit= $2. LL sells at $50 market price. It received a special order for 10,000 units from a new customer in a country in which LL has never done business. This customer has offered special order price at $22 per unit. If LL accepts the order, there...
Given the following inventory information… Item number Unit cost Annual usage in units Current inventory in...
Given the following inventory information… Item number Unit cost Annual usage in units Current inventory in units B8867 10 100 4500 J1252 5.25 6500 120 K9667 1.22 4000 1000 L2425 12.5 54 254 M4554 5.25 6500 120 T6334 70 500 800 W9856 .75 800 20000 X2215 1.5 8000 2000 Y3214 70 1000 500 Y6339 4 3500 125 which of the following items is not classified as C items by annual dollar usage? Which is not classified as C items by...
Tipp Topp Company reports the following for the month of June. Units Unit Cost Total Cost...
Tipp Topp Company reports the following for the month of June. Units Unit Cost Total Cost June 1 Inventory 300 $5 $1,500 12 Purchase 450 6 2,700 23 Purchase 750 7.60 5,700 30 Inventory 160 Compute the cost of the ending inventory and the cost of goods sold under (1) FIFO and (2) LIFO. FIFO LIFO Ending inventory $ $ Cost of goods sold $ $ LINK TO TEXT Compute the cost of the ending inventory and the cost of...
4. Sylvia's Designs Co. had the following inventory activity during April: Units Unit Cost Beginning inventory...
4. Sylvia's Designs Co. had the following inventory activity during April: Units Unit Cost Beginning inventory 100 $10 Purchase (April 3) 50 12 Sale (April 10) 80 Purchase (April 18) 40 14 Purchase (April 23) 60 15 Sale (April 28) 120 Assuming Sylvia's uses a perpetual LIFO cost flow assumption, ending inventory for April would be a. $ 750 b. $2,560 c. $ 500 d. $2,310
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT