Hello, I am interested in following inventory patterns of a suppliers inventory levels.
We receive an hourly excel feed and would like to upload this daily into a program that will gauge the progress and digression of all inventory levels of each sku/part # over time. (There are 1000's)
Notify us of all inventory that reaches a level of 0 twice in say a 60 day period (option to select a 30 day period ect.) for at least 5 days or more both times.
Example - Notify us on the 5th day that SKU A is without inventory for the 2nd time within a 60 day period.
Then notify us when the inventory replenishes to 100% for these SKU's (this is when we want to start following the pattern to buy on the 3rd time).
Then notify us when inventory has 30% remaining during the 3rd occurence
Then repeat process for 4th occurrence ect.
Sort by price feature would be nice
Sort ability for length/total # of days without inventory from greatest number of days to least. SKU A - total number of days 16, SKU B total number of days 14.
We also have popular sku's we presently monitor manually to see when inventory is replenished. We would like to be able to input these sku's/part numbers into a program so we can be notified the day the inventory arrives/replenishes.
Can we implement this into an interactive dashboard? I'm not sure if this is the correct terminology. Is this referred to as VBA Excel?
Please let me know your thoughts on this and and an estimate of hours this will take. Any ideas are welcomed and clarification of what I am trying to do.