Period between Review (PBR) in decimal- SAP IBP Inventory optimization

[former_member696146]

Hello Experts,

Kindly help me with my queries :

a) Is it possible to maintain the PBR in days rather than in number of weeks ? Technically speaking ,I could see a possibility of PBR maintenance in decimals (say 0.0285 for every periodic review of 2 days) in the system but i could not interpret the result in the right way since the time bucket in planning view is in week.

b)If there is a possibility to maintain the PBR in decimal,does this means my time profile in planning area should also be maintained in day level rather than at week level ?

c)Is the standard SAP best practice is to maintain PBR in number of weeks rather than number of days ?

Please let me know in-case you need further details .

Thanks for your inputs in advance.

Regards,

Praveen

[lev_degtyarov]

Hello Praveen,

as Cris said you can easily create a new stored key figure (e.g. ZPBRDAYS) for data input in days.

Then you must add calculations for PBR@WKPRODLOC = ZPBRDAYS@WKPRODLOC/7.

Make also PBR as calculated and stored KF.

See pictures below for example.

Regards,

Lev

[former_member696146]

Hello Lev,

Thank you for your wonderful suggestion on getting the PBR inputs in days and using the same for the subsequent calculations.Appreciate the same.

Thanks,

Praveen

[chris_topf · Accepted solution]

Hello Praveen,

If you want to express PBR in days, you can certainly do that, just divide the PBR in days by 7 to get the weekly equivalent. For example, if your PBR is every 2 days, than the value you would enter would be 2/7, or 0.2857. IO does all its calculations at the Week level, which is why the daily PBR has to be expressed in the weekly equivalent.

As for your time profile, there is no need to maintain it at the Day level in order to express PBR as a decimal like I mentioned in my first point.

I have seen as many customers with PBR > 1 has I have seen with PBR < 1, so the best practice here is what fits your business!

Regards,
Chris

[former_member696146 · Accepted solution]

Hello Chris,

Thanks for taking your time out and answering me on my query.One point is clear from your earlier comment is that PBR can be maintained in days which is a very important information for me to have in the first place.

My other query was on the understanding on the cycle stock proposed by the system :

If the PBR is in week(say a product is reviewed on a weekly basis or bi-weekly basis) then we have the weekly cycle stock recommendation from IBP system which could be understand by the planner.And if the same is in days the cycle stock number displayed would be very difficult for the planner to interpret (since in one week there could be multiple reviews that could happen). The understanding is much more difficult since the day-wise cycle stock numbers or day-wise pipeline stock numbers are not displayed by the system (due to week base planning level). With the information not being transparent it is very difficult to convince the customer.Do you have a suggestion as how to read the number specially when we have PBR in decimals ?

I had attached a screenshot of our planning area for much better clarification.

Please let me know if you need further details on the same.pbr-decimal-01.png

Thanks,

Praveen

[chris_topf]

Hello Praveen,

sorry for the delay in my reply. IO does all of its calculations at the Calendar Week level, then it disaggregates to the base planning level if the base planning level is lower than that (by default it is Tech Week). Therefore the cycle stock number will indeed not be a daily number. Even though your PBR is 2 days, it is being represented in its weekly equivalent (0.2857). All the outputs are calculated at the week level, so I would encourage you to focus on that point. If the customer wants to think of the cycle stock at the daily level, they could get an estimate by dividing the weekly number by 7, but that would just be a rough average because again, IO does not calculate at the daily level.
Hope that helps.

Chris

[former_member696146]

Hello Chris,

Thank you for your clarification.

Praveen