Periodic System— Calculating Ending Inventory and Cost of Sales using LIFO The following information is available...

Periodic System— Calculating Ending Inventory and Cost of Sales using LIFO

The following information is available for Water Inc.

Date	Units	Unit Cost
January 1, 2020 (beginning inventory)	100	$50.00
Purchases: January 10, 2020	75	52.00
January 15, 2020	150	52.50
January 30, 2020	100	55.00

The company maintains a periodic inventory system. A physical inventory count shows 125 units in stock on January 31. What is (a) ending inventory on January 31, and (b) cost of goods sold for January, using the LIFO inventory method?

Note: Round your final answers below to the nearest whole dollar.
Use your rounded ending inventory answer to compute part b. cost of goods sold.

a. Ending inventory on January 31, 2020	Answer
b. Cost of goods sold for January	Answer

Solutions

Expert Solution

Answer a)

Value of ending inventory using LIFO method, periodic inventory system

Value of ending inventory

Under LIFO method using periodic inventory system, Value of ending inventory is calculated on the assumption that units of inventory which are latest bought will be sold first and so on. Thus value of ending inventory will be from the units of inventory which are first bought and moving forwards.

Date	Type	Number of Units	Cost per unit	Total Cost
Jan’1, 2020	Beginning Inventory	100	$ 50.00	$ 5,000.00
Jan'10, 2020	Purchases	25	$ 52.00	$ 1,300.00
Total	125		$ 6,300.00

Therefore value of ending inventory using LIFO method is $ 6,300.

Answer b)

Calculation of Cost of Goods sold under LIFO Method

Under LIFO method using periodic inventory system, cost of goods sold is calculated on the assumption that units of inventory which are latest bought will be sold first and so on. Thus the cost of goods sold will be from the units of inventory which are latest and moving backwards.

Date	Type	Number of Units	Cost per unit	Total Cost
Jan'10, 2020	Purchased	50	$ 52.00	$ 2,600.00
Jan'15, 2020	Purchased	150	$ 52.50	$ 7,875.00
Jan'30, 2020	Purchased	100	$ 55.00	$ 5,500.00
Total	300		$ 15,975.00

Therefore cost of Goods sold under LIFO method is $ 15,975.

Working Notes:

Calculation of number of units sold

Number of units sold = Number of units Beginning inventory + units purchased during the month – number of units in ending inventory

= 100 units + (75 units + 150 units + 100 units) – 125 units

= 300 units

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Periodic and Perpetual Systems —Calculating Ending Inventory and Cost of Sales using Average Cost, Moving Average,...

Periodic and Perpetual Systems —Calculating Ending Inventory and Cost of Sales using Average Cost, Moving Average, FIFO, LIFO, and Dollar-Value LIFO The inventory records of Mod Oil Company for January 2020 showed the following data for an item of its merchandise for sale (assume that the six transactions occurred in the order shown). Date Units Unit Cost Total Beginning inventory (Jan. 1) 900 $6.00 $5,400 Jan. 3 Purchases 1,080 6.10 6,588 Jan. 5 Sales (1,620 units) Jan. 10 Purchases 1,080...

Periodic and Perpetual Systems—Calculating Ending Inventory and Cost of Sales using Average Cost (Moving Average), FIFO,...

Periodic and Perpetual Systems—Calculating Ending Inventory and Cost of Sales using Average Cost (Moving Average), FIFO, and LIFO Undew Inc.’s inventory records showed the following data for an item it sells regularly. Date Units Unit Cost Jan 1 Inventory 2,000 $10.00 Jan 3 Purchases 18,000 10.40 Jan 7 Sales (at $26 per unit) 7,000 Jan 20 Purchases 6,000 11.00 Jan 22 Sales (at $27 per unit) 16,000 Jan 30 Purchases 3,000 12.00 a. Assuming that Undew maintains a periodic inventory...

Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted...

Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods. Description # of units Cost per unit Beginning inventory: 20 20 Jan.15 Purchase: 22 27 Jan. 20 Sale 10 blank Jan.25 Purchase 18 25 Jan.28 Sale 15 blank

M7-7 to M7-9 Calculating Cost of Goods Available for Sale, Ending Inventory, Sales, Cost of Goods Sold, and Gross Profit under Periodic FIFO, LIFO, and Weighted Average Cost [LO 7-3]

Required informationM7-7 to M7-9 Calculating Cost of Goods Available for Sale, Ending Inventory, Sales, Cost of Goods Sold, and Gross Profit under Periodic FIFO, LIFO, and Weighted Average Cost [LO 7-3][The following information applies to the questions displayed below.]The following are the transactions for the month of July.UnitsUnit CostUnit Selling PriceJuly 1Beginning Inventory51$10July 13Purchase25512July 25Sold(100)$16July 31Ending Inventory206M7-7 Calculating Cost of Goods Available for Sale, Ending Inventory, Sales, Cost of Goods Sold, and Gross Profit under Periodic FIFO [LO 7-3]Calculate cost...

Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available...

Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 10 units at $36 $360 Aug. 7 Purchase 15 units at $38 570 Dec. 11 Purchase 15 units at $39 585 40 units $1,515 There are 18 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out...

Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available...

Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 15 units at $36 $540 Aug. 7 Purchase 20 units at $37 740 Dec. 11 Purchase 15 units at $38 570 50 units $1,850 There are 19 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out...

Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available...

Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 9 units at $28 $252 July 7 Purchase 6 units at $31 186 Nov. 23 Purchase 14 units at $33 462 29 units $900 There are 17 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out...

Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Method. The units of an item available...

Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Method. The units of an item available for sale during the year were as follows: Jan. 1 Inventory 14 units at $27 $378 Aug. 13 Purchase 19 units at $30 570 Nov. 30 Purchase 11 units at $32 352 Available for sale 44 units $1,300 There are 17 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a)...

Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available...

Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 10 units at $26 $260 Aug. 7 Purchase 15 units at $28 420 Dec. 11 Purchase 10 units at $29 290 35 units $970 There are 16 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out...

Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available...

Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 5 units at $37 $185 Aug. 7 Purchase 18 units at $39 702 Dec. 11 Purchase 13 units at $40 520 36 units $1,407 There are 16 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out...

Subjects