Applying Excel 6: Perpetual LIFO - Cost of goods sold 2
A
B
C
D
E
F
G
H
I
1
Units
purchased
Cost per Total Cost Units Sold Selling
Total
unit
of
Price per
Sales
Purchase
unit
2
Date
3
Dec. 1 Beginning inventory
850
$12 $10,200
4
Dec. 8 Purchase
1,050
14
14,700
5
Dec. 10 Sales
800
$30 24,000
6
Dec. 14 Purchase
1,100
15 16,500
7
Dec. 16 Sales
990
$30 29,700
Totals
3,000
$41,400
1,790
$53,700
Assuming perpetual LIFO, which formula correctly calculates the cost of the 990 units sold on December 16?