In: Accounting
Salisbury Company uses the perpetual inventory system and had the following inventory & sales activity for the month of May 2019:
|
Date |
Activity |
Quantity |
Unit Price |
|
5/1 |
Beginning Inventory |
175 |
$12.00 |
|
5/5 |
Purchase |
200 |
$10.50 |
|
5/10 |
Sales |
300 |
$25 |
|
5/15 |
Purchase |
200 |
$13.00 |
|
5/20 |
Sales |
250 |
$28 |
|
5/25 |
Purchase |
150 |
$13.50 |
Using the LIFO method, determine the dollar value for Ending Inventory at the end of month of May. Round to the nearest cent.
| LIFO | Cost of Goods Available for sale | Cost of Goods Sold | Ending Balance | |||||||
| Date | Activity | Units | Unit Price | Amount | Units | Unit Price | Amount | Units | Unit Price | Amount |
| May-01 | Beginning Inventory | 175 | $ 12.00 | $ 2,100.00 | ||||||
| May-05 | Purchase | 200 | $ 10.50 | $ 2,100.00 | 175 | $ 12.00 | $ 2,100.00 | |||
| 200 | $ 10.50 | $ 2,100.00 | ||||||||
| May-10 | Sales | 200 | $ 10.50 | $ 2,100.00 | 75 | $ 12.00 | $ 900.00 | |||
| 100 | $ 12.00 | $ 1,200.00 | ||||||||
| May-15 | Purchase | 200 | $ 13.00 | $ 2,600.00 | 75 | $ 12.00 | $ 900.00 | |||
| 200 | $ 13.00 | $ 2,600.00 | ||||||||
| May-20 | Sales | 200 | $ 13.00 | $ 2,600.00 | 25 | $ 12.00 | $ 300.00 | |||
| 50 | $ 12.00 | $ 600.00 | ||||||||
| May-15 | Purchase | 150 | $ 13.50 | $ 2,025.00 | 25 | $ 12.00 | $ 300.00 | |||
| 150 | $ 13.50 | $ 2,025.00 | ||||||||
| Total | $ 6,500.00 | $ 2,325.00 | ||||||||
Under LIFO method, inventory purchased first is sold first