Operations & Business Development Intern - YCH Logistics India
Improving inventory accuracy and facility throughput by replacing manual stock verification with an RFID scanning workflow, and giving regional leadership clearer visibility into where the supply chain was slowing down.
Problem
- Inbound and outbound inventory was verified manually, leaving room for mismatches between what was recorded and what physically moved through the facility.
- Tracking discrepancies meant time spent reconciling stock instead of moving it, holding back facility throughput.
- Operational data sat across spreadsheets, making it hard to see where supply-chain bottlenecks actually were.
Key Insights
- Studied the inbound and outbound verification process to understand where discrepancies were entering the system.
- Analyzed operational data to identify recurring bottlenecks across the supply-chain workflow.
- Identified the verification step itself as the lever: a faster, scan-based check could improve accuracy and speed at the same time.
Solution
- Built a VBA-based RFID scanning macro for inbound and outbound verification, replacing manual checks with scan-based validation.
- Developed Power BI and Excel reporting pipelines to surface supply-chain bottlenecks.
- Turned the analysis into workflow-simplification proposals for regional executive leadership.
Implementation Process
- Mapped the existing verification workflow first, so the tool fit how the operations team already worked.
- Built on Excel and VBA - tools already in daily use - to keep adoption friction low.
- Brought the RFID macro into inbound and outbound verification and tracked discrepancies and throughput against the earlier manual process.
- Built reporting in Power BI and Excel, then presented findings and proposals to regional leadership.
Handling Challenges
-
Building on Familiar Tools
- Chose Excel/VBA and Power BI so the solution fit the team's existing stack rather than requiring new software or retraining.
-
Accuracy Without Slowing the Floor
- Verification needed to become more reliable without adding steps. Scan-based validation made the check both faster and more accurate.
-
Making Data Actionable for Leadership
- Raw operational data doesn't drive decisions on its own. Framed the bottleneck analysis as concrete workflow-simplification proposals.
Results
- Cut inventory tracking errors by 90% with the VBA RFID scan macro.
- Lifted warehouse throughput by about 20% by mapping the end-to-end workflow and presenting process recommendations to senior leadership.
- Presented workflow-simplification proposals, backed by bottleneck analysis, to regional executive leadership.