FP&A Modeling / Synthetic workbench
Decompose the variance.
Model the recovery.
Inspect an exact additive Price-Volume-Mix (PVM) and Unit Cost margin bridge across three commercial channels, then stress-test FY2027 rolling forecast scenarios.
All channels, unit counts, prices, and forecast scenarios are prepared synthetic fixtures. Controls switch between example summaries rather than running the Python model; forecasts use fixed seasonal factors and simplified assumptions. Figures are generated from the case study's pinned source revision; bridge values are rounded to whole dollars.
Additive PVM bridge & scenario planner
Inspect gross margin drivers.
Zero unexplained plug
Vol + Mix + Price + Cost = ΔGM
Consolidated Portfolio (All 3 Channels): -$104,950 GM variance (5655 bps (56.55%) → 5338 bps (53.38%) [-317 bps]).
Unit growth adds margin, but the mix shift, lower prices, and higher unit costs leave total gross margin below budget.
- Budget vs. Actual units
- 7,600 budget → 8,300 (+9.2%) actual
- Budget vs. Actual Gross Margin ($)
- $8,708,000 budget → $8,603,050 actual (-$104,950)
- Pure Volume + Portfolio Mix effects
- +$802,053 Volume · -$421,253 Mix
- Price Realization + Unit Cost effects
- -$162,900 Price · -$322,850 Unit Cost
- Gross Margin rate (bps)
- 5655 bps (56.55%) → 5338 bps (53.38%) [-317 bps]
- Selected FY2027 scenario projection
- $36.06M GM on $67.75M revenue (5323 bps (53.23%)) · 34,556 units — Baseline
| Channel | Budget GM | Actual GM | Volume | Mix | Price | Cost | Net ΔGM |
|---|---|---|---|---|---|---|---|
| Consolidated Portfolio (All 3 Channels) | $8,708,000 | $8,603,050 | +$802,053 | -$421,253 | -$162,900 | -$322,850 | -$104,950 |
| Enterprise Diagnostic SaaS | $3,420,000 | $3,252,300 | +$126,640 | -$383,140 | +$133,200 | -$44,400 | -$167,700 |
| Academic & Health System Licensing | $3,408,000 | $3,524,200 | +$253,280 | +$144,320 | -$160,800 | -$120,600 | +$116,200 |
| Wholesale Partner Channel | $1,880,000 | $1,826,550 | +$422,133 | -$182,433 | -$135,300 | -$157,850 | -$53,450 |
Volume allocates the portfolio’s total unit change using budget channel mix and budget unit margins. Mix then captures each channel’s departure from that allocation, so a channel can have a positive Volume effect even when its own units fall.
pure volume lift
channel mix drag
net price & cost headwind
FY27 projected GM