Instrument Inventory Management Automation

An excavator manufacturing company based at Kharagpur, WB, is faced with a problem of managing their instruments going in and out of their Instrumentation lab

CHALLENGES

The company is faced with an issue of instrument traceability. Because the entry system is manual, it is time consuming and error prone. Timely calibrations of the instruments is not done as there is no reminder for it. It is virtually impossible to remember the calibration due date for 300 instruments. This is hampering their overall TAT of production.

SOLUTIONS

Barcode based scanner Microsoft Power App based system for instrumentsInventory Management tool
Microsoft Power App based system for instrumentsInventory
Automated remainder emails for calibrations
Dashboard for the management

BENEFITS

Real time visibility of all the instruments

Barcode scanner-based Instrument issuance and receipt process reduced errors, saved time and gave real time visibility of all the instrument.

On-time calibration of instruments

Due to email reminder automation, overall availability of instruments for their use increased as they were calibrated from time to time.

Enhanced accountability

As right process was set for issuance and receipt, It led to greater accountability about right usage of the instrument and its return to the lab.

Incremental impact on TAT for production

On-time availability of instruments significantly reduced the waiting time for instruments across multiple assembly shops.