blications_htm_files/31400.png') 0px 0px no-repeat; border-radius: 22px;">

THE benefits/managed service

THE BENEFITS OF TMS DATA CLEANSE SERVICE The TMS Data Cleanse capability brings with it the following benefits: Fast automated update cycle to keep parts catalogues and parts data current Accurate parts data at point of use through current and maintained Illustrated Parts Catalogues and Inventory Lists Improvement in procurement accuracy through identification of correctly associated MPN to NSN Ensures the OEM recognises the item placed on demand Improvement in demand accuracy for repair items, reducing wait times, equipment availability and cost A significant reduction in time taken and resource required to undertake this task manually as automated system focusses on identification of anomalies.
· · · · · ·
Note: The Managed Service will be tailored to meet the specific requirements of the Customer.
PROVISION OF A MANAGED SERVICE TMS are able to provide a managed service to deliver the Data Cleanse capability. The Managed Service would include but not be limited to the following: Provision of a secure web portal to host cleansed data and enable database searches and queries Provision of Help Desk and web portal user training Project Management Data Loading Data Cleansing CSIS Checks. Frequency to be agreed Parts List update (electronic copy). Frequency to be agreed Loading and maintenance of revised data to Web Portal. Frequency to be agreed Illustrated Parts Catalogue update and regeneration. Frequency to be agreed
· · · · · · · · ·
RETURN TO DATA CLEANSE
Copyright © 2024 TMS Support Solutions Ltd. All rights reserved
hr@tmsss.com
We comply with the following standards which ensures that we deliver you the highest possible standards of service: ISO 9001:2015, ISO 14001, DTCT, Cyber Essentials Plus. Our ISO accreditations cover the production and Project Management of the following services: Integrated Logistic Support (ILS) solutions, Technical Documentation, Training (Analysis, Design and Delivery), Safety and Environmental Services, Graphic Design, Electronic data management solutions, Bid Preparation, Translation services, Engineering support.
Accreditations and Standards
contacts
careers
+44 (0) 1476 583370
sales@tmsss.com
Alpha Court Business Park Swingbridge Road, Grantham Lincolnshire, NG31 7XT Tel: Email:
LinkedIn
Privacy Policy
Services
Integrated Logistic Support
Technical Documentation
Training and Visual Design
Environmental and Safety
Nato Codification Management
Support Services & Bid Management
Digital Transformation
Data Cleanse Services
Obsolescence Management

THE benefits/managed service

THE BENEFITS OF TMS DATA CLEANSE SERVICE The TMS Data Cleanse capability brings with it the following benefits: Fast automated update cycle to keep parts catalogues and parts data current Accurate parts data at point of use through current and maintained Illustrated Parts Catalogues and Inventory Lists Improvement in procurement accuracy through identification of correctly associated MPN to NSN Ensures the OEM recognises the item placed on demand Improvement in demand accuracy for repair items, reducing wait times, equipment availability and cost A significant reduction in time taken and resource required to undertake this task manually as automated system focusses on identification of anomalies.
· · · · · ·
Note: The Managed Service will be tailored to meet the specific requirements of the Customer.
PROVISION OF A MANAGED SERVICE TMS are able to provide a managed service to deliver the Data Cleanse capability. The Managed Service would include but not be limited to the following: Provision of a secure web portal to host cleansed data and enable database searches and queries Provision of Help Desk and web portal user training Project Management Data Loading Data Cleansing CSIS Checks. Frequency to be agreed Parts List update (electronic copy). Frequency to be agreed Loading and maintenance of revised data to Web Portal. Frequency to be agreed Illustrated Parts Catalogue update and regeneration. Frequency to be agreed
· · · · · · · · ·
Copyright © 2024 TMS Support Solutions Ltd. All rights reserved
We comply with the following standards which ensures that we deliver you the highest possible standards of service: ISO 9001:2015, ISO 14001, DTCT, Cyber Essentials Plus. Our ISO accreditations cover the production and Project Management of the following services: Integrated Logistic Support (ILS) solutions, Technical Documentation, Training (Analysis, Design and Delivery), Safety and Environmental Services, Graphic Design, Electronic data management solutions, Bid Preparation, Translation services, Engineering support.
Accreditations and Standards
contacts
careers
Services
LinkedIn Privacy Policy
TMS Support Solutions Ltd
TMS Support Solutions Ltd

Task scaling

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 The following services are deemed optional to the baseline service provision which is limited to the receipt and verification of data, data input and a single CSIS check accompanied by an Anomalies Report in MS Excel format: Parts Catalogue Update (Electronic file copy) Consistency Check Data Interrogation/Reuse Conversion of PDF to MS Word and Validation of Output Managed Service and Web Portal
· · · · ·
Platform 1
Total Pages
Total Number of Items
Estimated scope of work
5,468
54,680
Actual listed items
5,468
40,000
Individual items
5,468
16,709
Scope reduction
69.3%
Platform
Total Pages
Estim ated Item Count
Actual Listed Items
Individual Items Per Platform Following Analysis
Platform 1
5,468
54,680
40,000
16,709
Platform 2
8,686
86,860
45,000
17,397
Platform 3
2,020
20,200
13,545
7,528
Platform 4
1,844
18,440
12,902
7,655
Total
18,018
180,180
111,447
49,289
Combined Platform Planning
Total Pages
Number of Unique Individual Items
All Platforms
18,018
49,289
Duplicate items to be removed
18,018
12,513
Consolidated item count
18,018
36,776
Further scope reduction
25.3%
Copyright © 2024 TMS Support Solutions Ltd. All rights reserved
We comply with the following standards which ensures that we deliver you the highest possible standards of service: ISO 9001:2015, ISO 14001, DTCT, Cyber Essentials Plus. Our ISO accreditations cover the production and Project Management of the following services: Integrated Logistic Support (ILS) solutions, Technical Documentation, Training (Analysis, Design and Delivery), Safety and Environmental Services, Graphic Design, Electronic data management solutions, Bid Preparation, Translation services, Engineering support.
Accreditations and Standards
contacts
careers
Services
LinkedIn Privacy Policy
TMS Support Solutions Ltd