Safety Stock Calculation Possibility
Hi
I am implementing Oracle OPM-EDD Constrained ASCP.
Type | July | Aug | Sep | Oct |
---|---|---|---|---|
Forecast | 1000 | 1500 | 1800 | 2000 |
Safety Stock |
| 1020 | ||
Beginning On Hand | 500 |
|
|
|
Planned order |
| 2020 | ||
Projected On Hand | 500 | 1020 |
Lets say I launch planning in July. I want to calculate planned order for august. If:
Bucket Days = 30
Safety Stock Percent = 1700
Safety Stock Method = MRP Planned Percent
Can Safety Stock Calculate like this?
Safety Stock = (Demand from today until next bucket days / Bucket Days) * (Safety Stock Percent / 100) = (1800/30)*(1700/100) = 1020
I want Demand from today until next bucket days is forecast in september which is 1800.
Is there any workaround for this requirement?
Thank you
Aji