Days of Supply

[former_member503200]

We got daily, weekly and monthly buckets in our SNP Planning Book. We use Day’s supply standard macro, it’s calculating correctly for weekly and monthly but not daily. The values are little bit off.

If u select the data for multiple locations and drill down by location, by location the day’s of supply values are OK. But if u checks the total of days of supply, it doesn’t make sense. The total values are neither average nor sum. How to read this total No.

Any advise is greately appreciated.

thx

Jeff

[former_member503200]

Problem is resolved.

thx

Jeff

[srinivas_krishnamoorthy]

Firstly, the days of supply relationship is not linear in nature (it is not additive). The days of supply (check the macro in the workbench and double click on the macro) macro is designed to work only at Details All level. You can try to swtich that to All Planning Objects to see if it works.

Please check the calculation at Total level anyways - is it that the sum of forecasts during the days of supply = projected stock level in that bucket ?

You may want to check

to see if it is possible to hide the total row.

You may want to try with different data patterns to make sure the calculation is indeed happening correctly at weekly or monthly levels.