cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic Safety Stock Calculation

Former Member
0 Kudos

Dear All,

We have set Dynamic Safety stock for finish good.

Below is the screen snap for Coverage profile for your reference,

After MRP we have get results as shown in below screen,

Also find Monthly results for the same in below screen,

Can anybody who has worked or Dynamic Safety stock please explain the calculation in detail for this scenario.

Thanks,

Narresh

View Entire Topic
marianoc
Active Contributor
0 Kudos

Hi Narresh,

Setup:

In the session:  "Determine average requirements" you specify how the average demand will be calculated. In your case you said that you want to consider 3 months (Number of periods = 3) and you said that each month has 30 days (Type of per.length = 3 and No of Days per Period = 30).
Then in the session "Range of coverage in the first period" you said that you want to cover 30 days of daily sales with your safety stock.


Calculation:

The 1st thing that the system will calculate is your daily demand, based on your setup. In your example, the system will get the total requirement that you have in the next 3 months (30 days per month) and will divide this by 90 days (3 month of 30 days per month).

Total Requirements of the following 90 days:

- 3000 (PIR of Aug 1st)

- 3000 (PIR of Sep 1st)

- 4000 (PIR of Oct 1st)

Total = 10000 CS

Daily Requirements = 10000 CS / 90 days = 111.11 CS per day

The 2nd thing that the system does is to calculate how many cases you need to produce to get a coverage of 30 days:

Total Coverage = 30 days x 111.11 CS per day = 3333.33 CS.

So if you see the on Aug you will produce 6333.33 CS (3000 CS for your forecast and 3333.33 CS to build your Safety Stock).

Thanks and Regards,

Mariano

marianoc
Active Contributor
0 Kudos

Hi Narresh,

Do you have any further question? If not please, could you please close the thread by indicating the correct answer or resolution. It could be helpful to others in futures searches on SCN.

Thanks a lot.
Mariano

Former Member
0 Kudos

Hi,

Thanks a lot for your explanation. It helped me to understand the calculation.

Thanks,

Narresh