Sourcing Optimization Simulator

View as:
Sigmoid

Allocation Strategy Setup

Set scope and objectives, plan demand-to-quality needs, and configure SKU quality and cost requirements before running the allocation.

Scope filters

Quick Start Templates

Choose one of the templates below to preload sliders, constraints and sourcing mix.

🎛️ Optimization Objectives and Constraints
Objective Trade-offs
Cost OptimizationQuality Compliance
Waste ReductionService Level Adherence
Risk and Compliance Controls
Max QC Failure Probability5%
LowHigh
Shelf-Life Risk Tolerance
Traceability Enforcement

Sourcing strategy and contract mix will be recommended based on optimization outputs.

📦 Demand-to-Quality Planning

Translate SKU demand into required bean quality mix and shelf-life constraints.

SKU Demand Inputs
Name and category are pre-set; edit monthly volumes — the chart below recalculates instantly.
SKUCategoryAugSepOctNovDecJan
Premium Dark CouverturePremium
Premium Single-Origin BarPremium
Premium Truffle FillingPremium
Core Milk TabletCore
Core Dark BarCore
Core Hazelnut SpreadCore
Core Cocoa PowderCore
Commodity CoatingCommodity
Commodity CompoundCommodity
Commodity Bulk PowderCommodity
Monthly tier totals167017231768182418781943
Required Quality Mix overlay: Premium demand → Grade 1 - Fine Flavor & Speciality beans · Core demand → Grade 2 - Commercial · Commodity → Substandard.
Demand Drivers and Scenario Adjustments

No drivers added. Apply a Promo or Seasonal adjustment to model timing-specific demand.

Impact on Quality Requirements
Premium SKU demand
· 0%
Fine Flavor req.
· 0%
Shelf-life pressure
Stable

No demand drivers active - quality requirements follow baseline seasonality.

Required Cocoa Grade Mix
Grade 1 - Fine Flavor378 MT
Grade 2 - Commercial805 MT
Substandard679 MT
Speciality82 MT

Premium SKU demand drives high requirement for Fine Flavor beans.

Required Certification Coverage
RA Certified53%
Organic11%
Conventional36%

RA + Organic coverage scales with premium SKU share.

Freshness Coverage Requirement
≥ 120 days
44%
90-120 days
30%
60-90 days
15%
< 60 days
11%

Aging risk: 26% of demand needs short-window beans - monitor batch turnover.

Fine Flavor Shortage Risk — Quality Demand vs Available Supply
Fine Flavor required: 378 MT · Available: 310 MT · Gap: -68 MT
🧪 SKU Quality and Cost Framework

Define product-level quality specifications and target values per SKU - edit any cell as required.

Bean Quality Thresholds

Fermentation, slaty beans and moisture limits per SKU.

AttributePremium Dark CouverturePremium Single-Origin BarPremium Truffle FillingCore Milk TabletCore Dark BarCore Hazelnut SpreadCore Cocoa PowderCommodity CoatingCommodity CompoundCommodity Bulk Powder
Fermentation
Slaty Beans
Moisture
premium
core
commodity

Compliance, Sensory and Bean Grade

Certification, shelf-life, flavor profile and accepted bean grade per SKU.

AttributePremium Dark CouverturePremium Single-Origin BarPremium Truffle FillingCore Milk TabletCore Dark BarCore Hazelnut SpreadCore Cocoa PowderCommodity CoatingCommodity CompoundCommodity Bulk Powder
Certification
Shelf-Life
Flavor Profile
Bean Grade
premium
core
commodity

Product Performance and Cost

Target values per SKU — Cocoa Butter Yield, Viscosity, Fineness, Flavor, Color and cost sensitivity. Click any value to edit.

AttributePremium Dark CouverturePremium Single-Origin BarPremium Truffle FillingCore Milk TabletCore Dark BarCore Hazelnut SpreadCore Cocoa PowderCommodity CoatingCommodity CompoundCommodity Bulk Powder
Fat Content / Cocoa Butter Yield (%)
Viscosity (Pa.s)
Fineness (μm)
Sensory Flavor Score
Color Index (L*)
Cost Sensitivity
premium
core
commodity

Indicative SKU fit from previous screen is derived from batch attributes; final allocation rules are defined here.

External and Knowledge Inputs

Market data and expert chocolatier rules

Partial
Commodity Price Data
Market price curves for cocoa and key ingredients
Chocolatier Rules Repository
Expert rules on flavour compatibility and usage constraints

Generate optimal batch-to-SKU allocation based on SKU requirements and demand constraints.