Optimization Output

Review optimization results and recommended sourcing decisions

Optimized Allocation Plan - Scenario: Q3 Quality-First

Optimized for total sourcing cost, waste reduction, quality compliance, and contract utilization

Feasible - Optimal

Quality Compliance

96.3%

+3.8pp

vs FIFO baseline (92.5% compliance)

Contract Utilization

78%

+11pp

vs FIFO baseline (67% utilization)

Total Sourcing Cost

$2.41M

-8.2%

vs FIFO baseline ($2.62M)

Waste Reduction

12.4%

+4.1pp

vs FIFO baseline (8.3% waste reduction)

Allocation based on SKU quality framework and demand constraints defined in the previous step

Click any SKU block in the timeline to inspect its Blend Composition and Quality Compliance.

Production Plan and Batch Allocation Timeline

Rows = production lines · Columns = weeks · Hover blocks for blend and quality details

PremiumCoreCommodity

Resource

Mon 3 AugW1

3 Aug5 Aug7 Aug

Mon 10 AugW2

10 Aug12 Aug14 Aug

Mon 17 AugW3

17 Aug19 Aug21 Aug

Mon 24 AugW4

24 Aug26 Aug28 Aug

Mon 31 AugW5

31 Aug2 Sep4 Sep

Mon 7 SepW6

7 Sep9 Sep11 Sep

Mixing Vessel 1

Mixing Vessel 2

Refining Line

Conching Line A

Conching Line B

Tempering Line

Molding Line

Packaging Line

Short shelf-life batches scheduled earlier to minimize waste

Premium batches reserved for high-value SKUs

Optimized Batch-to-SKU Allocation

Rows = bean batches · Columns = SKUs · Cell shade = tonnage allocated · ↻ = reallocated vs FIFO baseline

Premium SKUCore SKUCommodity SKU

Bean batch	Vol (t)	Premium Dark Couverture Premium	Premium Single-Origin Bar Premium	Premium Truffle Filling Premium	Core Milk Tablet Core	Core Dark Bar Core	Core Hazelnut Spread Core	Core Cocoa Powder Core	Commodity Coating Commodity	Commodity Compound Commodity	Commodity Bulk Powder Commodity
Cocoa · Ghana B-2401 · Cocoa Grade 1	340	140↻		80		120
Cocoa · Ecuador B-2406 · Cocoa Speciality	300	80	160↻
Cocoa · Ivory Coast B-2402 · Cocoa Grade 2	320				140			180
Cocoa · Brazil B-2409 · Cocoa Substandard	220									140↻	80
Hazelnut · Turkey B-2403 · Hazelnut Grade 1	200						140
Milk Powder · NZ B-2408 · Milk Powder Grade 1	260			60	100		60
Milk Powder · NL B-2404 · Milk Powder Substandard	200								120↻		80
Sugar · Germany B-2405 · Sugar Grade 2	340					100			80	80	80
SKU allocated total		220t	160t	140t	240t	220t	200t	180t	200t	220t	240t

Recommended Actions

Redirect 120 MT Ghana premium beans to Premium Dark Bars

Quality

Lifts Premium SKU compliance from 92% to 96% while keeping fat% within UCL.

Consume short shelf-life batches (B-2404, B-2407) within next 2 weeks

Risk

Sequence into W1-W2 commodity runs to avoid 38 MT of expiry write-off.

Reduce reliance on spot purchases by prioritizing forward contracts

Cost

Shift 14% of Q3 hazelnut volume to contract; locks in $0.18/kg savings.

Assign lower-grade beans to commodity SKUs to minimize cost leakage

Cost

Routes Economy milk powder and Standard cocoa into Commodity Bar lines.

Constraint Feasibility Check

Quality thresholds met (≥95% compliance)

Traceability requirements satisfied

Supplier diversification maintained

Minor shelf-life risk (1 batch)