Finance: Inventory Turnover

Efficiency Measure: The Inventory turnover is a measure of the number of times inventory is sold or used in a time period such as a year. Formula: COGS/ Average Inventory

 

'Calculate Inventory Turnover
'Formula: Cost of Goods Sold / Average Inventory

Return api.Data.GetDataCell("Divide(A#[YourCOGSAccount], A#[YourInventoryAccount]:V#YearAvgToDate)")