In: Accounting
Salmone Company reported the following purchases and sales of its only product. Salmone uses a perpetual inventory system. Determine the cost assigned to ending inventory using LIFO.
| Date | Activities | Units Acquired at Cost | Units Sold at Retail | 
| May 1 | Beginning Inventory | 320 units @ $17 | |
| 5 | Purchase | 305 units @ $19 | |
| 10 | Sales | 225 units @ $27 | |
| 15 | Purchase | 185 units @ $20 | |
| 24 | Sales | 175 units @ $28 | |
Multiple Choice
$7,160
$6,960
$14,935
$7,640
$7,975
Solution :
| Computation of ending inventory COGS under LIFO | ||||||||||||
| Date | Beginning Inventory | Purchase | Cost of Goods Sold | Ending Inventory | ||||||||
| Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | |
| 1-May | 320 | $17.00 | $5,440.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 320 | $17.00 | $5,440.00 | 
| 5-May | 320 | $17.00 | $5,440.00 | 305 | $19.00 | $5,795.00 | 0 | $0.00 | $0.00 | 320 | $17.00 | $5,440.00 | 
| 305 | $19.00 | $5,795.00 | ||||||||||
| 10-May | 320 | $17.00 | $5,440.00 | 0 | $0.00 | $0.00 | 225 | $19.00 | $4,275.00 | 320 | $17.00 | $5,440.00 | 
| 305 | $19.00 | $5,795.00 | 80 | $19.00 | $1,520.00 | |||||||
| 15-May | 320 | $17.00 | $5,440.00 | 185 | $20.00 | $3,700.00 | 0 | $0.00 | $0.00 | 320 | $17.00 | $5,440.00 | 
| 80 | $19.00 | $1,520.00 | 80 | $19.00 | $1,520.00 | |||||||
| 185 | $20.00 | $3,700.00 | ||||||||||
| 24-May | 320 | $17.00 | $5,440.00 | 0 | $0.00 | $0.00 | 175 | $20.00 | $3,500.00 | 320 | $17.00 | $5,440.00 | 
| 80 | $19.00 | $1,520.00 | 80 | $19.00 | $1,520.00 | |||||||
| 185 | $20.00 | $3,700.00 | 10 | $20.00 | $200.00 | |||||||
| Total | $7,775.00 | $7,160.00 | ||||||||||
Hence value of ending inventory under LIFO = $7,100
Hence first option is correct.