How is BRP and BSL Calculated

 

BSL - Best stocking level Calculation

 

CY = Number sales during the date range this year and

PY = Number of sales during the date range of the previous year

WF 1 = Weighting factor for the most recent 12 months

WF 2 =Weighting factor for previous 12 months

If part has been in inventory less than 24 month or the date history began is less than 24 months then WF1  = 1 and \WF2 = 0

 

BSL = Round((CY * WF1) + (PY * WF2)

 

INC = Percentage Increase (+) or Decrease (-)

 

 

BRP - When the stock order should trigger

 

BRP = Safety Stock + Average Daily Usage X Lead time

 

Also needs to take into account full bin quantity so on hand will not exceed this number and per job quantity.