Days on Hand Report

Days on Hand Report

The Days On Hand report is a tool for comparing current inventory levels against expected usage.

CostGuard compares your current on-hand to your target inventory. Target inventory is your prior week ideal usage (from sales), which you can scale up or down by a target multiplier (e.g., 1.1, so you can build in some flexibility).

The variance is expressed in units and dollars; this alert report will rank by dollars, and can either be:
1. Signed (e.g., starting with your negative values, then your positive values)
2. Expressed by ‘absolute value’ (i.e., by the unsigned amount). That would mix your negative and positive amounts together.
 

Data ranked by signed value (the default)

 

DOH 2
 

Data ranked by absolute value

 

days on hand