In: Accounting
An organization reported the following:
| Units | $ per unit | |
| Beginning Inventory | 100 | $2 | 
| 1/1 Purchase on account | 1200 | $3 | 
| 1/14 Sell 600 units on account for $8/each | ||
| 1/22 Purchase on account | 900 | $4 | 
| 1/29 Sell 850 units on account for $9/each | 
A. Prepare the journal entries for above (using FIFO). Find the ending inventory for 1/31 and gross profit for January.
B. Prepare the journal entries for above (using LIFO). Find the ending inventory for 1/31 and gross profit for January.
C. Prepare the journal entries for above (using weighted-average). Find the ending inventory for 1/31 and gross profit for January.
FIFO
| Date | Receipts | Issues | Balance | ||||||
| Qty Purchased | Per unit cost of purchases | Cost of goods purchased | Qty sold | Per unit cost of goods sold | Cost of goods sold | Ending inventory (units) | Per unit cost of ending inventory | Cost of ending inventory | |
| 1/1 | 100 | 2 | 200 | ||||||
| 1/1 | 1200 | 3 | 3600 | 100 | 2 | 200 | |||
| 1200 | 3 | 3600 | |||||||
| 1/14 | 100 | 2 | 200 | 700 | 3 | 2100 | |||
| 500 | 3 | 1500 | |||||||
| 1/22 | 900 | 4 | 3600 | 700 | 3 | 2100 | |||
| 900 | 4 | 3600 | |||||||
| 1/29 | 700 | 3 | 2100 | 750 | 4 | 3000 | |||
| 150 | 4 | 600 | |||||||
| 1450 | 4400 | 
Cost of goods sold: 4400
Ending Inventory: 3000
.
LIFO
| Date | Receipts | Issues | Balance | ||||||
| Qty Purchased | Per unit cost of purchases | Cost of goods purchased | Qty sold | Per unit cost of goods sold | Cost of goods sold | Ending inventory (units) | Per unit cost of ending inventory | Cost of ending inventory | |
| 1/1 | 100 | 2 | 200 | ||||||
| 1/1 | 1200 | 3 | 3600 | 100 | 2 | 200 | |||
| 1200 | 3 | 3600 | |||||||
| 1/14 | 600 | 3 | 1800 | 100 | 2 | 200 | |||
| 600 | 3 | 1800 | |||||||
| 1/22 | 900 | 4 | 3600 | 100 | 2 | 200 | |||
| 600 | 3 | 1800 | |||||||
| 900 | 4 | 3600 | |||||||
| 1/29 | 850 | 4 | 3400 | 100 | 2 | 200 | |||
| 600 | 3 | 1800 | |||||||
| 50 | 4 | 200 | |||||||
| 1450 | 5200 | 
Cost of goods sold: 5200
Ending Inventory: 2200
.
Weighted Average:
| Qty Purchased | Per unit cost of purchases | Cost of goods purchased | Qty sold | Per unit cost of goods sold | Cost of goods sold | Ending inventory (units) | Per unit cost of ending inventory | Cost of ending inventory | |
| 1/1 | 100 | 2 | 200 | ||||||
| 1/1 | 1200 | 3 | 3600 | 1300 | 2.92 | 3800 | |||
| 1/14 | 600 | 2.92 | 1753 | 700 | 2.92 | 2047 | |||
| 1/22 | 900 | 4 | 3600 | 1600 | 3.52 | 5647 | |||
| 1/29 | 850 | 3.52 | 3000 | 750 | 3.52 | 2647 | |||
| 1450 | 4753 | 
Cost of goods sold: 4753
Ending Inventory: 2647
.