In: Accounting
A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 320 units. Ending inventory at January 31 totals 140 units.
| Units | Unit Cost | |||
| Beginning inventory on January 1 | 290 | $ | 2.70 | |
| Purchase on January 9 | 70 | 2.90 | ||
| Purchase on January 25 | 100 | 3.04 | ||
Required:
Assume the perpetual inventory system is used. Determine the costs
assigned to ending inventory when costs are assigned based on the
FIFO method. Use a table.
Answer)
Calculation of cost of ending inventory using FIFO Method under Perpetual inventory system
|
Date |
Purchases |
Cost of Goods Sold |
Balance Inventory |
||||||
|
Quantity |
Cost per Unit (In $) |
Total Cost (In $) |
Quantity |
Cost per Unit (In $) |
Total Cost (In $) |
Quantity |
Cost per Unit (In $) |
Total Cost (In $) |
|
|
January'1 |
290 |
2.70 |
783.00 |
||||||
|
January'9 |
70 |
2.90 |
203.00 |
290 |
2.70 |
783.00 |
|||
|
70 |
2.90 |
203.00 |
|||||||
|
January'25 |
100 |
3.04 |
304.00 |
290 |
2.70 |
783.00 |
|||
|
70 |
2.90 |
203.00 |
|||||||
|
100 |
3.04 |
304.00 |
|||||||
|
January'26 |
290 |
2.70 |
783.00 |
40 |
2.90 |
116.00 |
|||
|
30 |
2.90 |
87.00 |
100 |
3.04 |
304.00 |
||||
|
Total |
170 |
507.00 |
320 |
870.00 |
140 |
420.00 |
Therefore the cost of 140 units of ending inventory under FIFO method using perpetual inventory system is $ 420.