Ending Inventory Calculator Online

Ad
Ending Inventory Calculator

Ending Inventory Calculator

Ending Inventory is  equal to Beginning Inventory (INR)  added net purchases (INR)  less than cost of goods sold (INR)  . The product in stock at the end of the accounting period.

The formula as,

Ending Inventory = (Beginning Inventory + Net Purchases) – (Cost of goods sold)

Let us Consider,

  • Beginning inventory is the monetary value of the inventory at the beginning of the accounting period;
  • Net purchases is the value of new items in the inventory that were purchased during the accounting period;
  • Cost of goods sold, or COGS, is the direct cost of production of goods that you sell out of the materials from the inventory.

Inventory turnover

Inventory Turnover is equal to Cost Of Goods Sold divided Beginning Inventory added Ending Inventory divided number of value 2.

Inventory Turnover = Cost of Goods Sold / ((Beginning Inventory + Ending Inventory) / 2)

Calculate the Ending Inventory

Beginning Inventory (20,000) , Net purchases (30,000) , Cost of goods sold (30,000)

Ending Inventory = (Beginning Inventory + Net Purchases) – (Cost of goods sold)

Ending Inventory = ($20,000 + $30,000) – ($30,000)

Ending Inventory = ($50,000 – $30,000) = $20,000

Calculate the Inventory Turn Over

Inventory Turnover = Cost of Goods Sold / ((Beginning Inventory + Ending Inventory) / 2)

Inventory Turnover = $30,000 / (($20,000 + $20,000) / 2) = 1.5

The answer is Inventory Turn Over = 1.5

LEAVE A REPLY

Please enter your comment!
Please enter your name here