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.