In: Accounting
|
|
|
|
|
Average cost = Total cost of inventory/total no. of units = (5130+15840+10350+15750+5040)/2250= $23.16
FIFO
January 1- 270 units @ $19
March 15- 720 units @ $22
July 20 - 450 units @ 23
Sept 4- 630 units @25
Dec 2 - 180 units @28
Sale - 1800 units
COGS - 270 units @ $19 + 720 units @ $22 + 450 units @ 23 + 360 units @25 = 5130+15840+10350+9000
= $40320
Closing inventory- 270 units @25 +180 units @28= 6750+5040 = $11,790
LIFO
January 1- 270 units @ $19
March 15- 720 units @ $22
July 20 - 450 units @ 23
Sept 4- 630 units @25
Dec 2 - 180 units @28
Sale - 1800 units
COGS - 180 units @28 + 630 units @25 + 450 units @ 23 + 540 units @22 = 5040+15750+10350+11880=
= $43020
Closing inventory- 180 units @22 +270 units @ $19= $3960+$5130 = $9090
Average cost
Average cost = Total cost of inventory/total no. of units = (5130+15840+10350+15750+5040)/2250= $23.16
COGS = 1800*23.16 = $41,688
Closing Inventory = 450*23.16 = $10,422
Hence,
Highest cogs - LIFO
Highest Closing Inventory - FIFO