Question

In: Accounting

Waterway Industries has the following data related to an item of inventory: Inventory, March 1 360...

Waterway Industries has the following data related to an item of inventory:

Inventory, March 1 360 units @ $2.40
Purchase, March 7 1450 units @ $2.50
Purchase, March 16 290 units @ $2.55
Inventory, March 31 510 units


The value assigned to ending inventory if Waterway uses LIFO is

$1224.

$1299.

$1239.

$1290.

Solutions

Expert Solution

LIFO stands for last in first out which assumes that last purchased items are the one which is sold out first.

Date Purchases Cost of goods sold Balance
March 1 Beginning 360 units x $ 2.40 = $ 864
March 7 1,450 units x $ 2.50= $ 3,625

360 units x $ 2.40 = $ 864

1,450 units x $ 2.50 = $ 3,625

March 16 290 units x $ 2.55= $ 739.50

360 units x $ 2.40 = $ 864

1,450 units x $ 2.50 = $ 3,625

290 units x $ 2.55 = $ 739.50

290 units x $ 2.55 = $ 739.50

1,300 units x $ 2.50 = $ 3,250

360 units x $ 2.40 = $ 864

150 units x $ 2.50 = $ 375

Total = $ 1,239

Here, total units available for sale is 2,100 units. It is given that ending inventory consists of 510 units which means that 1,590 units are sold out. These 1,590 units consists of first 290 units from last purchase made, balance 1,300 units from March 7 purchase made because we are using LIFO method. Now there is a balance of 150 units in the March 7 purchase made. So the ending inventory of 510 units consists of 150 units from March 7 purchases and 360 units from beginning balance.

Ending inventory = (360 units x $ 2.40)+(150 units x $ 2.50)

Ending inventory = $ 1,239.

Hence, option C is the correct answer.

SUMMARY:

The value of ending inventory using LIFO method is calculated as $ 1,239.

Hence, option C is the correct answer.


Related Solutions

The Ivanhoe Shop shows the following data related to an item of inventory: Inventory, January 1...
The Ivanhoe Shop shows the following data related to an item of inventory: Inventory, January 1 310 units @ $6.00 Purchase, January 9 870 units @ $6.50 Purchase, January 19 210 units @ $7.00 Inventory, January 31 310 units What value should be assigned to cost of goods sold using LIFO?
The Ivanhoe Shop shows the following data related to an item of inventory: Inventory, January 1...
The Ivanhoe Shop shows the following data related to an item of inventory: Inventory, January 1 310 units @ $6.00 Purchase, January 9 870 units @ $6.50 Purchase, January 19 210 units @ $7.00 Inventory, January 31 310 units (a) What value should be assigned to the ending inventory using FIFO? Value assigned to the ending inventory $
Waterway Industries has $30000 of ending finished goods inventory as of December 31, 2013. If beginning...
Waterway Industries has $30000 of ending finished goods inventory as of December 31, 2013. If beginning finished goods inventory was $25000 and cost of goods sold was $60000, how much would Waterway report for cost of goods manufactured?
Problem 12-09A Condensed financial data of Waterway Industries follow. Waterway Industries Comparative Balance Sheets December 31...
Problem 12-09A Condensed financial data of Waterway Industries follow. Waterway Industries Comparative Balance Sheets December 31 Assets 2022 2021 Cash $ 129,280 $ 77,440 Accounts receivable 140,480 60,800 Inventory 180,000 164,560 Prepaid expenses 45,440 41,600 Long-term investments 220,800 174,400 Plant assets 456,000 388,000 Accumulated depreciation (80,000 ) (83,200 ) Total $1,092,000 $823,600 Liabilities and Stockholders’ Equity Accounts payable $ 163,200 $ 107,680 Accrued expenses payable 26,400 33,600 Bonds payable 176,000 233,600 Common stock 352,000 280,000 Retained earnings 374,400 168,720 Total...
Problem 12-09A Condensed financial data of Waterway Industries follow. Waterway Industries Comparative Balance Sheets December 31...
Problem 12-09A Condensed financial data of Waterway Industries follow. Waterway Industries Comparative Balance Sheets December 31 Assets 2022 2021 Cash $ 129,280 $ 77,440 Accounts receivable 140,480 60,800 Inventory 180,000 164,560 Prepaid expenses 45,440 41,600 Long-term investments 220,800 174,400 Plant assets 456,000 388,000 Accumulated depreciation (80,000 ) (83,200 ) Total $1,092,000 $823,600 Liabilities and Stockholders’ Equity Accounts payable $ 163,200 $ 107,680 Accrued expenses payable 26,400 33,600 Bonds payable 176,000 233,600 Common stock 352,000 280,000 Retained earnings 374,400 168,720 Total...
Bianca has the following inventory, purchases, and sales data for the month of March. The physical...
Bianca has the following inventory, purchases, and sales data for the month of March. The physical inventory count on March 31 shows 500 units on hand. Inventory: March 1 200 units @ $4.00 $ 800 Purchases: March 10 500 units @ $4.50 2,250 March 20 400 units @ $4.75 1,900 March 30 300 units @ $5.00 1,500 Sales: March 15 500 units March 25 400 units Required: 1. Under a periodic inventory system, determine the cost of inventory on hand...
The inventory data for an item for November are: Nov. 1 Inventory 23 units at $24...
The inventory data for an item for November are: Nov. 1 Inventory 23 units at $24 4 Sold 8 units 10 Purchased 34 units at $20 17 Sold 19 units 30 Purchased 21 units at $25 Using a perpetual system, what is the cost of the goods sold for November if the company uses LIFO?
The inventory data for an item for November are: Nov. 1 Inventory 20 units at $19...
The inventory data for an item for November are: Nov. 1 Inventory 20 units at $19 4 Sold 10 units 10 Purchased 30 units at $20 17 Sold 20 units 30 Purchased 10 units at $22 Using a perpetual system, what is the cost of the goods sold for November if the company uses the weighted average cost method? a. $590 b. $610 c. $585 d. $575
johnson Corporation has the following information for the month of March:Purchases $ 105,000Materials inventory, March 1...
johnson Corporation has the following information for the month of March:Purchases $ 105,000Materials inventory, March 1 16,000Materials inventory, March 31 8,000Direct labor 35,000Factory overhead 47,000Work in process, March I 28,000Work in process, March 31 33,500Finished goods inventory, March 1 11,000Finished goods inventory, March 31 30,000Sales 357,000Selling expenses24,000Administrative expenses 29,000Prepare (a) a schedule of cost of goods manufactured, (b) an income statement for the month ended March 31,
The Lippert Company uses the periodic inventory system. The following July data are for an item...
The Lippert Company uses the periodic inventory system. The following July data are for an item in loppers inventory: July 1 Beginning Inventory 100 units@ $8 per unit 10 Purchased 120 units@ $9 per unit 15 sold 130 units@ 26 Purchased 95 units@ $10 per unit Calculate the cost of goods sole for July and ending inventory at July 31 using (a) first-in, first out (b) last-in, first out and (c) the weighted- average cost methods. Round your final answers...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT