In: Accounting
The following information applies to the inventory of James Dixon Company and will be used for two questions on the exam:
| 
 Units  | 
 Cost per Unit  | 
||
| 
 February 1  | 
 Inventory on hand  | 
 400  | 
 $8  | 
| 
 February 4  | 
 Purchase  | 
 800  | 
 11  | 
| 
 February 6  | 
 Sale  | 
 1,000  | 
|
| 
 February 16  | 
 Purchase  | 
 1,300  | 
 16  | 
| 
 February 19  | 
 Sale  | 
 1,400  | 
|
| 
 February 25  | 
 Purchase  | 
 700  | 
 20  | 
The company only has one product.
Round $/unit values to four decimals where necessary
Calculate ending inventory using the LIFO perpetual method for the month of February.
| 
 $31,467  | 
||
| 
 $31,200  | 
||
| 
 $46,800  | 
||
| 
 $14,000  | 
||
| 
 $11,700  | 
||
| 
 $3,200  | 
||
| 
 $800  | 
||
| 
 $30,907  | 
||
| 
 $15,600  | 
||
| 
 $2,400  | 
||
| 
 $15,520  | 
||
| 
 $14,800  | 
||
| 
 $7,600  | 
||
| 
 $1,520  | 
||
| 
 $31,280  | 
||
| 
 $35,100  | 
||
| 
 $39,200  | 
||
| 
 $32,000  | 
The Answer is $ 14,800
Calculation:
| Particulars | Units | Unit Cost | Cost | 
| Beginning Inventory | 400 | $ 8 | $ 3,200 | 
| Purchases 1 | 800 | $ 11 | $ 8,800 | 
| Purchases 2 | 1,300 | $ 16 | $ 20,800 | 
| Purchases 3 | 700 | $ 20 | $ 14,000 | 
| Total Goods available for sale [A] | 3,200 | $ 46,800 | |
| Particulars | Units | Unit Cost | Cost of goods sold | 
| Sale | 1000 | (800*11)+(200*8) | $ 10,400 | 
| 1400 | (1300*16)+(100*8) | $ 21,600 | |
| Total Cost of goods sold [B] | 2400 | $ 32,000 | |
| Ending Inventory [A-B] | 800 | (700*20)+(100*8) | $ 14,800 |