Addressing the Recipe Formulation Bottleneck
Process manufacturing leaders—such as production managers and operations directors in the food and beverage sector—often face a strict bottleneck when formulating daily production recipes. When managing hundreds of inventory items and coordinating dozens of daily production runs, relying on manual spreadsheet calculations makes it difficult to consistently optimize for both raw material costs and precise customer specifications.
A Real-World AI Integration
Replacing manual spreadsheets with intelligent, data-driven systems can streamline these daily calculations. A November 13, 2026 report demonstrates this shift at JULIAN SOLER, a Spanish grape ingredient producer. According to ERP News, the company adopted an AI platform within its Abas ERP to calculate and rank recipes for 30 to 40 daily production runs. By drawing on production, laboratory, and quality data, the tool calculates viable combinations of raw materials. It then ranks these formulations based on cost-efficiency and how closely they match customer requirements for characteristics like pH, acidity, color, and concentration.
Implementation Prerequisites for AI Ranking
For operations teams looking to evaluate similar AI capabilities for their own workflows, the foundational requirement is centralized, high-quality data. Before any algorithm can effectively rank formulas, a manufacturer must establish digitized tracking from raw material intake through final laboratory testing.
Key prerequisites for evaluating AI recipe optimization include:
- Unified Data Systems: Ensure laboratory test results automatically sync with active inventory and production records.
- Digitized Customer Specifications: Maintain exact acceptable tolerance ranges for final product characteristics directly within the enterprise software.
- Real-Time Costing: Track accurate raw material costs to enable the system to rank viable blends by profitability.
Next Steps for Workflow Automation
Assessing whether your current infrastructure can support this level of intelligence is a critical step toward modernization. Through tailored AI and data intelligence strategies, organizations can map their existing laboratory and production data to identify gaps that prevent automated recipe calculation. While the published case study highlights a specific vendor's deployment, similar data consolidation and workflow automation principles can be engineered into other scalable enterprise systems.
If you are evaluating how to replace manual batch calculations with integrated production data, our team can help review your current systems. Reach out to discuss your process manufacturing requirements with Decision Intelligent.