OSAdmin
Valued Contributor

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)")
Version history
Last update:
‎03-31-2022 10:30 AM
Updated by:
Contributors