Alpha Corporation began operations on December 1, 2019. The only inventory transaction in 2019 was the purchase of inventory on December 10, 2019, at a cost of $20 per unit. None of this inventory was sold in 2019. Relevant information for fiscal 2020 is as follows:
Ending inventory units: | Total | |
December 31, 2019 | 100 | |
December 31, 2020 by purchase date | ||
December 2, 2020 | 100 | |
July 20, 2020 | 30 | 130 |
During 2020, the following purchases and sales were made:
Purchases | Sales | ||
March 15 | 300 units @ $24 per unit | April 10 | 200 |
July 20 | 300 units @ $25 per unit | August 20 | 300 |
September 4 | 200 units @ $28 per unit | November 18 | 170 |
December 2 | 100 units @ $30 per unit | December 12 | 200 |
The company uses the periodic inventory method.
Determine the ending inventory under the following (rounding to 2 decimal places):
Required
1. Specific identification
2. FIFO
3. Weighted average cost
1. Specific Identification
As per Specific Identification method, Ending Inventory is made up of 100 units from Dec 2, 2020 purchases and 30 units from July 20, 2020 purchases
= (100 x 30) + (30 x 25)
= $3,750
2. FIFO
As per FIFO method, the 130 units remaining unsold will be considered to be purchased on Dec 2 (100 units) and Sept 4 (30 units)
= (100 x 30) + (30 x 28)
= $3,840
3. Weighted average cost
Purchases | Units | Unit cost | Total cost |
Opening inventory | 100 | 20 | 2,000 |
March 15 | 300 | 24 | 7,200 |
July 20 | 300 | 25 | 7,500 |
Sept 4 | 200 | 28 | 5,600 |
Dec 2 | 100 | 30 | 3,000 |
Total | 1,000 | 25.30* | 25,300 |
*25,300/1,000 = 25.30
Thus, ending inventory = 130 units x $25.30
= $3,289
Get Answers For Free
Most questions answered within 1 hours.