Capacity planning for pharmaceutical manufacturer

Client

Leading global pharmaceutical company that discovers, develops, and distributes a wide range of medicines, vaccines, and innovative healthcare products.

OPPORTUNITY

The client wanted to transform the capacity management process across manufacturing sites, warehouses and distribution centers. The client was using legacy systems which made the process less fluid and difficult to optimize.

SOLUTION

SG Analytics' data scientists developed a framework for effective capacity planning using the following approach:

At the outset, SG Analytics' team reviewed the existing system. It observed that data was maintained in various inconsistent formats and there were data entry errors. The data was stored in row-based storage due to which scenario management and optimization was not possible.
The team built an application interface that placed the data in a Linux environment and triggered the shell script for automating the data quality checks and standardizing the data hierarchy across locations.
We built a Qlikview based solution to enable scenario planning and management.
SG Analytics implemented Spark Graph X which could store data by nodes, followed by optimization based on distance and number of nodes/locations.