Question
Lannister Inc. holds 12,000 units of inventory on January 1, 2017. Under FIFO (first-in, first-out) the inventory lot costs are: Inventory Lot Date Units Cost
Lannister Inc. holds 12,000 units of inventory on January 1, 2017.
Under FIFO (first-in, first-out) 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 (last-in, first-out) the same inventory has the following lot costs:
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,600.
During January 2017, Lannister records the following transactions (in chronological order):
- Sells 7,000 units of inventory with revenue of $175 per unit.
- Purchases 4,000 units of inventory at a cost of $130 per unit.
- Sells 2,000 units of inventory with revenue of $180 per unit.
- Purchases 3,000 units of inventory at a cost of $132 per unit.
- Sells 2,000 units of inventory with revenue of $184 per unit.
- Counts ending inventory units of 8,000 units on January 31.
In answering the following questions, assume that Lannister uses a periodic inventory system. Do not include a $ with any of your answers. Unless otherwise instructed, enter your answers as whole numbers.
- How many units of inventory did Lannister have available for sale during the month of January?
- Using FIFO, what was Lannisters cost of goods available for sale (COGAS) for January? $
- Using FIFO, what was the value of Lannisters ending inventory on January 31, 2017? $
- Using FIFO, what was Lannisters cost of goods sold (COGS) for January? $
- Using LIFO, what was Lannisters cost of goods available for sale (COGAS) for January? $
- Using LIFO, what was the value of Lannisters ending inventory on January 31, 2017? $
- Using LIFO, what was Lannisters cost of goods sold (COGS) for January?
- Using average cost, what was Lannisters cost of goods available for sale (COGAS) for January? $
- Based on your answer to h above, what was average cost per unit of inventory available for sale during January? For this question only, round your answer to 3 decimal places (xx.xxx) . $
- Using the rounded average cost value you computed in part i, what was the value of Lannisters ending inventory on January 31, 2017? $
- Using your answers to h and j above, what was Lannisters cost of goods sold (COGS) for January using average cost? $
- 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? $
I mainly need #12!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started