Method and system for real-time monitoring of part availability
A method and system for real-time monitoring of part availability uses a computer-based data integration system communicating with at least one plant related database and at least one supplier related database to collect part usage and shipment data and to assess the collected data to predict an exception to a scheduled part need time. When an exception is predicted, the data integration system generates an alert indication to personnel for taking corrective action.
1 . A system for real-time monitoring of parts availability comprising:
at least one plant related database containing data relating to usage and inventory of the part;
at least one supplier related database containing data relating to shipment of the part; and
a computer-based data integration system in communication with the at least one plant related database and the at least one supplier related database, the data integration system operative to examine in real time data in the at least one plant related database and data in the at least one supplier related database to assess the examined data to predict an exception to a scheduled part need time, and to generate an alert indication to personnel whenever an exception is predicted.
2 . The system of claim 1 wherein the data integration system is further operative to determine that the exception is one of a shortage of the part and a surplus of the part.
3 . The system of claim 1 wherein the data integration system is further operative to determine a degree of the exception.
4 . The system of claim 2 wherein the data integration system is further operative to determine the degree of the shortage or the degree of the surplus.
5 . The system of claim 1 wherein the data integration system is further operative to predict a shortage of the part, the amount of shortage and a required need time adjustment to prevent occurrence of the shortage.
6 . The system of claim 1 wherein the data integration system is further operative to predict a surplus of the part, the amount of surplus, and determine whether the surplus exceeds a safe minimum stock of the part.
7 . The system of claim 1 wherein the at least one plant selected database contains real-time inventory records, physical inventory counts, real-time inventory adjustment data, forecasted part usage data and actual part usage data.
8 . The system of claim 1 wherein the at least one supplier related database contains real-time shipment data including estimated time of part arrival, shipping route data, past and future shipping schedules and real-time supplier shipping status.
9 . The system of claim 7 wherein the at least one supplier related database contains real-time shipment data including estimated time of part arrival, shipping route data, past and future shipping schedules and real-time supplier shipping status.
10 . The system of claim 1 wherein the data integration system assesses the examined data for a predetermined cut-off period for the part.
11 . A method for real-time monitoring of part availability comprising:
collecting real-time data from at least one plant related database concerning usage and inventory of the part;
collecting real-time data from at least one supplier related database concerning shipment of the part;
assessing the collected data to predict an exception to a scheduled part need time; and
generating an alert indication to personnel whenever an exception is predicted.
12 . The method of claim 11 further comprising determining that the exception is one of a shortage of the part and a surplus of the part.
13 . The method of claim 11 further comprising determining a degree of the exception.
14 . The method of claim 12 further comprising determining a degree of the exception.
15 . The method of claim 11 further comprising predicting a part shortage and an amount of the shortage, and calculating a part need time adjustment to prevent occurrence of the shortage.
16 . The method of claim 11 further comprising predicting a surplus of the part and the amount of the surplus, in determining whether the surplus exceeds a safe minimum stock of the part.
17 . The method of claim 11 wherein real-time data collected from the at least one plant related database contains inventory records, physical inventory counts, inventory adjustment data, forecasted part usage data and actual part usage data.
18 . The method of claim 11 wherein real-time data collected from the at least one supplier related database contains estimated time of part arrival, shipping route data, past and future shipping schedules and supplier shipping status.
19 . The method of claim 17 wherein real-time data collected from the at least one supplier related database contains estimated time of part arrival, shipping route data, past and future shipping schedules and supplier shipping status.
20 . The method of claim 11 further comprising assessing the collected data for a predetermined cut-off period for the part.