Case studies

Cencora

Better management of capacity, performance and quality across distribution centers

Every day, Cencora needs to balance workload, workforce capacity, productivity and quality across four distribution centers. Reliable and comparable operational data help turn this complexity into better-informed decisions.

4 distribution centers in 1 application

70,000 operational records per day

Czech Republic

Retail & distribution

46,000 globally

Voice of the customer
Otomar Mach

Otomar Mach

Deputy director of distribution center

Use cases

Employee error rate monitoring

Employee productivity evaluation

Warehouse workforce capacity planning

Technologies used

Qlik Sense

Inphinity Forms

Problem

Cencora, formerly Alliance Healthcare, is one of the leading pharmaceutical wholesalers in the Czech Republic. Operating four distribution centers requires the company to balance expected workload with available workforce capacity every day, while also monitoring productivity and quality.

Workforce capacity planning was originally based on an Excel model developed for one branch. The model helped plan capacity based on expected workload, but it was not suitable for broader use across distribution centers. Data had to be updated manually, and the solution was difficult to scale.

At the same time, warehouse operations generated approximately 70,000 records per day. Evaluating performance, filtering employee data and turning the data into a management view therefore required a significant amount of manual work. Cencora needed a way to bring operational data together, process it automatically and use it to manage capacity, performance and quality across distribution centers.

Solution

EMARK helped Cencora connect operational data from four distribution centers and move planning and performance evaluation into a single centrally managed environment. Data from source systems is processed automatically, providing a unified view of capacity, productivity and performance across individual operations.

Users can plan the required capacity based on expected workload, monitor operational trends and compare performance across distribution centers. The solution also enables users to simulate different workload scenarios and tailor the view to a specific distribution center or user role.

Before

Excel as the main tool for warehouse capacity planning
Manual data updates and operational record handling
Solution designed primarily for one distribution center
Limited sharing and complex warehouse performance evaluation

After

One application for capacity planning and operational reporting
Automatic processing of data from source systems
A unified view of performance across distribution centers
Easy evaluation of performance and error rates

What we delivered

Automatic data loading from source systems
Capacity planning based on warehouse workload volume
Transparent tracking of data interventions and change traceability
Use of historical data and statistical metrics for capacity calculation
What-if analysis for fast simulation of different workforce workload scenarios
Expansion of the solution from one distribution center to all distribution centers
Role-based views for employees, shift leaders, warehouse teams, and management
Better management of capacity, performance and quality across distribution centers, supporting the timely distribution of medicines

By filtering by distribution center, we can quickly see exactly what we need. In one application, we can dynamically change the view depending on which operation we are working with.

Otomar Mach

Otomar Mach

Deputy director of distribution center

More case studies

Let’s talk about your data.

Whether you are working on planning, reporting, or AI, we will recommend the next step that makes sense in the context of your business.

Let’s talk about your data.

Whether you are working on planning, reporting, or AI, we will recommend the next step that makes sense in the context of your business.