Book a call

Excel-based SAP reporting

Improving international beverage supply chains

We delivered optimised supply chain management and unlocked efficiencies with Excel-based SAP reporting.

Distribution optimisation

We developed an optimisation algorithm with a university-based computer scientist, then replicated it using VBA in Excel to complement the client’s existing SAP software.

Logistical efficiency

The tool enabled the client to maximise order fulfilment between different warehouses while minimising stock movements and reducing wastage.

Rapid turnaround

The client had estimated it would take around 18 months to make the necessary changes in SAP. We delivered a solution that could operate using SAP exports in Excel within just a few weeks.

The brief

One of the world’s leading soft drinks manufacturers urgently needed to increase the number of delivery vehicles it could process while ensuring optimal stock distribution between automated and traditional systems.

The client required a tool to process data exports from their SAP system, allocate orders for dispatch from each warehouse, and specify stock movements to facilitate dispatch.

The result

Our Excel-based tool transformed the client’s SAP export data, increasing warehouse throughput from 180 to 250 vehicles, optimising staffing, and ensuring the automated facility ran at peak efficiency.

Smarter BBE and batch tracking reduced wastage by always shipping the oldest stock first. Delivered in a fraction of the time of traditional SAP development.

Ready to join the dots?

Let's talk about your business challenges.

Book a call