Awarded

Visual Basic for Apps Job by tonyb1

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)

The idea:

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.

Thanks,

Tony

Skills: Visual Basic for Apps

See more: vba project, vba excel dashboard, tony, sku inventory, pattern repeat, gauge, excel feed price, sku inventory dashboard, custom hello program, interactive excel, program project inventory, implement 2012, inventory dashboard, 504, excel project idea, excel custom number, interactive inventory excel, excel number custom, repeat patterns, program inventory part, inventory daily excel, monitor start process, excel vba upload, project inventory excel, inventory program excel vba

About the Employer:
( 0 reviews ) United States

Project ID: #2552821

1 freelancer is bidding on average $200 for this job

SamNanton

Hired by the Employer

$200 USD in 20 days
(5 Reviews)
3.8