In: Accounting
Assume that Martinez Company has the following transactions in its first month of operations.
| Date | Purchases | Sold | Balance | |||
| Feb. 1 | 2,100 @ $3.60 | 2,100 units | ||||
| Feb. 10 | 6,200 @ $3.95 | 8,300 units | ||||
| Feb. 21 | 4,400 units | 3,900 units | ||||
| Feb. 28 | 2,100 @ $4.30 | 6,000 units |
Martinez uses a perpetual inventory system.
Compute cost of goods sold and ending inventory at February 28,
assuming that Martinez uses the LIFO cost flow
assumption.
| Cost of goods sold | $ | |
| Ending inventory | $ |
Store ledger Account LIFO
| Date | Receipts | Issue | Balance | ||||||
| Qty | Price | value | Qty | Price | Value | Qty | Price | Value | |
| Feb1 | 2100 | $3.60 | $7560 | 2100 | $3.60 | $2100 | |||
| 2100 | $3.60 | $2100 | |||||||
| Feb 10 | 6200 | $3.95 | $24490 | 2100 | $3.60 | $2100 | |||
| 6200 | $3.95 | $24490 | |||||||
| 8300 | $26590 | ||||||||
| Feb 21 | 4400 | $3.95 | $17380 | 1800 | $3.95 | $7110 | |||
| 2100 | $3.60 | $2100 | |||||||
| 3900 | $9210 | ||||||||
| Feb 28 | 2100 | $4.30 | $9030 | 2100 | $4.30 | $9030 | |||
| 1800 | $3.95 | $7110 | |||||||
| 2100 | $3.60 | $7560 | |||||||
| 6000 | $23700 |
Cost of good sold under LIFO method is the last item purchased is also the first one sold. Thus, the Cost of goods sold = (4400Units*$3.95)=$17380
And Ending inventory is (2100Units*$4.30)+ (1800Units*$3.95)+( 2100Units*$3.60)=23700