LE West – Ship Stock Control

Project description

A ship has to leave with a specified medical inventory, and certificates, expiry dates and quantities all have to be right. The old process was a set of spreadsheets that only one person could really follow, which is a fragile way to stay compliant.

We replaced that with one stock system: stock take, certificates, products with expiry, and a re-order that no longer meant rebuilding the workbook. It ran on Visual Basic and Microsoft Office automation, the tools the office already had, so the crew could prove they were legal for the voyage without learning a new platform first.