Team 17 - Coca-Cola Bottlers' Sales & Services (CCBSS) - CCBSS Procurement Optimization

CCBSS Procurement Optimization

Coca-Cola Bottlers’ Sales & Services (CCBSS) is an independent organization that supports North American bottlers by providing services in Human Resources, Information Technology, Finance, and Procurement. Our team collaborated with CCBSS Procurement to identify inefficiencies in purchasing behaviors among partner bottlers and develop scalable solutions. As the primary stakeholder, CCBSS managed procurement processes across dozens of bottlers and print integrators, with long-term plans to expand the application of our solution beyond the project's duration. Bottlers frequently purchased similar printed materials—such as grocery store displays, labels, and promotional advertisements—from various suppliers. We examined procurement data and constructed a Power BI dashboard to visualize inefficiencies by product, substrate, and bottler. To address these inefficiencies, we developed a linear programming model that proposed cost-minimizing reallocation of orders based on timing, sizing, and pricing constraints. Preliminary testing for our OR model in excel solver using historical data suggests that our solution could reduce procurement costs by an estimated 5%. We also implemented a Snowflake SQL solution to automate the model’s functionality at scale—critical for sustainable integration at CCBSS. We validated the models using historical data, with final testing and feedback occurring during an onsite session with the procurement team to confirm accuracy and usability. The project has followed the DMAIC methodology: defining project scope, measuring key metrics, analyzing data through prototypes, improving models with historical testing, and controlling for future use with tools and guidance tailored to real-world data complexity. Our implementation strategy aims to support a smooth handoff and system integration for CCBSS. Overall, the project is expected to reduce overlapping procurement efforts and drive cost savings across bottlers by leveraging CCBSS’s scale and data infrastructure.