Lannister Inc. holds 12,000 units of inventory on January 1, 2017. Under FIFO the inventory lot costs are: Inventory Lot Date Units Cost / Unit Total Cost
H 12/13/2016 6,000 $120 $720,000
I 12/22/2016 6,000 $125 $750,000
Under LIFO the same inventory lots costs are:
Inventory Lot Date Units Cost / Unit Total Cost
A 4/22/2012 2,000 $60 $120,000
F 10/15/2014 4,000 $84 $336,000
I 12/22/2016 6,000 $125 $750,000
Under average cost the same 12,000 inventory units have a total cost of $1,320,300.
Lannister uses a periodic inventory system.
During January 2017, Lannister records the following transactions (in chronological order):
Sells 2,000 units of inventory with revenue of $175 per unit.
Purchases 4,000 units of inventory at a cost of $130 per unit.
Sells 5,000 units of inventory with revenue of $180 per unit.
Purchases 3,000 units of inventory at a cost of $132 per unit.
Sells 4,000 units of inventory with revenue of $184 per unit.
What is Lannister’s total sales revenue for January?
How many units of inventory did Lannister have available for sale during the month of January?
How many units did Lannister have in ending inventory on January 31, 2017?
Using FIFO, what was Lannister’s cost of goods available for sale (COGAS) for January?
Using FIFO, what was the value of Lannister’s ending inventory on January 31, 2017?
Using FIFO, what was Lannister’s cost of goods sold (COGS) for January?
Using LIFO, what was Lannister’s cost of goods available for sale (COGAS) for January?
Using LIFO, what was the value of Lannister’s ending inventory on January 31, 2017?
Using LIFO, what was Lannister’s cost of goods sold (COGS) for January?
Using average cost, what was Lannister’s cost of goods available for sale (COGAS) for January?
Based on your answer to j above, what was average cost per unit of inventory available for sale during January? For this question only, enter your answer in dollars and cents (xx. xx) without a $ sign.
Using average cost, what was the value of Lannister’s ending inventory on January 31, 2017?
Using average cost, what was Lannister’s cost of goods sold (COGS) for January?
If a company reports inventory value of $40,000 using LIFO, and its LIFO reserve is $25,000, what value for inventory would it have reported if it had used FIFO instead?