Flavor & Fragrance Compounding Form

Section 1: Batch Identification & Metadata

This section establishes the administrative traceability of the batch, linking the formulation to specific project briefs, perfumers, and regulatory timelines.

 

Formulation Name / Code:

Project / Client ID:

Target Application:

Creation Date:

Compounded By:

Batch / Lot Number:

Status:

 

Section 2: Core Compounding Parameters

This section defines the physical scale and chemical base of the fragrance. The inputs here serve as the mathematical foundation for all percentage and concentration formulas in the spreadsheet.

 

Total Target Batch Mass (g):

Desired Concentration (%) [Concentrate-to-Solvent Ratio]:

Calculated Target Concentrate Mass (g):

0

Carrier Solvent Type:

Actual Carrier Solvent Mass Added (g):

Specific Gravity of Finished Batched (g/mL):

 

Section 3: Aroma Chemicals & Olfactive Composition Table

The core formulation matrix. This table handles the raw materials, their olfactive classifications, and the critical math determining odor impact.

Ingredient Code

Chemical / Natural Material Name

Note Category

Odor Threshold

Mass Added (g)

Formula: Blend %

Formula: Concentration (PPM)

Formula: Odor Activity Value (OAV)

A
B
C
D
E
F
G
H
1
 
 
 
 
 
0
0
0
2
 
 
 
 
 
0
0
0
3
 
 
 
 
 
0
0
0
4
 
 
 
 
 
0
0
0
5
 
 
 
 
 
0
0
0
6
 
 
 
 
 
0
0
0
7
 
 
 
 
 
0
0
0
8
 
 
 
 
 
0
0
0
9
 
 
 
 
 
0
0
0
10
 
 
 
 
 
0
0
0
11
TOTALS
 
 
 
0
0
 
 

Section 4: IFRA Regulatory Compliance & Safety Alerts

This section automatically cross-references the formulation data against the International Fragrance Association (IFRA) standards to prevent safety violations before mixing.

 

IFRA Product Category Selection:

Restricted Material Check Tracking Matrix

Material

Current Blend Concentration ((Oakmoss Mass / Total Batch Mass) * 100)

Maximum Allowed Limit for Selected Category

A
B
C
1
 
 
 
2
 
 
 
3
 
 
 
4
 
 
 
5
 
 
 
6
 
 
 
7
 
 
 
8
 
 
 
9
 
 
 
10
 
 
 

IFRA Alert Flag:

IF Current Concentration Allowed Limit: [ PASS: Formulation complies with IFRA Amendment standards. ]

IF Current Concentration > Allowed Limit: [ !! CRITICAL ALERT: OAKMOSS EXCEEDS MAX ALLOWED LIMIT FOR THIS CATEGORY !! ]

 

Section 5: Organoleptic Evaluation & Quality Control Notes

Post-compounding qualitative and physical evaluation to ensure batch-to-batch consistency and trace aging characteristics.

 

Physical Appearance:

 

Initial Olfactive Evaluation (Maceration Day 0):

Top Notes:

Heart Notes:

Dry Down:

 

Aging/Maceration Log (Day 14 Re-Evaluation):

Color Changed Observed:

Description of Color Changed Observed:

Odor Evolution Notes:

Refractive Index (Experimental):

Final Batch Approval Signature:

 

Form Template Insights

Please remove this form template insights section before publishing.

 

Overview of the Flavor & Fragrance Compounding Form

This specialized form serves as an advanced analytical blueprint and quality control mechanism for perfumers, flavorists, and lab technicians. At its core, the document transitions a creative olfactive concept into a precise, scalable, and safe chemical reality. By centralizing raw raw material inputs, mathematical thresholds, and strict international safety regulations into a single data architecture, the form bridges the gap between artistic expression and rigorous chemical engineering.

Key Analytical Insights & Functional Purpose

  • Mathematical Precision in Olfactive Balance: Aroma chemicals vary drastically in their potency; some are perceptible at a few parts per billion, while others require massive dosages to be detected. This form shifts the focus from raw weight (grams) to perceptual impact by tracking the Odor Activity Value (OAV). By evaluating the ratio of an ingredient's active concentration against its established sensory threshold, creators can scientifically predict which materials will dominate the top, heart, or base notes, optimizing the formula for maximum performance and cost efficiency.
  • Proactive Regulatory Risk Mitigation: Compliance in the fragrance industry is highly complex, as safety limits shift dynamically depending on how the final product touches the skin. Instead of relying on post-production audits, this form acts as an active gatekeeper. By cross-referencing restricted materials against the International Fragrance Association (IFRA) standards in real-time, the form automatically alerts the user if a formulation is unsafe for a specific consumer application—such as a leave-on body lotion versus a high-dilution fine fragrance—before a single milligram of raw material is wasted in the lab.
  • Standardization of Physical Scale: The architecture of the form isolates the active concentrate from the carrier medium (such as Ethanol or DPG). This separation allows technicians to manipulate the intensity and application format of the product without altering the core ratios of the aromatic compound. It provides a standardized framework that easily scales a small laboratory trial up to mass-production manufacturing.
  • Traceability and Maceration Analytics: Fragrances are living chemical matrices that evolve over time through chemical reactions like esterification and maturation. The final phase of the form captures this temporal element, establishing a rigorous quality assurance trail. By tracking physical metrics alongside qualitative sensory notes from Day 0 through extended maceration, the form ensures batch-to-batch consistency and serves as a historical troubleshooting log if a formula experiences stability or color issues down the line.

To configure an element, select it on the form.

To add a new question or element, click the Question & Element button in the vertical toolbar on the left.