Monte Carlo Revenue Prediction

Set the sale parameters below. The model samples real observed UnitPrice values for your chosen Category (10,000 iterations by default) and returns the Revenue distribution: Revenue = Quantity × UnitPrice × (1 − Discount).

🔮 Predict Revenue

1–16 units
100–100,000 (default 10,000)
0.0–1.0
≥ 0 (stored, not in Revenue formula)
Leave blank to skip the probability calculation

📊 Revenue Distribution

p5 (worst-case)
p95 (best-case)
p50 (median)
Mean
Probability of clearing target
(no target set)
Iterations

📜 Prediction History

Most recent rows, newest first
#WhenCategoryQty Disc.ShipTarget p5p50p95 MeanProb ≥ targetIter.
No predictions yet — run one above.