Formulation Management

Manage and optimize formulations with full ingredient, constraint, and batch traceability.

Overview

Formulation Management in Labii helps teams design, standardize, and control formulations for chemicals, reagents, feed, food, pharmaceutical, and cosmetic products.

The application centralizes ingredient definitions, component composition, formulation constraints, product targets, and production-scale batch execution. This gives R&D, QA, and production teams a shared source of truth for decision-making and audit readiness.

Use Labii Formulation Management to move from trial-and-error spreadsheet workflows to structured, traceable, and repeatable formulation processes.

Design, optimize, and standardize formulations in one platform.

Use Cases

Feed and Food Formulation

• Balance nutrient targets and ingredient limits for consistent product quality.

• Compare candidate formulations by cost, composition, and feasibility.

• Scale validated recipes into production batches with fewer calculation errors.

Pharmaceutical and Chemical Product Development

• Track formulation versions from early R&D to controlled manufacturing.

• Enforce concentration and compatibility constraints before release.

• Preserve complete history for regulatory review and internal quality systems.

Multi-Team Collaboration

• Allow R&D to propose formulas while QA validates specifications.

• Enable production teams to execute approved batches using the same dataset.

• Reduce data duplication between ingredient, inventory, and consumption records.

Getting Started

1

Install the Formulation Management application from Add from a template.

2

Confirm the following core tables are available:

• fn_vendor

• fm_ingredient

• fm_component

• fm_ingredient_component

• fm_formulation

• fm_formulation_constraint

• fm_formulation_product

• core_batch

• core_storage

• core_consumption

• core_container

3

Review table permissions and assign the appropriate team roles for R&D, QA, procurement, and production users.

4

Prepare baseline data for vendors, ingredients, and components before creating your first formulation.

For best results, standardize units (for example %, mg/kg, or g/L) across components and constraints before optimization.

Workflow: Build Ingredient and Component Data

Create a reliable ingredient dataset before defining formulas.

1

Add vendors in the Vendors table (fn_vendor) with supplier details and sourcing notes.

2

Add ingredients in Ingredients (fm_ingredient) with cost, availability, and relevant metadata.

3

Define measurable components in Components (fm_component) such as nutrients, active compounds, or quality indicators.

4

Map each ingredient to its component profile in Ingredient Components (fm_ingredient_component) so formulation calculations use normalized composition values.

Workflow: Create and Optimize a Formulation

Define formulation intent and apply technical or regulatory constraints.

1

Create a new record in Formulations (fm_formulation) and define the target purpose (for example starter mix, pilot lot, or production recipe).

2

Add rule boundaries in Formulation Constraints (fm_formulation_constraint), including minimums, maximums, and quality or safety limits.

3

Add candidate products or outcomes in Formulation Products (fm_formulation_product) to evaluate multiple optimization strategies.

4

Run optimization and review feasibility, composition balance, and cost impact before selecting a formulation for execution.

Apply constraints and optimization rules to reach feasible target formulations.

Workflow: Scale to Batch and Track Consumption

Convert approved formulations into executable production records.

1

Create batch records in Batches (core_batch) from approved formulations.

2

Allocate storage and containers through Storage (core_storage) and Containers (core_container).

3

Record material usage in Consumption (core_consumption) to preserve lot-level traceability and inventory impact.

4

Review final batch output and update formulation records for continuous improvement and future optimization runs.

Scale formulations from R&D to manufacturing with full traceability.

Advanced Features

Constraint-Driven Compliance

Use constraints to encode nutritional, functional, and regulatory limits directly into formulation logic.

If constraints conflict (for example impossible minimum and maximum targets), optimization may fail. Review units and boundary definitions first.

Cost and Scenario Analysis

Compare alternative formulations using ingredient cost, composition targets, and quality tradeoffs to support data-driven decisions.

Versioned Collaboration

Use Labii record history and role-based access to support cross-functional approvals between development, quality, and production teams.

Create a formal approval checkpoint before batch creation to ensure only validated formulations move into production.

Troubleshooting

Issue: Optimization returns no feasible formulation

Symptoms: No valid result appears after running formulation calculations.

Solution:

1

Review all constraint ranges for overlaps or contradictions.

2

Verify ingredient-component mappings and confirm units are consistent.

3

Relax non-critical constraints and rerun optimization to identify the limiting condition.

Issue: Batch totals do not match expected output

Symptoms: Production batch values differ from planned formulation values.

Solution:

1

Check batch scale factor and base formulation quantity.

2

Review container, storage, and consumption records for manual overrides.

3

Confirm the correct formulation version was used for batch generation.

Issue: Team members cannot edit formulation records

Symptoms: Users can view but cannot update ingredients, constraints, or products.

Solution:

1

Verify role permissions for relevant tables in application settings.

2

Check project/team membership and record-level access controls.

3

If signatures or approvals are required, complete the pending approval workflow before editing.