Abstract: A computer program product for managing a supply chain process to maintain equipment is described. The computer program product includes a computer-readable storage medium having computer-readable program code embodied in the medium. The computer-readable program code includes a first executable portion for identifying and capturing data relevant to one or more sets of equipment maintenance requirements, a second executable portion for providing access to the capabilities of a plurality of inventory management, supply chain management, and equipment maintenance applications for preprocessing of the identified and captured data, a third executable portion for receiving the preprocessed data from the plurality of applications, and a fourth executable portion for integrating the preprocessed data into a solution to the one or more sets of equipment maintenance requirements.

Abstract: A data cleaning process includes the steps of: validating data loaded from at least two source systems; appending the validated data to a normalized data cleaning repository; selecting the priority of the source systems; creating a clean database; loading the consistent, normalized, and cleansed data from the clean database into a format required by data systems and software tools using the data; creating reports; and updating the clean database by a user without updating the source systems. The data cleaning process standardizes the process of collecting and analyzing data from disparate sources for optimization models enabling consistent analysis. The data cleaning process further provides complete auditablility to the inputs and outputs of data systems and software tools that use a dynamic data set. The data cleaning process is suitable for, but not limited to, applications in aircraft industry, both military and commercial, for example for supply chain management.