In: Accounting
  | 
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
  | 
|||||||||||||||||||||||||
  | 
Solution
Requirement 1: Average cost per unit = $ 6.35
| 
 Weighted Average Cost Per unit  | 
|||
| 
 Units  | 
 (A)  | 
 9010  | 
|
| 
 Total Cost  | 
 (B)  | 
 $ 57,213.50  | 
|
| 
 Average Cost  | 
 (C=B/A)  | 
 $ 6.35  | 
Requirement 2:
| 
 LIFO  | 
 Weighted Average  | 
|
| 
 Ending Inventory  | 
 $ 7,154  | 
 $ 7,557  | 
Working:
| 
 Periodic LIFO  | 
||||||
| 
 A  | 
 Total Units Available for sale  | 
 9010  | 
 $ 57,213.50  | 
|||
| 
 Units Sold  | 
 7820  | 
|||||
| 
 Ending Inventory Units  | 
 1190  | 
|||||
| 
 Valuation  | 
||||||
| 
 Cost of Goods Sold  | 
 850  | 
 $ 6.79  | 
 5,771.50  | 
|||
| 
 1190  | 
 $ 6.60  | 
 7,854.00  | 
||||
| 
 2040  | 
 $ 6.50  | 
 13,260.00  | 
||||
| 
 1360.00  | 
 $ 6.40  | 
 8,704.00  | 
||||
| 
 2380.00  | 
 $ 6.08  | 
 14,470.40  | 
||||
| 
 -  | 
||||||
| 
 B  | 
 Cost of Goods Sold  | 
 7820  | 
 units  | 
 $ 50,059.90  | 
||
| 
 A-B  | 
 Ending Inventory  | 
 1190  | 
 units  | 
 $ 7,153.60  | 
| 
 Weighted Average  | 
||||||
| 
 A  | 
 Total Units Available for sale  | 
 9010  | 
 $ 57,213.50  | 
|||
| 
 Units Sold  | 
 7820  | 
|||||
| 
 Ending Inventory Units  | 
 1190  | 
|||||
| 
 Valuation  | 
||||||
| 
 Cost of Goods Sold  | 
 7820  | 
 $ 6.3500  | 
 $ 49,657.00  | 
|||
| 
 B  | 
 Cost of Goods Sold  | 
 7820  | 
 units  | 
 $ 49,657  | 
||
| 
 A-B  | 
 Ending Inventory  | 
 1190  | 
 units  | 
 $ 7,557  | 
Please give thumbs up :-)