In: Accounting
Hill Marble buys and then resells a single product. The product, a marble, is a commodity and is subject to rather severe cost fluctuations. Some information concerning Hill Marble inventory activity during the month of June 2020 follows:
June 2 Had 860 units on hand, @ $7 per unit
June 6 Sold 400 units
June 8 Purchased 1,000 units @ $11 per unit
June 12 Purchased 400 units @ $9 per unit
June 15 Sold 600 units
June 21 Purchased 300 units @ $6 per unit
June 24 Sold 800 units
June 30 Purchased 100 units @ $8 per unit
Required:
Hill Marble uses a periodic inventory system. Calculate cost of goods sold (in both units and cost) for the month of June 2020 and ending inventory (units and cost) at June 30, 2020:
a. FIFO
Date | Purchases | Sales | Balance | |||||||
Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | ||
2-Jun | Balance | 860 | 7 | 6020 | ||||||
6-Jun | Sales | 400 | 7 | 2800 | 460 | 7 | 3220 | |||
8-Jun | Purchases | 1000 | 11 | 11000 | 460 | 7 | 3220 | |||
1000 | 11 | 11000 | ||||||||
12-Jun | Purchases | 400 | 9 | 3600 | 460 | 7 | 3220 | |||
1000 | 11 | 11000 | ||||||||
400 | 9 | 3600 | ||||||||
15-Jun | Sales | 460 | 7 | 3220 | 860 | 11 | 11000 | |||
140 | 11 | 1540 | 400 | 9 | 3600 | |||||
21-Jun | Purchases | 300 | 6 | 1800 | 860 | 11 | 11000 | |||
400 | 9 | 3600 | ||||||||
300 | 6 | 1800 | ||||||||
24-Jun | Sales | 800 | 11 | 8800 | 60 | 11 | 11000 | |||
400 | 9 | 3600 | ||||||||
300 | 6 | 1800 | ||||||||
30-Jun | Purchases | 100 | 8 | 800 | 60 | 11 | 11000 | |||
400 | 9 | 3600 | ||||||||
300 | 6 | 1800 | ||||||||
100 | 8 | 8 |
B. LIFO
Date | Purchases | Sales | Balance | |||||||
Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | ||
2-Jun | Balance | 860 | 7 | 6020 | ||||||
6-Jun | Sales | 400 | 7 | 2800 | 460 | 7 | 3220 | |||
8-Jun | Purchases | 1000 | 11 | 11000 | 460 | 7 | 3220 | |||
1000 | 11 | 11000 | ||||||||
12-Jun | Purchases | 400 | 9 | 3600 | 460 | 7 | 3220 | |||
1000 | 11 | 11000 | ||||||||
400 | 9 | 3600 | ||||||||
15-Jun | Sales | 400 | 9 | 3600 | 460 | 7 | 3220 | |||
200 | 11 | 2200 | 800 | 11 | 8800 | |||||
21-Jun | Purchases | 300 | 6 | 1800 | 460 | 7 | 3220 | |||
800 | 11 | 8800 | ||||||||
300 | 6 | 1800 | ||||||||
24-Jun | Sales | 300 | 6 | 1800 | 460 | 7 | 3220 | |||
500 | 11 | 5500 | 300 | 11 | 3300 | |||||
30-Jun | Purchases | 100 | 8 | 800 | 460 | 7 | 3220 | |||
300 | 11 | 3300 | ||||||||
100 | 8 | 800 |
c. FIFO method results in higher cost of goods sold.
d. FIFO method ends in higher inventory value.