The Elsmar Cove Business Standards Discussion Forums More Free Files Forum Discussion Thread Post Attachments Listing Elsmar Cove Discussion Forums Main Page
Welcome to what was The Original Cayman Cove Forums!
This thread is carried over and continued in the Current Elsmar Cove Forums

Search the Elsmar Cove!

Wooden Line
This is a "Frozen" Legacy Forum.
Most links on this page do NOT work.
Discussions since 2001 are HERE

Owl Line
The New Elsmar Cove Forums   The New Elsmar Cove Forums
  QS-9000
  Supplier Tracking Software

Post New Topic  Post A Reply
profile | register | preferences | faq | search

UBBFriend: Email This Page to Someone! next newest topic | next oldest topic
Author Topic:   Supplier Tracking Software
Steven Sulkin
Forum Contributor

Posts: 75
From:Columbus, Ohio
Registered:

posted 13 August 1998 03:27 PM     Click Here to See the Profile for Steven Sulkin   Click Here to Email Steven Sulkin     Edit/Delete Message   Reply w/Quote
We need to track on time delivery, non conformances, and corrective actions from our suppliers. Anyone have an access or excel database we can use?

Please email me at sulkinsf@tsmd.com

Thanks in advance.

IP: Logged

Dawn
Forum Contributor

Posts: 245
From:St. Marys, PA
Registered: Sep 98

posted 25 October 1998 06:28 PM     Click Here to See the Profile for Dawn   Click Here to Email Dawn     Edit/Delete Message   Reply w/Quote
Same problem here Steven. I am also looking for a good program. (and cheap). I will let you know if I find something!

IP: Logged

Marc Smith
Cheech Wizard

Posts: 4119
From:West Chester, OH, USA
Registered:

posted 09 October 1999 03:52 PM     Click Here to See the Profile for Marc Smith   Click Here to Email Marc Smith     Edit/Delete Message   Reply w/Quote
Don't forget to let us know here what you find out.

IP: Logged

Andy Bassett
Forum Contributor

Posts: 274
From:Donegal Ireland
Registered: Jun 1999

posted 14 October 1999 09:26 AM     Click Here to See the Profile for Andy Bassett   Click Here to Email Andy Bassett     Edit/Delete Message   Reply w/Quote
Just for info
I once created a simple excel database with 3 sheets in it;
One for overdue deliveries
One for Quality Problems
One for Invoice defects.
Purchase were able to complete this becuase all the above information ran over their desk ie they received copies of all the QC Rejection Sheets. They had to sign off all invoices that did not match the orders. And they got a simple print-out every Thursday of which suppliers were overdue with deliveries.
All very crude, but you should aim for a consistent system, not a high tech system.
Problems

A. Programmer made a small programme that allowed you to press a button and produce a ream of paper that compared the suppliers with each other. Ie in January supplier X is our top supplier. PROGRAMME never worked, but to do this manually was not more than 2-3 hours work per month.
B. Purchasers needed a lot of discipline to keep entering the data. Make the sheets as simple as possible, ie no more than 4-5 columns.

My experience is that if you want the system to be maintained it should be very simple. It does not matter what it is telling you (At least at the beginning of the implementation)it should however be consistent.
You will be amazed at the suppliers reaction when they know that they are being measured (Irrespective what the results actually say).

Regards

------------------
Andy B

IP: Logged

Steven Sulkin
Forum Contributor

Posts: 75
From:Columbus, Ohio
Registered:

posted 14 October 1999 02:50 PM     Click Here to See the Profile for Steven Sulkin   Click Here to Email Steven Sulkin     Edit/Delete Message   Reply w/Quote
Have you been using the excell sheets a while? How many buyers do you have?

We are developing a more automated approach, though I like the idea of a simple spreadsheet. We just purchased a piece of software to help us query for reports a little easier. Our current measure is avg (price variance from standard, delivery, and percent conforming).

Our next step is to use the report to write corrective action requests and develop suppliers, but that's an entirely different matter, for a time that is far, far away, on a Distant planet and all.

IP: Logged

Steven Sulkin
Forum Contributor

Posts: 75
From:Columbus, Ohio
Registered:

posted 14 October 1999 02:53 PM     Click Here to See the Profile for Steven Sulkin   Click Here to Email Steven Sulkin     Edit/Delete Message   Reply w/Quote
Andy- do you track corrective actions too? We have since decided to absorb tracking into our internal corrective action system. A lots changed since I first posted

IP: Logged

Andy Bassett
Forum Contributor

Posts: 274
From:Donegal Ireland
Registered: Jun 1999

posted 24 October 1999 04:27 PM     Click Here to See the Profile for Andy Bassett   Click Here to Email Andy Bassett     Edit/Delete Message   Reply w/Quote
Sorry Steve
Only just caught your reply.
One page of the Excel sheet was for Goods-in Quality problems. If we were able to send the goods back (wasnt always the case) we sent them a standard form that asked them;
1.Why didnt you find the problem-
2.What was the cause of the problem.
3.What are you going to do to correct the problem in the future.
The number of the form and the date of the reply was noted in the excel sheet, and yes the supplier was chased if he didnt answer.

In all honesty a greater emphasis was placed on getting a reply from the supplier than what the reply actually said.

Does this help.

As regards the Corrective Action system, irrespective of where the problems have come from i have nearly always orgnaised that they go into an Excel sheet so that someone can maintain an overview.

Regards

Andy

IP: Logged

Marc Smith
Cheech Wizard

Posts: 4119
From:West Chester, OH, USA
Registered:

posted 09 November 1999 02:20 PM     Click Here to See the Profile for Marc Smith   Click Here to Email Marc Smith     Edit/Delete Message   Reply w/Quote
Anyone know anything about Cybermetrics SUPPLIERtrak software?

IP: Logged

All times are Eastern Standard Time (USA)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply Hop to:

Contact Us | The Elsmar Cove Home Page

Your Input Into These Forums Is Appreciated! Thanks!


Main Site Search
Y'All Come Back Now, Ya Hear?
Powered by FreeBSD!Made With A Mac!Powered by Apache!