In: Accounting
Jennifer Company reports the following for the month of June.
Date | Explanation | Units | Unit Cost | Total Cost | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
June |
1 |
Inventory |
500 | $5 | $2,500 | ||||||||
12 |
Purchase |
800 | 6 | 4,800 | |||||||||
23 |
Purchase |
1,000 | 7 | 7,000 |
Calculate the cost of the ending inventory and the cost of goods
sold for each cost flow assumption, using a perpetual inventory
system. Assume a sale of 870 units occurred on June 15 for a
selling price of $8 and a sale of 900 units on June 27 for $9.
(Round average cost per unit to 3 decimal places, e.g.
5.254 and final answers to 0 decimal places, e.g.
2,520.)
FIFO | LIFO | Moving Average | |||||
---|---|---|---|---|---|---|---|
Cost of the ending inventory |
$enter the cost of the ending inventory in dollars under FIFO method | $enter the cost of the ending inventory in dollars under LIFO method | $enter the cost of the ending inventory in dollars under moving average method | ||||
Cost of goods sold |
$enter the cost of the goods sold in dollars under FIFO method | $enter the cost of the goods sold in dollars under LIFO method | $enter the cost of the goods sold in dollars under moving average method |
FIFO | LIFO | Moving Average | |
Cost of the ending inventory | $ 3,710 | $ 2,850 | $ 3,490 |
Cost of goods sold | $ 10,590 | $ 11,450 | $ 10,811 |
First In First Out (FIFO) Method | Perpetual Inventory System | ||||||||
Date | Purchase | Cost of goods sold | Inventory on Hand | ||||||
Qty | Price | Value | Qty | Price | Value | Qty | Price | Value | |
June 1 | 500 | $ 5 | $ 2,500 | ||||||
June 12 | 800 | $ 6 | $ 4,800 | 500 | $ 5 | $ 2,500 | |||
800 | $ 6 | $ 4,800 | |||||||
June 15 | 500 | 5 | $ 2,500 | 430 | $ 6 | $ 2,580 | |||
370 | 6 | $ 2,220 | |||||||
June 23 | 1000 | $ 7 | $ 7,000 | 430 | $ 6 | $ 2,580 | |||
1000 | $ 7 | $ 7,000 | |||||||
June 27 | 430 | 6 | $ 2,580 | 530 | $ 7 | $ 3,710 | |||
470 | 7 | $ 3,290 | |||||||
Total | $ 10,590 | $ 3,710 | |||||||
Cost of goods sold | $ 10,590 | ||||||||
Cost of the ending inventory | $ 3,710 | ||||||||
Last In First Out (LIFO) Method | Perpetual Inventory System | ||||||||
Date | Purchase | Cost of goods sold | Inventory on Hand | ||||||
Qty | Price | Value | Qty | Price | Value | Qty | Price | Value | |
June 1 | 500 | $ 5 | $ 2,500 | ||||||
June 12 | 800 | $ 6 | $ 4,800 | 500 | $ 5 | $ 2,500 | |||
800 | $ 6 | $ 4,800 | |||||||
June 15 | 800 | 6 | $ 4,800 | 430 | $ 5 | $ 2,150 | |||
70 | 5 | $ 350 | |||||||
June 23 | 1000 | $ 7 | $ 7,000 | 430 | $ 5 | $ 2,150 | |||
1000 | $ 7 | $ 7,000 | |||||||
June 27 | 900 | 7 | $ 6,300 | 430 | $ 5 | $ 2,150 | |||
100 | $ 7 | $ 700 | |||||||
Total | $ 11,450 | $ 2,850 | |||||||
Cost of goods sold | $ 11,450 | ||||||||
Cost of the ending inventory | $ 2,850 | ||||||||
Moving Average Method | Perpetual Inventory System | ||||||||
Date | Purchase | Cost of goods sold | Inventory on Hand | ||||||
Qty | Price | Value | Qty | Price | Value | Qty | Price | Value | |
June 1 | 500 | $ 5.000 | $ 2,500 | ||||||
June 12 | 800 | $ 6.000 | $ 4,800 | 1300 | $ 7,300 | ||||
Average cost per unit (7300/1300) | $ 5.615 | ||||||||
June 15 | 870 | $ 5.615 | $ 4,885 | 430 | $ 5.615 | $ 2,414 | |||
June 23 | 1000 | $ 7 | $ 7,000 | 1430 | $ 9,414 | ||||
Average cost per unit (9415/1430) | $ 6.584 | ||||||||
June 27 | 900 | $ 6.584 | $ 5,926 | 530 | $ 6.584 | $ 3,490 | |||
Total | $ 10,811 | $ 3,490 | |||||||
Cost of goods sold | $ 10,811 | ||||||||
Cost of the ending inventory | $ 3,490 |