In: Accounting
Inventory information for Part 311 of Oriole Corp. discloses the following information for the month of June.
June 1 |
Balance |
299 units @ $16 |
June 10 |
Sold |
196 units @ $38 | |||||
---|---|---|---|---|---|---|---|---|---|---|
11 |
Purchased |
803 units @ $19 |
15 |
Sold |
502 units @ $40 | |||||
20 |
Purchased |
505 units @ $21 |
27 |
Sold |
297 units @ $43 |
Assuming that the periodic inventory method is used, compute the cost of goods sold and ending inventory under (1) LIFO and (2) FIFO.
(1) |
(2) |
|||
---|---|---|---|---|
Cost of Goods Sold |
$enter a dollar amount |
$enter a dollar amount |
||
Ending Inventory |
$enter a dollar amount |
$enter a dollar amount |
Question Part Score
--/12
Assuming that the perpetual inventory method is used and costs are computed at the time of each withdrawal, what is the value of the ending inventory at LIFO?
The ending inventory at LIFO |
$enter The ending inventory at LIFO in dollars |
Question Part Score
--/3
Assuming that the perpetual inventory method is used and costs are computed at the time of each withdrawal, what is the gross profit if the inventory is valued at FIFO?
Gross Profit (FIFO) |
$enter the Gross Profit (FIFO) in dollars |
Correct Answer:
Requirement 1:
FIFO |
LIFO |
|
Cost of Goods Sold |
$ 18,008 |
$ 19,915 |
Cost of Ending Inventory |
$ 12,638 |
$ 10,731 |
Working:
Cost of Goods Available for sale |
|||
Units |
Cost per unit |
value |
|
Beginning Inventory |
299 |
$ 16.00 |
$ 4,784.0 |
Purchases |
803 |
$ 19.00 |
$ 15,257.0 |
Purchases |
505 |
$ 21.00 |
$ 10,605.00 |
Total |
1607 |
$ 30,646 |
FIFO |
|||||||
A |
Total Units Available for sale |
1607 |
$ 30,646 |
||||
Units Sold |
995 |
||||||
Ending Inventory Units |
612 |
||||||
Valuation |
|||||||
Cost of Goods Sold |
299 |
$ 16.00 |
$ 4,784.00 |
||||
696 |
$ 19.00 |
$ 13,224 |
|||||
B |
Cost of Goods Sold |
995 |
units |
$ 18,008 |
|||
A-B |
Ending Inventory |
612 |
units |
$ 12,638 |
|||
LIFO |
|||||||
A |
Total Units Available for sale |
1607 |
$ 30,646 |
||||
Units Sold |
995 |
||||||
Ending Inventory Units |
612 |
||||||
Valuation |
|||||||
Cost of Goods Sold |
505 |
$ 21.00 |
10,605.00 |
||||
490 |
$ 19.00 |
9,310.00 |
|||||
- |
|||||||
B |
Cost of Goods Sold |
995 |
units |
$ 19,915.00 |
|||
A-B |
Ending Inventory |
612 |
units |
$ 10,731.00 |
|||
Requirement 2:
Perpetual |
LIFO |
Cost of Ending Inventory |
$ 11,735 |
Working:
LIFO |
|||||||
A |
Total Units Available for sale |
1607 |
$ 30,646 |
||||
Units Sold |
995 |
||||||
Ending Inventory Units |
612 |
||||||
Valuation |
|||||||
Cost of Goods Sold |
196 |
$ 16.00 |
3,136.00 |
||||
502 |
$ 19.00 |
9,538.00 |
|||||
297 |
$ 21.00 |
6,237.00 |
|||||
B |
Cost of Goods Sold |
995 |
units |
$ 18,911.00 |
|||
A-B |
Ending Inventory |
612 |
units |
$ 11,735.00 |
|||
Requirement 3:
Perpetual |
FIFO |
Gross profit |
$ 22,291 |
Working:
Note: in FIFO inventory method, perpetual and periodic balance remain the same. Therefore, the cost of goods sold will be same as in periodic FIFO
FIFO |
||
A |
Sales Revenue (196*38)+(502*40)+(297*43) |
$ 40,299 |
B |
Cost of goods sold |
$ 18,008 |
C =A-B |
Gross Margin |
$ 22,291 |
End of Answer.
Thanks