Test a joint downside across price, volume, and variable cost while labor remains partly committed, then see when the EBITDA target breaks, how much operating rigidity contributes, and which timing or flexibility threshold changes the outcome.
About this interactive
Forecast EBITDA is derived directly from revenue, realized price, variable cost per unit, labor, and fixed operating cost. The entered downside assumptions phase in across the analysis horizon rather than being tested independently. Price and volume interact inside revenue, while volume and variable-cost inflation interact inside variable cost. Labor remains fully committed through the entered response lag; after that point, only the entered flexible share moves with volume. The analysis solves the joint stress multiple that exhausts the EBITDA target, attributes the full reference stress without an arbitrary driver order, compares the current operating response with immediate fully flexible labor, and calculates the labor-commitment and stress-timing thresholds that preserve target. No external forecast-tolerance benchmark is imposed. For more information, visit our Corporate Finance & Strategy practice.
Stress timing
The chart compares cumulative EBITDA under the entered labor commitment with a fully flexible labor comparator. The target line is allocated evenly across the horizon so the first cumulative miss is visible before the full-period result is known.
Reference-stress attribution
Price, volume, and variable-cost inflation are introduced in every possible ordering and each driver’s marginal EBITDA effect is averaged. Volume includes the labor response associated with the entered commitment and lag.
Operating thresholds
These thresholds keep the entered downside intact and solve for the operating response or timing condition that preserves the EBITDA target.
Monthly path
The monthly view shows how the entered stress ramps in, when labor begins responding, and when cumulative EBITDA first falls below the evenly allocated target.
What the forecast depends on
FORECAST FRAGILITY ANALYZER: ILLUSTRATIVE DEFAULT RECORD OPERATING FORECAST Revenue: $48,000,000 Realized price: $120.00 Implied volume: 400,000 units Variable cost per unit: $55.00 Total variable cost: $22,000,000 Labor cost: $12,000,000 Fixed operating cost: $6,000,000 Derived forecast EBITDA: $8,000,000 Target EBITDA: $6,800,000 EBITDA headroom: $1,200,000 REFERENCE DOWNSIDE Full price decline: 1.0% Full volume decline: 2.5% Full variable-cost inflation: 2.0% Full stress realized by: M3 Labor committed share: 80.0% Labor response lag: 2 months Analysis horizon: 6 months REFERENCE STRESS RESULT EBITDA under full entered stress: $6,749,130 Target variance: −$50,870 First cumulative target miss: M5 JOINT STRESS TOLERANCE Current operating response: 0.959x entered stress Break-point price decline: 0.96% Break-point volume decline: 2.40% Break-point variable-cost inflation: 1.92% Fully flexible labor tolerance: 1.156x entered stress SEQUENCE-NEUTRAL EBITDA ATTRIBUTION AT FULL REFERENCE STRESS Price effect: −$395,444 Volume effect including labor response: −$492,935 Variable-cost inflation effect: −$362,491 Total EBITDA movement from reference stress: −$1,250,870 OPERATING COMMITMENT EBITDA under full stress with immediate fully flexible labor: $6,959,130 EBITDA drag from entered labor commitment and response lag: $210,000 Maximum labor committed share that preserves target under full reference stress at the entered lag: 54.6% Additional flexible labor share required versus current setting: 25.4% Earliest full-stress realization month that preserves target: M4 FINDING Derived forecast EBITDA is $8,000,000 against a target of $6,800,000, leaving $1,200,000 of headroom. Under the entered reference downside, EBITDA falls to $6,749,130, a $50,870 miss. The current operating response absorbs 0.959x of the entered joint stress before target is missed. Sequence-neutral attribution assigns $395,444 of EBITDA loss to price, $492,935 to volume including the labor response attached to volume, and $362,491 to variable-cost inflation. The entered labor commitment and response lag reduce stressed EBITDA by $210,000 compared with immediate fully flexible labor. At the current two-month response lag, no more than 54.6% of labor can remain committed if the full reference stress is to preserve target. With the current labor settings, the same full stress becomes absorbable only if full realization is delayed to M4 or later. METHOD STATUS Management-entered assumptions. Forecast EBITDA is derived from revenue less variable cost, labor, and fixed operating cost; it is not a separate input. Revenue equals realized price multiplied by implied volume. The entered price, volume, and variable-cost stress levels phase in linearly from M1 to the entered full-realization month and then remain at full level through the horizon. Monthly stressed revenue multiplies the price and volume effects, so their interaction is retained. Monthly variable cost multiplies the volume effect and variable-cost inflation. Labor remains fully committed through the entered response lag; after that lag, the entered committed share remains fixed while the flexible share moves proportionally with the current month volume effect. Fixed operating cost remains unchanged. Joint stress tolerance scales all three entered downside assumptions together until full-horizon EBITDA equals target EBITDA. Sequence-neutral attribution evaluates every ordering of price, volume, and variable-cost stress and averages each driver’s marginal EBITDA effect, so interaction effects are shared without an arbitrary sequence. The fully flexible comparison sets labor commitment and response lag to zero. The committed-share threshold solves for the largest labor committed share that still preserves target under the full reference stress at the entered lag. The timing threshold reruns the same full stress at each possible realization month and reports the earliest month that preserves target. No external forecast-tolerance, cost-flexibility, or EBITDA benchmark is used.
Continue your analyses, email calculation records, and return to your work from one account.
By creating an account, you agree to the Terms of Use and acknowledge the Privacy Policy.
Enter the 6-digit code sent to .
