Computer went down over the weekend. Thanks for the replies.
All I'm really looking to do is tighten up the numbers a little better and mechanize the procedure to take some burden off the the guys in the feild and let them focus on other issues. Most of the proccess is performed already, I just want to introduce the computer to "remember" what parts went and/or are where. The system looks something like this:
All receipts have a job name or destination name ("so-'n-so's truck, or shop). Every time material is moved from one loaction to the other it is documented on a sheet in the field.
Bill's truck-----> Job XYZ
Shop ------------> Job XYZ
Supply house (recepit) ---> Job XYZ
Job XYZ----------> Fred's truck
Job XYZ----------> Job ABC
You get the idea. All sheets are turned in to be entered by an office person. The adds and subtracts should all settle to a bottom line of what you have purchased and where it is. Then (as Les does) quarterly or whenever do an audit. That will tell you how accurate it is.
Right now I am a 3-4 man shop including me, but I want to develop a system that is "scalable" as they say. I would rather develop the system first and then plug the people into it.
But this info is needed and needed to be accurate if one has any hope of looking to see how well a job went, check against bidding, catch mistakes, reward or punish performance, or begin a profit sharing program that is fair, and by fair I mean accurate.