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 :-)