We have an assembly line that rebuilds units. In order to get the correct parts to the line in a timely manner we need to know which parts are used in the rebuild. This way we can put a percentage of parts (like 67% of the time we need a new thing-a-mabob) Then in the Bill of materials we would put .67 instead of 1. This way we do not over or under stock parts.
But to do this we need to know what is being used and how often they are replaced. The parts are barcoded and we would like to be able to scan the code into access to be able to get the percentages.
This information would help in improving the reliability of the unit as well.
Is there an easy way to get this done? Or do you reccommend another software product that would work easier.
Thanks,
SuePee
Same Circus, Different Clowns
But to do this we need to know what is being used and how often they are replaced. The parts are barcoded and we would like to be able to scan the code into access to be able to get the percentages.
This information would help in improving the reliability of the unit as well.
Is there an easy way to get this done? Or do you reccommend another software product that would work easier.
Thanks,
SuePee
Same Circus, Different Clowns