Question

1. ABC Company had the following purchases and sales in June. What is the ending June inventory balance using the periodic FIFO and perpetual LIFO methods?

Date                   Action                      Units          Cost

June 1             Beg. Inventory           100               $2

June 6             Sale                                50

June 9             Purchase                      200              $4

June 15           Sale                               175

June 20           Purchase                      100              $5

June 25           Sale                               125

1. ABC Company had the following purchases and sales in June. What is the ending June inventory balance using the periodic FIFO and perpetual LIFO methods?

Date                   Action                      Units          Cost

June 1             Beg. Inventory           100               $2

June 6             Sale                                50

June 9             Purchase                      200              $4

June 15           Sale                               175

June 20           Purchase                      100              $5

June 25           Sale                               125

1. ABC Company had the following purchases and sales in June. What is the ending June inventory balance using the periodic FIFO and perpetual LIFO methods?

Date                   Action                      Units          Cost

June 1             Beg. Inventory           100               $2

June 6             Sale                                50

June 9             Purchase                      200              $4

June 15           Sale                               175

June 20           Purchase                      100              $5

June 25           Sale                               125

Answer 1

Correct Answer:

Periodic inventory

	FIFO	LIFO
Cost of Ending Inventory	$       250	$          100

Working:

Cost of Goods Available for sale
	Units	Cost per unit	value
Beginning Inventory	100	$         2.00	$                  200
Purchases	200	$         4.00	$                  800
Purchases	100	$         5.00	$                  500
Total	400		$              1,500

FIFO
A	Total Units Available for sale			400			$                1,500
	Units Sold			350
	Ending Inventory Units			50
	Valuation
	Cost of Goods Sold		100		$                2.00		$                    200
			200		$                4.00		$                    800
			50		$                5.00		$                    250
B	Total Cost of Goods Sold		350	units			$                1,250
A-B	Ending Inventory		50	units			$                    250

	LIFO
A	Total Units Available for sale			400			$                1,500
	Units Sold			350
	Ending Inventory Units			50
	Valuation
	Cost of Goods Sold		100		$                5.00		$                    500
			200		$                4.00		$                    800
			50		$                2.00		$                    100
B	Total Cost of Goods Sold		350	units			$                1,400
A-B	Ending Inventory		50	units			$                    100

Perpetual:

	FIFO	LIFO
Cost of Ending Inventory	$       250	$          100

Note: FIFO ending inventory remains same in periodic and perpetual inventory system.

	LIFO
A	Total Units Available for sale			400			$                1,500
	Units Sold			350
	Ending Inventory Units			50
	Valuation	From:
	Cost of Goods Sold	June-1	50		$                2.00		$                    100
		June 9	175		$                4.00		$                    700
		June 20	100		$                5.00		$                    500
		June 9	25		$                4.00		$                    100
B	Total Cost of Goods Sold		350	units			$                1,400
				0 0 Add a comment Know the answer? Your Answer: Post as a guest Your Name: What's your source? Earn Coins Coins can be redeemed for fabulous gifts. Log In Sign Up Post as anonymous Post Your Answer Not the answer you're looking for? Ask your own homework help question Similar Questions ABC Company had the following purchases and sales in June. What is the ending June inventory... ABC Company had the following purchases and sales in June. What is the ending June inventory balance using the periodic FIFO and perpetual LIFO methods? Date Action Units Cost June 1 Beg. Inventory 100 $2 June 6 Sale 50 June 9 Purchase 200 $4 June 15 Sale 175 June 20 Purchase 100 $5 June 25 Sale 125 Inventory Costing Methods: Periodic LIFO (Appendix 6B) Filimonov Inc. has the following information related to purchases... Inventory Costing Methods: Periodic LIFO (Appendix 6B) Filimonov Inc. has the following information related to purchases and sales of one of its inventory items: Date Description Units Purchased at Cost Units Sold at Retail June 1 Beginning Inventory 200 units @ $10 = $2,000 9 Purchase 1 300 units @ $12 = $3,600 14 Sale 1 400 units @ $25 22 Purchase 2 250 units @ $14 = $3,500 29 Sale 2 225 units @ $25 Assume that the company... Use the information below to determine the number of units in ending inventory and the ending... Use the information below to determine the number of units in ending inventory and the ending inventory value using the perpetual inventory system for FIFO. ($) Number Per Date Transaction of units unit Apr. 3 Inventory 30 800 8 Purchase 60 820 11 Sale 40 - 30 Sale 30 - May 8 Purchase 60 850 10 Sale 20 - 19 Sale 15 - 28 Purchase 80 900 Part 2 There are 10 units in ending inventory compute the value of... The following data regarding purchases and sales of a commodity were taken from the related perpetual... The following data regarding purchases and sales of a commodity were taken from the related perpetual inventory account: June 1 Balance 25 units at $60 6 Sale 20 units 8 Purchase 20 units at $61 16 Sale 10 units 20 Purchase 20 units at $62 23 Sale 25 units 30 Purchase 15 units at $63 Calculate the cost of the ending inventory at June 30, using (a) the first-in, first-out (FIFO) method and (b) the last-in, first-out (LIFO) method. Identify... Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for... Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for the month of May 2019: Date Activity Quantity Unit Price 5/1 Beginning Inventory 175 $11.00 5/5 Purchase 200 $10.50 5/10 Sales 300 $25 5/15 Purchase 200 $13.50 5/20 Sales 250 $28 5/25 Purchase 150 $13.00 Using the LIFO method, determine the dollar value for Ending Inventory at the end of month of May. Round to the nearest cent. Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for... Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for the month of May 2019: Date Activity Quantity Unit Price 5/1 Beginning Inventory 175 $11.00 5/5 Purchase 200 $11.50 5/10 Sales 300 $25 5/15 Purchase 200 $13.00 5/20 Sales 250 $28 5/25 Purchase 150 $13.00 Using the LIFO method, determine the dollar value for Ending Inventory at the end of month of May. Round to the nearest cent. Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for... Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for the month of May 2019: Date Activity Quantity Unit Price 5/1 Beginning Inventory 175 $11.00 5/5 Purchase 200 $12.00 5/10 Sales 300 $25 5/15 Purchase 200 $14.00 5/20 Sales 250 $28 5/25 Purchase 150 $14.00 Using the LIFO method, determine the dollar value for Ending Inventory at the end of month of May. Round to the nearest cent. Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for... Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for the month of May 2019: Date Activity Quantity Unit Price 5/1 Beginning Inventory 175 $11.00 5/5 Purchase 200 $12.50 5/10 Sales 300 $25 5/15 Purchase 200 $13.50 5/20 Sales 250 $28 5/25 Purchase 150 $13.50 Using the LIFO method, determine the dollar value for Ending Inventory at the end of month of May. Round to the nearest cent. Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for... Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for the month of May 2019: Date Activity Quantity Unit Price 5/1 Beginning Inventory 175 $12.00, 5/5 Purchase 200 $12.00, 5/10 Sales 300 $25, 5/15 Purchase 200 $13.50, 5/20 Sales 250 $28, 5/25 Purchase 150 $13.50 Using the LIFO method, determine the dollar value for Ending Inventory at the end of month of May. Round to the nearest cent. Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for... Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for the month of May 2019: Date Activity Quantity Unit Price 5/1 Beginning Inventory 175 $10.00 5/5 Purchase 200 $11.50 5/10 Sales 300 $25 5/15 Purchase 200 $14.00 5/20 Sales 250 $28 5/25 Purchase 150 $14.00 Using the LIFO method, determine the dollar value for Ending Inventory at the end of month of May. Round to the nearest cent. ADVERTISEMENT Need Online Homework Help? Get Answers For Free Most questions answered within 1 hours. Ask a Question ADVERTISEMENT Active Questions Assume as students that you each use 1000 Watts of power for 12 hours each day... asked 12 minutes ago Study reported that 30% of people age 18 and older smoke. Recent survey of 500 randomly... asked 14 minutes ago 3-37 The physicians in Problem 3-36 have been approached by a market research firm that offers... asked 15 minutes ago // Write a function that returns 0 if x is 0, returns -1 // if x... asked 15 minutes ago A certain liquid has a vapor pressure of 92.0 Torr at 23.0 °C and 279.0 Torr... asked 15 minutes ago A candidate for mayor in a small town has allocated $40,000 for last-minute advertising in the... asked 20 minutes ago What is a class? asked 24 minutes ago how to send string from process to shared memory using c language? asked 39 minutes ago What is the difference between methods and constructors? asked 46 minutes ago Suppose a host has a 5-MB file that is to be sent to another host. The... asked 56 minutes ago Write a Matlab function convert T such that convert T(x, ’C’) converts from degrees Celsius to... asked 57 minutes ago Using ER Assistant, develop an EER model for the following situation, using the EER notation associated... asked 1 hour ago About Contact Terms of Use Privacy Policy Academic Honesty Policy Homework Answer Scanner App Report DMCA © 2022 JustAAA   user contributions licensed under cc by-sa 4.0