Hi,
I don't quite understand how days' supply is calculated when multiple differend periodicities are used in same data view. Here are some actual key figure values from our system:
D1 D2 D3 D4 D5 D6 D7 W1 W2 W3
Total demand 3567 3457 3949 3844 3856 1776 500 20984 20390 21886
Stock on hand 11204 7746 9557 5713 7617 5842 5341 4518 4768 5442
Days' supply 2,99 1,99 3,16 2,16 3,78 2,78 1,78 1,55 1,52
With weeks, for example W2, calculating days' supply is clear. Take total demand from week W3, divide it by number of work days and then divide stock on hand from W2 with the result. So for week W2, days' supply would be 4768 / ( 21886 / 7 ) = ~1,52. Same formula can be applied to W1 and the result is completely logical. However, I dont understand how are values of days' supply derived when values are in days. For example, if I try to apply aforementioned formula to D4 (Take total demand from D5, divide it by one(I know, pointless but just to stay consistent) and divide stock on hand from D4 with results). The result should be 5713 / (3856 / 1) = ~1,48. But the default macro returns value 2,16 for D4, why? The macro appears to use SD and RC calendars to determine work days, but those have not been defined in location master. Does this have something to do with the planning buckets profile that is used in this data view?
Regards,
Prikka
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.