Hello Fellow Cove Dwellers...
Looking for your thoughts and ideas on this lovely dillemma...
Our company uses Microsoft programs for everything: Excel is used for product files, Word is used to make quality documents, Access is used for our Order Tracker documents (Job Traveller).
Here is the issue:
When a job is ordered, new or existing, a New Order Form is filled out and handed off to scheduling. If the job is new, a product development form is handed off to R&D to create the product.
Continuing with the idea that the product is new, it is not formulated yet, but the New Order form is given to Logistics who prints off an Order Tracker. Because the job is new, it doesnt have a code number yet. So in the "Product Code" section, "TBF" is placed instead. (To Be Formulated).
The code that is put into that section carries over to other documents in the Order Tracker, including the temporary labels that Production uses to identify the product in the containers. Thus, a lot of products end up being labeled as "TBF".
There is other information on the labels to identify what the product is, such as a lot number, the customer, and the description of the product.
My first thought, was "Why dont we wait on printing the Order Tracker, until a code is given?" I was informed that if we waited for that, it would delay getting it onto the schedule and we would be giving our customers a 5 to 6 week lead-time, which is unacceptable.
Second thought, "Can we just give it a new code immediately when R&D gets the work?" I was informed, No. Because sometimes customers have us use their own codes, so it will actually save us time and work if we use there codes..
This process has gotten on my nerves frankly for the last few years...
Anyone have any thoughts on this wonderful process?
Thanks much!
Looking for your thoughts and ideas on this lovely dillemma...
Our company uses Microsoft programs for everything: Excel is used for product files, Word is used to make quality documents, Access is used for our Order Tracker documents (Job Traveller).
Here is the issue:
When a job is ordered, new or existing, a New Order Form is filled out and handed off to scheduling. If the job is new, a product development form is handed off to R&D to create the product.
Continuing with the idea that the product is new, it is not formulated yet, but the New Order form is given to Logistics who prints off an Order Tracker. Because the job is new, it doesnt have a code number yet. So in the "Product Code" section, "TBF" is placed instead. (To Be Formulated).
The code that is put into that section carries over to other documents in the Order Tracker, including the temporary labels that Production uses to identify the product in the containers. Thus, a lot of products end up being labeled as "TBF".
There is other information on the labels to identify what the product is, such as a lot number, the customer, and the description of the product.
My first thought, was "Why dont we wait on printing the Order Tracker, until a code is given?" I was informed that if we waited for that, it would delay getting it onto the schedule and we would be giving our customers a 5 to 6 week lead-time, which is unacceptable.
Second thought, "Can we just give it a new code immediately when R&D gets the work?" I was informed, No. Because sometimes customers have us use their own codes, so it will actually save us time and work if we use there codes..
This process has gotten on my nerves frankly for the last few years...
Anyone have any thoughts on this wonderful process?
Thanks much!