Budget Forecast Builder
Adjust business drivers to model Q3 FY2026 forecast — changes flow through to P&L in real time
Q1 — Revenue Drivers
What are your price and volume assumptions for Q3?
Current actuals: $142 · Budget: $145
Current actuals: 56,690 · Budget: 58,620
Q2 — COGS / Input Cost Levers
What are your expected material and labor costs per unit?
Current actuals: $52.4 · Budget: $47.0
Current actuals: $17.3 · Budget: $16.2
Q3 — Operating Expense Controls
What is your planned fixed and variable OpEx for Q3?
Current actuals: $1,560K · Budget: $1,520K
Current actuals: $1,450K · Budget: $1,460K
Forecast Revenue
$8.73M
Budget: $8.50M
+$232K vs budget
Gross Margin
54.9%
Budget: 56.4%
-1.5pp vs budget
EBITDA
$1.81M
Budget: $1.82M
$4K vs budget
Contrib. Margin
54.9%
Budget: 56.4%
-1.5pp vs budget
P&L Summary — Forecast vs Budget vs Actuals
All values in $K · Q3 FY2026 Forecast
| Line Item | Actuals (Q2) | Budget (Q3) | Forecast (Q3) | vs Budget |
|---|---|---|---|---|
| Revenue | $8,050K | $8,500K | $8,732K | +$232K |
| Cost of Revenue (COGS) | $3,951K | $3,705K | $3,941K | +$236K |
| Gross Profit | $4,099K | $4,795K | $4,791K | $-4K |
| Gross Margin % | 50.9% | 56.4% | 54.9% | -1.5pp |
| Operating Expenses (OpEx) | $3,010K | $2,980K | $2,980K | — |
| EBITDA | $1,089K | $1,815K | $1,811K | $-4K |
| EBITDA Margin % | 13.5% | 21.4% | 20.7% | -0.6pp |
| Contribution Margin % | 50.9% | 56.4% | 54.9% | -1.5pp |
Sensitivity Analysis — Gross Margin %
How changes in unit price (columns) and volume (rows) flow through to gross margin. Green ≥40% · Amber 36–40% · Red <36%
| Volume ↓ / Price → | -15% | -10% | -5% | Base | +5% | +10% | +15% |
|---|---|---|---|---|---|---|---|
| -15% | 46.9% | 49.8% | 52.5% | 54.9% | 57.0% | 59.0% | 60.8% |
| -10% | 46.9% | 49.8% | 52.5% | 54.9% | 57.0% | 59.0% | 60.8% |
| -5% | 46.9% | 49.8% | 52.5% | 54.9% | 57.0% | 59.0% | 60.8% |
| Base | 46.9% | 49.8% | 52.5% | 54.9% | 57.0% | 59.0% | 60.8% |
| +5% | 46.9% | 49.8% | 52.5% | 54.9% | 57.0% | 59.0% | 60.8% |
| +10% | 46.9% | 49.8% | 52.5% | 54.9% | 57.0% | 59.0% | 60.8% |
| +15% | 46.9% | 49.8% | 52.5% | 54.9% | 57.0% | 59.0% | 60.8% |