Announcements

No record found.

Supply Chain Management forum

# Calculating safety stock and reorder point using safety stock journal

Posted on by 43
I am trying to calculate my reorder point for my purchased item using the safety stock journal but I am running into issues with the standard deviation of issues per month.

safety stock formula = service level x standard deviation of demand x lead time
Reorder point formula = average demand per day x lead time + safety stock

My example is below

Average issues per month is 2,749.50 lbs, standard deviation of issues per month is 4,709.43 lbs, service level factor is 95%, and your lead time is 10 days, then your safety stock and reorder point are:

Safety Stock = 1.64 x 4,709.43 x 10 Safety Stock = 77,364.82 lbs

Reorder Point = (2,749.50 / 30) x 10 + 77,364.82 Reorder Point = 78,281.32 lbs

Having a reorder point of 78,281.32lbs is way to high when the monthly average is 2,749.50.  Can someone help me where I am going wrong with the standard deviation of issues per month?  I am grabbing all these numbers straight from the safety stock journal.

#### Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

#### Community Spotlight of the Month

Kudos to Saurav Dhyani!

#### Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

#1

AndrÃ© Arnaud de Cal... 289,192 Super User

#2

Martin DrÃ¡b 225,991 Super User

#3

nmaenpaa 101,148