WspicexMade-up data

Blend planner

The cheapest mix of the lots in stock that still meets the order. Failed lots are never used.

Demo on made-up data. Real results need your lab readings.

1. Pick an order

The spec
2,000 kg · colour at least 120 ASTA · heat up to 600 SHU · moisture under 10%

2. Paprika lots in stock

LotGradeColourHeatMoistureAflatoxinStockCost a kgTested
P-2607SpainA grade166 ASTAtested 168300 SHU8.6%Pass1,600 kgR 74.0018 days ago
P-2611ChinaA grade141.5 ASTAtested 152250 SHU9.1%Pass2,200 kgR 66.00104 days agoRetest
P-2615South AfricaA grade138.1 ASTAtested 1422,800 SHU9.4%Pass1,000 kgR 63.0041 days ago
P-2618South AfricaB grade118.8 ASTAtested 121400 SHU9.8%Pass2,800 kgR 49.0027 days ago
P-2620ZimbabweB grade103.5 ASTAtested 1081,900 SHU10.6%Pass2,000 kgR 43.0063 days ago
P-2622ChinaB grade114.1 ASTAtested 115350 SHU9.0%Fail, held back1,400 kgR 39.0012 days ago
P-2624South AfricaSpent (de-oiled)63.4 ASTAtested 64150 SHU7.4%Pass2,400 kgR 25.0015 days ago
P-2625South AfricaSpent (de-oiled)52 ASTAtested 57900 SHU7.1%Pass1,500 kgR 22.00132 days agoRetest

Colour fades in stock, so today's colour is estimated at 2% a month since the test. Your retests replace the estimate.