Executive Summary
I work in supply chain operations management. I have often encountered situations where I need to manually sort through inventory that does not fit our normal operations and do something with it. It is usually a hundred pieces a week that need to be recorded as coming into the warehouse and given a location based upon a few criteria. The problem is it is not enough volume to justify IT creating a patch to the current program to meet the needs of this special item, so I have to waste hours of manpower to do it manually. For my project I created an inventory tracking program in VBA for a video store rental which I could easily convert to whatever inventory I need to track in the future.
I work in supply chain operations management. I have often encountered situations where I need to manually sort through inventory that does not fit our normal operations and do something with it. It is usually a hundred pieces a week that need to be recorded as coming into the warehouse and given a location based upon a few criteria. The problem is it is not enough volume to justify IT creating a patch to the current program to meet the needs of this special item, so I have to waste hours of manpower to do it manually. For my project I created an inventory tracking program in VBA for a video store rental which I could easily convert to whatever inventory I need to track in the future.
The program takes generic information from a
scan able bar-code on a movie. The user
will scan in and out movies and the tracker will keep track of where it is in
the system. When movies come back that
are no longer in high demand the program will sends it to be sold for $5. The tracker keeps track of which employee
checked people out and stops them from making errors. The program looks up information specific to
the bar-code that was scanned in to determine when the movie is due back and
make adjustments to due back date based on if the movie is a blue ray disc,
game, or DVD.
No comments:
Post a Comment