formulation-orchestrator

name	formulation-orchestrator
version	1.0.0
description	Orchestrates formulation workflow for Amb Wellness/TDS
author	AI Orchestrator Team
created	2026-02-04T00:00:00.000Z
triggers	["formulate","formulation","create formula","batch selection","select batches","formular","nueva formula","formulacion"]
metadata	{"raven":{"emoji":"🧪","priority":80,"category":"formulation"},"capabilities":["batch_selection","tds_compliance","cost_calculation","optimization","report_generation"]}
dependencies	["formulation_reader","frappe"]

Formulation Orchestrator Skill

Overview

The Formulation Orchestrator is the main coordinator for formulation workflows in the Raven AI Agent system. It manages the complete process from batch selection through report generation.

Architecture

FormulationOrchestratorSkill (main skill)
    ├── BatchSelectorAgent (Phase 2)
    ├── TDSComplianceAgent (Phase 3)
    ├── CostCalculatorAgent (Phase 4)
    ├── OptimizationEngine (Phase 5)
    └── ReportGenerator (Phase 6)

Workflow Phases

Phase 1: Request Analysis

• Parse user query
• Extract item code, quantity, warehouse
• Load TDS requirements

Phase 2: Batch Selection

• Query available batches from Bin doctype
• Apply FEFO sorting (First Expired, First Out)
• Select optimal batches for quantity requirement

Phase 3: TDS Compliance

• Validate selected batches against TDS specifications
• Check COA parameters (supports both COA AMB and COA AMB2)
• Report compliance status

Phase 4: Cost Calculation

• Calculate raw material costs
• Include overhead costs
• Provide cost per unit analysis

Phase 5: Optimization (Conditional)

• Only runs if compliance fails
• Suggests alternative batches
• Optimizes blend ratios

Phase 6: Report Generation

• Generate comprehensive workflow report
• Format for Raven channel
• Provide actionable recommendations

Usage Examples

Natural Language Query

"Formulate 1000kg of ITEM_0617027231"

API Usage

from raven_ai_agent.skills.formulation_orchestrator import FormulationOrchestratorSkill

skill = FormulationOrchestratorSkill()
result = skill.handle(
    query="Select batches for product 0617 in warehouse",
    context={
        "quantity_required": 1000,
        "warehouse": "FG to Sell Warehouse - AMB-W",
        "tds_requirements": {
            "pH": {"min": 3.5, : },
            : {: , : }
        }
    }
)