Material management and Inspection system

The application is to control all materials at the “Incoming” stage The source list for all the materials will be supplied from an MS Excel file that will be generated from the existing MRP system. Below is the list of all the Inspection processes involved in the system - VISUAL INSPECTION (VI) o Each category will have its own set of checklist o The checklist for each category must be revision controlled, whereby if there are any modifications done to a checklist, all prior inspection will still hold the data based on the old checklist. o Checklist for each category will be provided - DIMENSION MEASUREMENT o The results are obtained from a measurement equipment through an MS Excel file which will be stored on the network share drive. o This file will be required to be automatically detected and extracted and its results saved in the DB. o All values/decision are contained within this file o Sample file will be provided - THICKNESS MEASUREMENT o This would just involve a measurement taken by a micrometer o Micrometer is connected via USB and acts as a HID device (keyboard input device) System will just need an interface to capture and store the results. o The tolerance for the measurement (Upper Limit / Lower Limit) will be based on individual material and will be needed to be stored in the DB (Material Master) - COATING THICKNESS MEASUREMENT o This would just involve a measurement taken by a micrometer o Data entry is manual entry o System will just need an interface to capture and store the results. o The tolerance for the measurement (Upper Limit / Lower Limit) will be based on individual material and will be needed to be stored in the DB (Material Master) - ESD MEASUREMENT o This would just involve a measurement taken by a micrometer o Data entry is manual entry / Possibility of HID device o System will just need an interface to capture and store the results. o The tolerance for the measurement (Upper Limit / Lower Limit) will be based on individual material and will be needed to be stored in the DB (Material Master)