I have 3 domains of supplier data (Jan 2017 to Jan 2022) and they are as follows
a) Purchase data - Contains all the purchase (of product) data made by the suppliers with us. It contains columns such as
purchase date, invoice number, product id,supplier id,project name
b) Inventory data - Contains the stock/inventory info of our product with the suppliers (in their warehouse). This is reported every month. It contains columns such as
supplier id, product id, inventory_reported_date, qty_in_stock etc. There is no project name here.
c) Order backlog data - Contains the pending orders yet to be delivered by us to the suppliers. Meaning, the suppliers have already booked orders with us for products but we are yet to deliver. It contains columns such as
supplier id, supplier name, product id, qty ordered, supplier_requested_delivery_date,company_delivery_confirmed_date etc
Now, I would like to come up with a rule to identify suppliers who are likely to leave us or stay with us. We plan to build supplier attrition ML model. For this, however, we don't have any ground truth with us (to know whether a supplier left us or not). So, we would like to create rule based label to indicate supplier attrition risk. It could be high risk and low risk. Meaning, high risk indicates supplier who is highly likely to leave and low risk means supplier who is less likely to leave us
please note that a supplier can buy same product multiple times for the same project and also for different projects
some of the points that I could think of is as below but am not sure whether it is correct or logical
a) Decline in order backlog - I can find out the average order backlog for a specific product by a supplier over time (Jan 2017 to Jan 2020) and how it is doing from Feb 2020 to Jan 2022. If the trend is declining, should I mark it as high risk?
b) Decline in purchase history - I can find out the average purchase time period (like every 3 months, 6 months etc) for a specific product by a supplier over time (Jan 2017 to Jan 2020) and how it is doing from Feb 2020 to Jan 2022. If the trend is declining, should I mark it as high risk?
c) Inventory data - If inventory is not reported for a specific product by a supplier, is it okay to consider that supplier left us for that specific product? But it is not realistic to expect supplier to buy all products available with us. He will only buy what he wants (and reports inventory only for what he buys)
Can I seek your suggestions and views on how we can arrive at a rule based label for supplier attrition scenario?