In: Accounting
1) Ending Inventory under LIFO Method : Under LIFO method, The inventory which comes last in the warehouse is used first. So, in this case ending inventory will be from the inventory purchased very first.
On June 30, there are 232 units in Ending Inventory, from which 174 units of value $1,044 are from June 1 purchase and the remaining 58 units (232 units - 174 units) of value $406 [($1,624/232)*58] are from June 10 purchase.
So, the total value of Ending Inventory = $1,044+$406 = $1,450
2) Ending Inventory under Average Cost Inventory Method : Under Average Cost Inventory Method, The weighted average cost is charged to the cost of Goods Sold and Ending Inventory.
The Average Cost per unit of Inventory = Total Cost of Inventory Purchased/ No. of Units Purchased
= ($1152 +$1792 +$2048+ $1,728)/(192 +256+256+192)
= ($6,720/896) = $7.5 per unit
Value of Ending Inventory = No. of Units in inventory * Average cost per unit
= 256 units* $7.5 = $1,920
3) Ending Inventory under FIFO Method : Under FIFO method, The inventory which comes first in the warehouse is used first. So, in this case ending inventory will be from the inventory purchased last.
On June 30, there are 176 units in Ending Inventory, from which 132 units of value $1,188 are from June 28 purchase and the remaining 44 units (176 units - 132 units) of value $ 352 [($1,408/176)*44] are from June 15 purchase.
So, the total value of Ending Inventory = $1,188+$352 = $1,540