Please add 5 column as sample with dept and sub dept in this table also.
Put remark as " Most critical number 1-5 " (month on hand >30 >20 >15 >10 >5 > 3)
Month on hand less than 3 month " Should be fine "
After 2 months sales stock negative " Should re-order"
Try to see in each group of remark such as " Most critical number 1 ".
Month on hand are over 30 months that we need to do something now. (buyer action)
But some SKU such as the yellow highlight have huge stock since before this promotion start. Why ? How come ?
Example SKU 8850304096535, buyer request only 2,767 units but currently stock = 17,590 units. Means stock was 15,000 since beginning. Why ? How come ?