Benefits of the TMS Data Cleanse Service The TMS Data Cleanse capability offers fast, automated update cycles that keep parts catalogues and data current. It ensures accurate parts information at the point of use through up-to-date Illustrated Parts Catalogues and Inventory Lists. By correctly associating Manufacturer Part Numbers (MPNs) with NATO Stock Numbers (NSNs), it improves procurement accuracy and ensures OEM recognition of demanded items. The service also enhances demand accuracy for repair items, helping to reduce wait times, improve equipment availability, and lower costs. Additionally, it significantly reduces the time and resources required for manual data cleansing by automating the identification of anomalies, including within S1000D Data Modules where electronic access is available. Provision of a Managed Service TMS can provide a comprehensive managed service to deliver the Data Cleanse capability. This includes the provision of a secure web portal for hosting cleansed data and enabling database queries, along with user training and Help Desk support. The service encompasses project management, data loading and cleansing, CSIS checks, and regular updates to parts lists, Illustrated Parts Catalogues, and the web portal itself, with update frequencies agreed as part of the service delivery. Note: The Managed Service will be tailored to meet the specific requirements of the Customer.

The NATO Codification System (NCS) is the global standard for identifying military and civilian government supply items using NATO Stock Numbers (NSNs). It provides a uniform method for classification, stock numbering, and item identification, used by all NATO countries. The NCS includes item names, part numbers, supplier details, and technical characteristics, supporting all phases of logistics—from procurement to disposal. The system ensures interoperability across the UK MOD’s tri-services (Army, Navy, RAF) and NATO allies, helping to avoid duplication and inefficiencies in the supply chain. NSNs, each 13 digits long, are assigned based on an item’s form, fit, and function, and catalogued in the Codification Support Information System (CSIS). CSIS also documents manufacturer and supplier information. Accurate parts data is critical. Errors in Illustrated Parts Catalogues (IPCs) or inventory lists can impact demand forecasting, stock levels, repair times, equipment availability, and costs. IPCs rely primarily on two identifiers: the Manufacturer Part Number (MPN) and the NATO Stock Number (NSN). CSIS allows multiple MPNs to be linked to a single NSN, as long as they meet the required form, fit, and function. This raises a key procurement question: which MPN should be selected for a given NSN? The preferred MPN can vary over time due to changing procurement needs or supplier preferences. Because managing NSN and MPN data is labour-intensive and costly, many parts lists are often misaligned with CSIS and OEM data.

TMS has developed a system and supporting processes to automate the identification and correction of data inaccuracies related to NATO Stock Numbers (NSNs) and Manufacturer Part Numbers (MPNs) across multiple Illustrated Parts Catalogues (IPCs) and inventory lists. Where possible, the system automates key tasks to deliver accurate, curated parts data across multiple platforms. It also enables the automatic regeneration of Parts Lists and IPCs with minimal manual input.

Pillar 1: Data Input Source data—typically provided in MS Word, Excel, AESP, BR, or DAP format—is processed and extracted into a structured database. Each dataset is manually validated against the source material to ensure the accuracy of the original IPC or Parts List. This initial processing is essential to enable the automated checking, cleansing, and updating in later pillars. With slight modifications, data can also be extracted from S1000D Data Modules, depending on access to the electronic reader. Pillar 3: Data Cleanse Assistance (Optional) Errors identified in the Anomalies Report—such as incorrect formatting or inconsistent nomenclature—are corrected automatically where possible. More complex discrepancies, like mismatched NSNs and part numbers or missing data, are manually resolved in collaboration with the MOD or OEM. This results in a clean, curated dataset using standardized terminology and formatting. Pillar 5: Parts Catalogue Update (Optional) Using the cleansed data, the system can automatically regenerate updated Parts Lists or Illustrated Parts Catalogues to match the original format (e.g., AESP, BR, or DAP). While automated, IPCs generated in Microsoft Word are subject to manual visual checks to ensure compliance with Defence Standards. For S1000D electronic data modules, visual checks are unnecessary, allowing for a more cost-efficient process.

Pillar 2: Pre-Cleanse and CSIS Check After populating the database, a pre-cleanse check is conducted. NSNs and MPNs are validated for correct formatting and interrogated against the CSIS database. Supply Management Data (SMD) from CSIS is used to verify item descriptions. Anomalies are flagged and reported. These reports can be provided to the customer for resolution using internal resources, allowing TMS to reload corrected data and proceed to the next phase. Pillar 4: Consistency Check (Optional) This optional stage complements the data cleanse process. It involves identifying the preferred MPN for a given NSN based on platform applicability and manufacturer information. The goal is to ensure that part selections are consistent and aligned with procurement priorities and technical requirements. Pillar 6: Data Interrogation and Reuse (Optional) TMS engages with OEMs and other stakeholders to validate the cleansed data against their records. Any new errors identified are manually corrected and updated in the system. All changes are tracked and re- checked to ensure consistency. This ensures alignment of parts data across multiple systems and supports integration with external platforms such as MJDI, CRISP, or GoldESP. It also allows quick cross-checking of stock holdings or warehouse lists against IPCs.

Accurate scoping of the task and therefore pricing of the service cannot be provided until the source information is extracted from MS Word or MS Excel, verified for accuracy and numerical format, loaded into the TMS Data Cleanse database and an initial analysis conducted to identify the total number of individual items/parts/NSNs to be checked against CSIS.

The following paragraphs, based on a Land platform, explain in further detail. The Land platform AESP Category 711 comprises 5,468 pages. By halving this page count to cater for an illustration every other page and multiplying that half page count by 20 listed items/parts/NSNs per page (based upon empirical data), it provided an estimated 2,734 pages to be processed with an estimated spared items count of 54,680 items (2,734 X 20). Further analysis following data upload into the Data Cleanse database, revealed that there are only 40,000 listed items; of which some items/parts/NSNs are used multiple times (duplicate items). Removing the duplicate items, to a single incidence of each, brought the number of individual items for checking against CSIS down to 16,709 individual items - a 69.4% reduction from the estimated 54,680 items as used in our initial assessment. Note: We have defined a unique individual item as being a NSN and part number pairing and not just the NSN or just the part number. The reduction in the number of items to check on the Land platform alone is provided for clarity in the table below: Table 1 – Platform 1 Estimated Scope VS Accurate Item Count Analysis Family Planning Since Individual platforms also form part of a family of platforms from a single manufacturer, further efficiencies can be had by identifying common use items/parts/NSNs across numerous platforms prior to conducting the CSIS check. This is tabled below by way of explanation: Table 2 – 4 Platforms grouped as a Family Individual Items Count Having loaded all four Platforms into the database we were able to identify common items and remove duplicate items to a single instance across all four platforms to quantify the fleet’s total number of individual items to be checked against CSIS. Table 3 – Combined Family Planning Scope Reduction SUMMARY To summarise, there are significant efficiency gains to be had using an accurate method of calculating the item count and therefore the scope of this task when combining families of platforms/equipment. However, to arrive at an accurate scope and therefore cost, it does require up front work on behalf of TMS to undertake the initial data verification, load and unique items analysis. Based upon the initial calculations of the combined Platform fleet comprising 18,018 Parts Catalogue pages, half of which comprise 20 items per page (estimated 180,180 total number of items) we can reduce the scope of requirement to conduct the initial data verification, upload, CSIS check and the production of an Anomalies Report from the initial anticipated item count of 180,180 items down to 36,776 items, a reduction of 79.5% in real terms to the overall scope of the combined Data Cleanse task. Note: The more information we can upload into the Data Cleanse capability, the less we will need to check CSIS for accuracy and further efficiency gains can be made. ADDITIONAL OPTION CAPABILITY In addition to the baseline service—which includes data receipt, verification, input, and a single CSIS check with an accompanying Anomalies Report in MS Excel format—TMS offers several optional capabilities. These include the provision of an updated Parts Catalogue in electronic file format, a detailed Consistency Check to verify preferred MPN selection, and the Data Interrogation and Reuse service, which enables cross- checking and alignment with stakeholder systems. Additional services also include the conversion of PDF documents to MS Word format along with validation of the output, as well as a fully Managed Service supported by a dedicated web portal for client access and ongoing support.