In: Accounting
Blue Corp. had 1,800 units of part T on hand April 1, 2017,
costing $8.00 each. During April, Blue made the following purchases
of part T.
| Units | Unit Cost  | 
|||||
| April | 4 | 2,800 | $8.25 | |||
| 10 | 4,800 | 8.40 | ||||
| 19 | 1,200 | 9.00 | ||||
| 29 | 2,500 | 9.90 | 
A physical count at April 30, 2017 showed 4,000 units of Part T on
hand.
Using the FIFO method, what is the cost of part T inventory at
April 30, 2017? Using the LIFO method, what is the inventory cost?
Using the average-cost method, what is the inventory cost?
Answer-----------
| FIFO | LIFO | Weighted Average | |
| Ending Inventory | $ 38,070 | $ 32,550 | $ 34,617 | 
Working
| Units | Cost per unit | value | |
| Beginning Balance | 1800 | $ 8.00 | $ 14,400 | 
| Purchases | |||
| 2800 | $ 8.25 | $ 23,100 | |
| 4800 | $ 8.40 | $ 40,320 | |
| 1200 | $ 9.00 | $ 10,800 | |
| 2500 | $ 9.90 | $ 24,750 | |
| Cost of goods available for sale | 13100 | $ 113,370 | 
.
| Average Cost of Inventory | ||
| Units | (A) | 13100 | 
| Total Cost | (B) | $ 113,370 | 
| Average Cost | (C=B/A) | $ 8.65 | 
.
| FIFO | ||||
| Total Units Available for sale | 13100 | |||
| Units Sold | 9100 | |||
| Closing Stock in Units | 4000 | |||
| Valuation | ||||
| Ending Inventory | 2500 | @ | $ 9.90 | $ 24,750 | 
| 1200 | @ | $ 9.00 | $ 10,800 | |
| 300 | @ | $ 8.40 | $ 2,520 | |
| Value Of Ending Inventory | $ 38,070 | |||
.
| LIFO | ||||
| Total Units Available for sale | 13100 | |||
| Units Sold | 9100 | |||
| Closing Stock in Units | 4000 | |||
| Valuation | ||||
| Ending Inventory | 1800 | @ | $ 8.00 | $ 14,400 | 
| 2200 | @ | $ 8.25 | $ 18,150 | |
| Value Of Ending Inventory | $ 32,550 | |||
.
| Weighted Average method | ||||
| Total Units Available for sale | 13100 | |||
| Units Sold | 9100 | |||
| Closing Stock in Units | 4000 | |||
| Valuation | ||||
| Ending Inventory | 4000 | @ | $ 8.6542 | $ 34,617 |