- There are two levels of calculation for Actual Days Supply; it can be calculated at the Performance or Product level.
- The actual number of days of product supply that are merchandised for a specific planogram is what is referred to at the Performance level.
- The actual number of days of product supply used for the entire project is what is referred to at the Product level.
- Actual Days Supply formulas:
Performance level
Capacity(Performance) / (Unit Movement(Performance or Product) / Movement Period(Planogram or Project))
Product level
Capacity(Product) / (SUM(Unit Movement(Performance or Product) * Number of Stores(Planogram)) for planograms on which the product is allocated) / Movement Period(Project))
Note:
The unit movement for the product on the active planogram (Performance) or across all planograms in the project (Product), for the specified movement period. The Unit Movement data used for calculations may come from the Product-level or Performance-level Unit Movement field, depending on the Use Performance Movement setting on the Performance tab of the Project Properties dialog box.