BD Consolidator Tool
Aug'21st 2018 - Sep'10th 2018
VWR International LLC
Project Charter
PROBLEM STATEMENT
Consolidate BD monthly reports every year by, formatting and adding them in one desired template . This involves manual copying and pasting data from separate tabs which is time consuming and have quality issues.
OBJECTIVE
Primary Objective:
-
Reducing the manual process and increase the quality
Secondary Objective
-
To save time taken to process from 600 Min to 5 Min by implementing automation.
To develop a procedure for consolidate the data from various monthly files and add them into one excel file
Quality check once the reports are generated.
-
To propose an alternate method that reduces the rework rate
EXPECTED DELIVERABLES
Implementing Automation, will lower the rework and increase quality, through
-
Poka-yoke
-
Without adding additional resources,
-
Decrease time,
-
Lower human fault,
If achieved, BD reports could be produced with greater quality in very short time.
PROJECT SCOPE- IN SCOPE
In Scope:
Quality Management, Customer Service Satisfaction, Use of Automated tool, Time Management, Associates who consolidate BD reports
Out Scope:
Can only be used for consolidating BD Monthly reports
Work Break down Structure
The Tool has been created on Microsoft Excel VBA. It has been incorporated with excel VBA. It needs to run, format and consolidate the data for all the monthly BD reports. The QC mechanism is also incorporated successfully. If this is implemented successfully then the Turn Around Time for the stakeholder can be achieved without any issues on quality.
The Tool has been created and it performs good. The user needs to open the template and click "Start". When the button is clicked the tool runs, opens all BD monthly reports and consolidates them to the one single file based on requirements. The QC status can be checked whether the tool has run the report correctly. If the reports are ran correctly then it marks as "QC Passed" else the tool marks "QC Failed"
-
The official meeting with team members and management was conducted on Aug'21st 2018
-
The Project has Gone live after getting approval with IT on Sep'10th 2018
-
It saves time and increases the quality