Control · C66
Calculate marketing decision thresholds
At which variance should the plan be monitored, corrected or revised?
Direct answer
A useful threshold combines economic materiality, normal variability, persistence and action lead time instead of using a uniform percentage.
01Define green, amber and red zones before observing results.
02The rule, the evidence and the next review date stay visible.
How to use this
Move from the question to the deliverable.
At which variance should the plan be monitored, corrected or revised?
Define green, amber and red zones before observing results.
Material threshold calculation
Calculation · SQ-66
Calculate a threshold from noise, value and delay
A uniform threshold of ±10% ignores normal variability and economic value. The decision zone must be fixed before the results and must include persistence.
Illustrative case: a monthly objective of €420k of pipeline with historical variability of €24k and a contribution margin of 32%.
- 01Measure the noise
Estimate normal variability at comparable scope and season.
- 02Set the materiality
Translate the loss of result into an acceptable economic impact.
- 03Add persistence
Distinguish a one-off variance from a drift across several periods.
- 04Prepare the action
Attach to each zone a decision, an owner and a deadline.
Three steering zones around a €420k target
The amber threshold keeps the greater of two historical standard deviations and the minimum economic materiality.
Amber threshold = max(2 × historical standard deviation; tolerated economic loss ÷ contribution rate)| Zone | Monthly pipeline | Variance | Persistence | Estimated impact | Decision |
|---|---|---|---|---|---|
| Green | ≥ €372k | 0 to −€48k | 1 month | ≤ €15.4k | Monitor |
| Amber | €336k to €371k | −€49k to −€84k | 1 month or 2 low-green months | €15.7k to €26.9k | Correct within 10 d |
| Red | < €336k | < −€84k | Immediate | > €26.9k | Reforecast |
| Persistent red | < €372k | < −€48k | 2 months | > €30.7k cumulative | Escalate |
01Two standard deviations represent €48k: a smaller fall stays compatible with historical noise.
02The tolerated loss of €15k equals €46.9k of pipeline; the statistical threshold, slightly higher, is retained.
03Two months below €372k trigger an escalation even without crossing €336k in a single month.
Fictitious example. The calculation assumes a sufficiently stable historical series and does not replace an analysis of scope breaks.
Coherence controls
Minimum conditions before validation.
The status, the evidence and the owner must be available for review.
The status, the evidence and the owner must be available for review.
The status, the evidence and the owner must be available for review.
The status, the evidence and the owner must be available for review.
Usable deliverable
Material threshold calculation
Explore the decision further with an interactive control, or start from a structured template to produce your deliverable.