Inventory

This section lists the Key Performance Indicators (KPI) for the Inventory domain and the calculation used to determine their results.
KPI name KPI calculation
3 Months Average Inventory
Sum ( AvgInv 1 +….+Avg 3)/3
6 Months Average Inventory
Sum ( AvgInv 1 +….+Avg 6)/6
9 Months Average Inventory
Sum ( AvgInv 1 +….+Avg 9)/9
12 Months Average Inventory
Sum ( AvgInv 1 +….+Avg 12)/12
15 Months Average Inventory
Sum ( AvgInv 1 +….+Avg 15)/15
18 Months Average Inventory
Sum ( AvgInv 1 +….+Avg 18)/18
3 Months COGS
Sum (Cost 1 +….+Cost 3)
6 Months COGS
Sum (Cost 1 +….+Cost 6)
9 Months COGS
Sum (Cost 1 +….+Cost 9)
12 Months COGS
Sum (Cost 1 +….+Cost 12)
15 Months COGS
Sum (Cost 1 +….+Cost 15)
18 Months COGS
Sum (Cost 1 +….+Cost 18)
3 Months Turn
IF([IU_Inventory_date: Sum: IU_3_MonthsInv] is null or [IU_Inventory_date: Sum: IU_3_MonthsInv] = 0,0,(IFNULL([IU_Inventory_date: Sum: IU_3Months_COGS],0.00)/[IU_Inventory_date: Sum: IU_3_MonthsInv])*4)
6 Months Turn
IF([IU_Inventory_date: Sum: IU_6_MonthsInv] is null or [IU_Inventory_date: Sum: IU_6_MonthsInv] = 0,0,(IFNULL([IU_Inventory_date: Sum: IU_6Months_COGS],0.00)/[IU_Inventory_date: Sum: IU_6_MonthsInv])*2)
9 Months Turn
IF([IU_Inventory_date: Sum: IU_9_MonthsInv] is null or [IU_Inventory_date: Sum: IU_9_MonthsInv] = 0,0,(IFNULL([IU_Inventory_date: Sum: IU_9Months_COGS],0.00)/[IU_Inventory_date: Sum: IU_9_MonthsInv])*1.333333)
12 Months Turn
IF([IU_Inventory_date: Sum: IU_12_MonthsInv] is null or [IU_Inventory_date: Sum: IU_12_MonthsInv] = 0,0,(IFNULL([IU_Inventory_date: Sum: IU_12Months_COGS],0.00)/[IU_Inventory_date: Sum: IU_12_MonthsInv])*1)
15 Months Turn
IF([IU_Inventory_date: Sum: IU_15_MonthsInv] is null or [IU_Inventory_date: Sum: IU_15_MonthsInv] = 0,0,(IFNULL([IU_Inventory_date: Sum: IU_15Months_COGS],0.00)/[IU_Inventory_date: Sum: IU_15_MonthsInv])/1.25)
18 Months Turn
IF([IU_Inventory_date: Sum: IU_18_MonthsInv] is null or [IU_Inventory_date: Sum: IU_18_MonthsInv] = 0,0,(IFNULL([IU_Inventory_date: Sum: IU_18Months_COGS],0.00)/[IU_Inventory_date: Sum: IU_18_MonthsInv])/1.5)
Inventory Turns
Cost of Goods Sold / Average Inventory
Cost
IF([ICSWU_DS.icswu_avginvval_1]=0 and [ICSWU_DS.icswu_statustype]='o',0,IIF(IFNULL([ICSWU_DS.icswu_overusage_1],0.00) <> 0 or [ICSWU_DS.icswu_overreasty_1] is not null,(IFNULL([ICSWU_DS.icswu_overusage_1],0.00)*IFNULL([ICSWU_DS.icswu_unitcost_1],0.00)),(IFNULL([ICSWU_DS.icswu_normusage_1],0.00)*IFNULL([ICSWU_DS.icswu_unitcost_1],0.00))))
Line Hits
Line Hits = # of times a product appears on a sales order
[IU_Inventory_date: Sum: IU_linehits]
Lost Business Hits
# of times a product is marked as Lost Business on a sales order
[IU_Inventory_date: Sum: IU_linehitslb]
Warehouse Transfer Hits
# of times a product has been transferred on an order
[IU_Inventory_date: Sum: IU_linehitswt]
Total Hits
Line Hits + Lost Business Hits + Warehouse Transfer Hits
IU_linehits + : IU_linehitslb + : IU_linehitswt
On Hand Quantity
icsw.qtyonhand – icsw.qtyreservd – icsw.qtycommit - icsw.qtybo – icsw.qtydemand + icsw.qtyrcv
[icqty]=([ICSW.qtyonhand][ICSW.qtyunavail]+[ICSW.qtyrcvd])- ([ICSW.custqtyonhand]+[ICSW.custqtyunavail]+[ICSW.custqtyrcvd])
On Hand Average Inventory Value
((IFNULL([ICSW.icsw_qtyonhand],0.00)-IFNULL([ICSW.icsw_qtyreservd],0.00)-IFNULL([ICSW.icsw_qtycommit],0.00)-IFNULL([ICSW.icsw_qtybo],0.00)-IFNULL([ICSW.icsw_qtydemand],0.00)+IFNULL([ICSW.icsw_qtyrcvd],0.00)) * IFNULL([ICSW.icsw_avgcost],0.00))
On Hand Standard Inventory Value
((IFNULL([ICSW.icsw_qtyonhand],0.00)-IFNULL([ICSW.icsw_qtyreservd],0.00)-IFNULL([ICSW.icsw_qtycommit],0.00)-IFNULL([ICSW.icsw_qtybo],0.00)-IFNULL([ICSW.icsw_qtydemand],0.00)+IFNULL([ICSW.icsw_qtyrcvd],0.00)) * IFNULL([ICSW.icsw_stndcost],0.00))
Normal Usage
[IU_Inventory_date: Sum: IU_normusage]
Transfer Usage
[IU_Inventory_date: Sum: IU_transusage]
Override Usage
[IU_Inventory_date: Sum: IU_overusage]
Hits % All Items
IF([oeel_invoicedt: # lineno] is null or [IU_Inventory_date: Total Hits] = 0,0,([oeel_invoicedt: # lineno]/[IU_Inventory_date: Total Hits])*100)
Inventory Value (Avg)
[icsw_InventoryValue_Avgcost]=[ICSW.avgcost]+IIF([Level(SASC.SASC).sasc_icincaddgl]='true',[ICSW.addoncost],0)*[costperunitstk]*[icqty]
Inventory Value (Lst)
[icsw_InventoryValue_Lastcost]=[ICSW.lastcost]+IIF([Level(SASC.SASC).sasc_icincaddgl]='true',[ICSW.addoncost],0)*[costperunitstk]*[icqty]
Inventory Value (Repl)
[icsw_InventoryValue_Replcost]=[ICSW.replcost]+IIF([Level(SASC.SASC).sasc_icincaddgl]='true',[ICSW.addoncost],0)*[costperunitstk]*[icqty]
Inventory Value (Stnd)
[icsw_InventoryValue_Stndcost]=[ICSW.stndcost]+IIF([Level(SASC.SASC).sasc_icincaddgl]='true',[ICSW.addoncost],0)*[costperunitstk]*[icqty]