Optimization & Constraints

Optimization

Used by Amazon, UPS, and Fortune 500 companies. Advanced algorithms deliver optimal solutions in minutes. Other platforms charge $15K-50K/year for Gurobi—we include it free.

Two-Step Optimization

You decide what to optimize for and when the fallback triggers. The solver handles the complex math.

STEP 1

Primary Optimization

You choose the objective:

• Minimize cost
• Maximize service
• Minimize distance
• Maximize capacity

→

Trigger

Set threshold
(e.g., demand < 100%)

→

STEP 2

Fallback (If Needed)

Maximizes what's possible:

• Service level %
• Best achievable demand
• Optimal given constraints

Example: Cost → Demand Fallback

Step 1: Minimize Cost

Target: 100% fulfillment

→

Result: 87%

Trigger activated

→

Step 2: Maximize Demand %

Best achievable given constraints

→

Final: 92%

Optimal result

Constraints

Real-world business rules—configured through Excel

Add constraints as columns in your Excel files. Use all, some, or none—Gurobi solves in minutes regardless.

Lane-Level

Min/max volumes • Allowed/forbidden routes • Carrier-specific lanes

Facility

Min/max capacity • Fixed vs flexible sites • Throughput/type limits

Service Level

1-day/2-day zones • Service level % • Max distance/transit time

Supply Chain Path %

Regional sourcing % • Max flow to single facility • Product routing rules

Product/SKU

Temperature/hazmat • Facility compatibility • Routing restrictions

Budget & Cost

Capex/opex limits • Investment phasing • ROI/payback hurdles

Greenfield + Brownfield Flexibility

Mark existing facilities as "fixed=TRUE" (brownfield)—solver uses as-is. Mark potential sites as "fixed=FALSE" (greenfield)—solver decides which to open. Example: Keep 3 Midwest DCs (fixed) + select 2 from 10 coastal candidates (flexible)