Whitepaper
Written By: Nikhila Preethee Ravichandran
This technical paper delves into the intricacies of oil blending optimization within the fast-moving consumer goods (FMCG) industry, focusing on the challenges faced by the client in manual oil blending, and the proposed solution leveraging advanced optimization techniques. The study showcases the development of a robust web-based application, incorporating mixed integer linear programming (MILP) to optimize oil selection and blending, focused on enhancing efficiency, consistency, and overall production excellence. The paper also discusses the application interface, lessons learned, key benefits, and outlines future enhancements involving machine learning for predictive analytics.
Recent Blogs
Snowflake Governance: The Missing Piece in Most Enterprise Data Platforms
Most Snowflake environments don’t underperform because of a missing feature. They underperform because the features that are already there — auto-suspend, resource monitors, workload isolation, compute pool policies — were never configured intentionally in the first place.
ProcureMatch360: Why Procurement Teams Are Rethinking How They Review Purchase Requests
It’s Monday morning. A procurement analyst opens her inbox to find 47 new purchase requisitions sitting in the queue. Before she can approve a single one, she needs to pull up the vendor contract and check whether it’s still valid, cross-reference last quarter’s purchases..
Why Lakebase and Unity Catalog Are the Real Heroes Behind Retail IQ
Retail IQ is Systech’s reference implementation of a real-time, governed AI chatbot for e-commerce — built on Databricks Lakebase and Unity Catalog, and delivered through LakeBuild, our accelerator for implementing solutions on Lakebase. It shows how to connect conversational AI to live transactional data without ETL lag, connection contention, or bolt-on security layers.