data_conversion_tracking_tool

data_conversion_tracking_tool - Data Conversion Tracking...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Data Conversion Tracking Tool (Sample) EI Toolkit Document version 1.0, December 2003 Last validated: December 2003 1of[Pages] EITK0604 Data Conversion Tracking Tool (Sample) INTRODUCTION See the EI Toolkit for a Data Conversion Overview.doc and Sample development tracking.ppt The following is a SAMPLE of worksheets that may be used in tracking data conversions. This tool was developed and provided by Commercial Industry Company #1 as a reference or sample for programs embarking on a new COTS acquisition. MOCK DATA METRICS CYCLE 4 Data Element RECORDS PERCENTAGES THRESHOLDS FORECAST PERCENTAGES SPEC Loaded Total Weight Loaded MATERIAL Heat Number Tracking 0.1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 75 100 60 85 95 PO POSS Load 0.2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 80 100 20 50 80 Purchase Order (PDMS) 0.2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 80 100 20 50 80 ORACLE Vendor Master Data 0.1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 80 90 90 90 90 COPICS Fab Storage 0.1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 80 100 20 50 80 COPICS Inventory Data 0.1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 80 100 30 50 80 COPICS Product Structure / BOM 0.2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 80 100 20 50 80 OPERATIONS Welding Rod / Company Owned Tools 0.2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 80 95 98 98 98 IMS CDB 0.35 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 80 100 99 99 99 Work Order System 0.45 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 80 95 20 50 80 FINANCE Budgets & Forecasting 0.15 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 80 90 10 20 80 Cost Accounting 0.3 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 90 95 60 80 90 Accounts Payable 0.1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 80 90 50 85 98 Fixed Assets 0.25 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 90 95 97 97 98 General Ledger 0.2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 90 95 96 97 98 PAYROLL Payroll HR Master #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Benefits Deductions #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! PODC #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! HR Absence Tracking Data 0.05 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 60 90 80 90 98 Benefits Data 0.3 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 80 95 70 80 98 Training Data 0.05 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 75 75 60 70 80 Core HR Employee data 0.6 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 90 98 70 80 98 Materials 1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Operations 1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Finance 1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Payroll #DIV/0! #DIV/0! #DIV/0! #DIV/0! HR 1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Production Ready Loaded for chart Production Ready Production Ready Weighted Loaded Weighted Ready for SIT % Ready for Go Live % Forecast Cycle 4 Forecast Cycle 5 Forecast Cycle 6 Heat Number Tracking PO POSS Load Purchase Order (PDMS) ORACLE Vendor Master Data COPICS Fab Storage COPICS Inventory Data COPICS Product Structure / BOM 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% Mock Data Load Cycle 4 Progress Materials Welding Rod / Company Owned Tools...
View Full Document

This note was uploaded on 08/07/2011 for the course ERP 2000 taught by Professor Giachetti during the Spring '11 term at FIU.

Page1 / 27

data_conversion_tracking_tool - Data Conversion Tracking...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online