Vendor Cost
Nov'4th 2016 - Dec'12th 2016
VWR International LLC
Project Charter
PROBLEM STATEMENT
Generate 5 Vendor cost individual reports every month that splits each customer to individual tabs. This involves manual copying and pasting data in 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 240 Min to 5 Min by implementing automation.
-
To develop a procedure for splitting each customer and 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, the Vendor Cost 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, Vendor specific, Time Management, Associates who run Vendor Cost Monthly
Out Scope:
Can only be used for Vendor Cost Monthly reports
Work Break down Structure
The Tool has been created on Microsoft Excel VBA. It has been incorporated with SAP BEx query and it needs the SAP BEx analyzer to pull the data for mentioned Vendor accounts for the user specified time period. The QC mechanism is also incorporated successfully. It can also export data in different sheet tabs based on the requirements. If this is implemented successfully then the Turn Around Time for the customer can be achieved without any issues on quality.
The Tool has been created and it performs good. The user needs to login SAP BEx and open the template into the BEx explorer. Enter the time period in the SAP BEx input screen and click "OK". When the button is clicked the tool runs, the rawdata and splits 20 different excel files for 5 vendor accounts in less than 5 Minutes. The QC status can be checked whether the tool has run the reports 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 Nov4th2016
-
The Project has Gone live after getting approval with IT on Dec'12th 2016
-
It avoids complete manual intervention
-
It saves time and increases the quality