In: Accounting
3. Beginning inventory, purchases, and sales data for hammers are as follows:?
Mar. 3 |
Inventory |
12 units at $15 |
|
11 . |
Purchase |
13units at $17 |
|
14 |
Sale |
18 units |
|
21 |
Purchase |
9 units at $20 |
|
25 |
Sale |
10 units |
? Assuming the business maintains a perpetual inventory system, complete the inventory cards and calculate the cost of merchandise sold and ending inventory using the first-in, first-out inventory assumption.??
FIFO ?
Inventory Card: | |||||||||
Date | Purchases | Sales | Balance | ||||||
Units | PU | Total Cost | Units | PU | Total Cost | Units | PU | Total Cost | |
03-Mar | 12.00 | 15.00 | 180.00 | ||||||
11-Mar | 13.00 | 17.00 | 221.00 | 12.00 | 15.00 | 180.00 | |||
13.00 | 17.00 | 221.00 | |||||||
14-Mar | 12.00 | 15.00 | 180.00 | 7.00 | 17.00 | 119.00 | |||
6.00 | 17.00 | 102.00 | |||||||
21-Mar | 9.00 | 20.00 | 180.00 | 7.00 | 17.00 | 119.00 | |||
9.00 | 20.00 | 180.00 | |||||||
25-Mar | 7.00 | 17.00 | 119.00 | 6.00 | 20.00 | 120.00 | |||
3.00 | 20.00 | 60.00 | |||||||
34.00 | 581.00 | 28.00 | 461.00 | 6.00 | 120.00 | ||||
Units | Total Cost | ||||||||
Cost of Goods Sold: | 28.00 | 461.00 | |||||||
Ending Inventory | 6.00 | 120.00 | |||||||
Working Note: | |||||||||
First Sales on 14.03: | |||||||||
First Sales from Opening | 12.00 | ||||||||
Balance from 11.03 | 6.00 | ||||||||
TotalUnits | 18.00 | ||||||||
Sales on 25.03: | |||||||||
First Sales from 11.03 | 7.00 | ||||||||
Balance from 21.03 | 3.00 | ||||||||
TotalUnits | 10.00 | ||||||||