We provided a system for managers to have a clear picture of where each stock item is at any point in time when taken out by engineers or loaned to customers.
U.S.-based Pratt & Whitney is an aerospace manufacturer with a global service. It owns a large collection of tools used by engineers for the repairing and servicing of engines. In addition to this the tools are lent to customers undertaking their own repairs. The company wanted a database to keep track of which tools were on loan. This would also assess overall stock position in the warehouse.
An old and basic Access 97 database was being used to try and keep track of tools but it was proving inaccurate and difficult to manage.
We used the old database as a basis for a new loan management system that made it easy to see what items were on loan, when they were due back, and also any overdue items.
The team managing engine tools now has a clear idea of where each tool is and can also maintain an accurate stock count of items in the warehouse.