The stock reorder calculation allows you te reset order quantities and reorder levels by using you sales data.
The function allows for delivery times to be calculates in to the average reorder level.
function is using the following input.
Datum : Date to calculate sales from
Muliplier : a extra modifier.
Months for used to calculate the average.
Maximum parameter = MaxParam a minimum to reorder.
Minimum parameter = MinParam a minimum to trigger a order.
in stock you can enter delivery delay in weeks.
TotalSalesInPeriod = all sales from Date to - Months for calculation.
AVG-WEEK = TotalSalesInPeriod / (Months * MultiPlier) ;
REORDER = Round( (DELIVERTIMEWEEK + MinParam) * AVG-WEEK)
REORDER_LEVEL = Round((DELIVERTIMEWEEK + MaxParam) *AVG-WEEK)
After calculation you can apply the new order and reorder quantities by pressing ok.