Inventory ABC
Sales A stock % = total MTS stock on hand
MTO stock is not included.
OBS report (SOH vs 12months demand)
OBS qty = SOH -quality/damange block qty - max(6months demand*2, SO)
Not including damange/quality block qty
DIO(SOH value vs daily cost of stock)
DIO=Stock value/daily demand/(1-local margin/100)
daily demand = 3month demand/91.25
Slow moving report (SOH vs 3months demand)
Slow moving qty = SOH - Max (SO, 3month demand)
Overstock report (SOH vs 2wks demand)
Max stock for MTS = safety stock + max( 2 wks demand,SO)
Max stock for MTO = Max(SO, MOQ)