Vaccine Allocation Optimization

Key Technologies: Databricks, DataRobot, Spark, Python, SQL, Linear Programming

The Challenge

Our client, a large retailer working on the front lines of COVID, needed to quickly optimize their logistics for vaccine distribution. The wanted to minimize waste and cost while maximizing vaccinations and staffing efficiency.

The Solution

Adinkra used a linear programming model to solve for all constraints (e.g. shipment quantity, store hours, staffing, etc.). We also developed a demand forecast, allowing us to make daily recommendations under rapidly evolving business requirements.

The Impact

Our model was used to make shipment and staffing model recommendations over 9500 locations on a daily basis. This key automation also supported new use cases, such as Influenza distribution optimization.