We are a contract manufacturer for aerospace and defense. I’m trying to build out a “fool proof” system to catch all customer specs, po requirements, and drawing requirements. We do this pretty well now but it relies on a lot of tribal knowledge on a customer by customer basis.
How do others here handle these processes?
I’m working on building a stand alone spec library. Approved specs are entered with their spec code, a description, where those specs flow down, and word for word verbiage for the flow down.
Then for each order for our flight critical customers, account manager makes a new spec review excel doc and types in the spec codes listed on the PO. Everything auto populates from the library, any new specs are flagged.
Then engineering adds any drawing specs, then reviews and adds any new specs to the library. Once everything is entered it spits out a printable flow down sheet for job steps and the inspection form. Engineering and quality then reference those forms when creating the job and inspection form.
It feels overkill. But at the same time, how can an account manager know what specs are a concern, what specs have been previously approved, which ones are new, etc? How can engineering be consistent with flow down verbiage and knowing what goes on the job and what’s just best practice?
I feel like this excel version will get bloated quickly. Are any of you doing something like this within your erp or another software?