πŸ“ˆ

Sales Forecasting Dashboard

Global Bookings Forecast Β· All Regions

Current Quarter
βš–οΈ Forecast Weights
Yield %
Pipeline %
Fcst Accuracy %
Productivity %
Total: 100%
⚑ Tops Down
$9.10M
vs $9.5M target
Bookings Target
$
= $9.50M Β· Current quarter goal (editable)
VP Call (Bottoms Up)
$9.45M
β–Ό $50K vs target
VP Call % to Target
β€”
VP Call Γ· Bookings Target
Pipeline Estimate
$8.40M
From stage-weighted pipeline
πŸ“ Rep Submitted
$0
No submissions yet
⚑
Tops Down by Region
πŸ”€
Forecast Method Comparison (Total)
🎯
Regional Attainment vs Target
RegionVP CallTops DownGap to Target
AMER $3,250,000β€”β€”
EMEA $2,700,000β€”β€”
APAC $2,500,000β€”β€”
Japan $1,000,000β€”β€”
Total $9,450,000 β€” β€”
⚠️
Key Considerations
Deal concentration risk β€” Large deals could skew attainment in either direction
Seasonality β€” Historical patterns may affect close rates this quarter
EMEA VP Fcst Adjusted ($3.03M) β€” upside vs VP Call ($2.7M)
APAC historical variance -14.5% β€” watch for downside risk
AMER VP Call
$3.25M
4 ramped + 5 ramping reps
EMEA VP Call
$2.70M
3 ramped + 6 ramping reps
APAC VP Call
$2.50M
2 ramped + 7 ramping reps
Japan VP Call
$1.00M
4 ramped + 1 ramping reps
πŸ“Š
Full Regional Comparison β€” All Forecast Methods
πŸ“‹
Detailed Regional Forecast Table
RegionVP CallYield Est.Productivity Est.VP Fcst Adj.Pipeline Est.πŸ“ Rep Submitted⚑ Tops DownHist. Variance
AMER $3,250,000$2,558,096$3,141,966$2,562,933$1,791,500 β€” β€” -21.1%
EMEA $2,700,000$2,476,578$3,098,233$3,027,449$2,985,000 β€” β€” +12.1%
APAC $2,500,000$2,353,096$2,591,126$2,138,550$2,162,500 β€” β€” -14.5%
Japan $1,000,000$1,511,183$1,699,677$1,000,075$1,460,000 β€” β€” +0.0%
Total $9,450,000$8,898,953 $10,531,002$8,729,007$8,399,000 β€” β€” β€”
Total Pipeline Est.
$8.40M
Weighted by stage conversion
Closed / Won
$875K
Already booked this quarter
Stage 5 (Committed)
$4.48M
42–50% avg conversion
Stages 1–3 (Early)
$14.25M
5–20% avg conversion
πŸ”½
Pipeline by Stage (All Regions)
🌍
Pipeline Estimate by Region
πŸ“‹
Pipeline Detail by Region & Stage
RegionStages 1–3Conv.%Stage 4Conv.%Stage 5Conv.%Closed/WonPipeline Est.
AMER$6,000,0005%$2,500,00020%$325,00042%$225,000$1,791,500
EMEA$3,000,00020%$8,000,00022%$650,00050%$225,000$2,985,000
APAC$4,000,0007%$1,500,00018%$2,250,00025%$100,000$2,162,500
Japan$1,250,00015%$1,800,00020%$1,250,00035%$225,000$1,460,000
Total$14,250,000β€”$13,800,000β€”$4,475,000β€”$775,000$8,399,000
Total Ramped Reps
13
Across all regions
Total Ramping Reps
19
Still building to full quota
Avg Ramped Productivity
86.8%
Across all regions
Avg Ramping Productivity
84.7%
Across all regions
πŸ‘₯
Ramped vs Ramping Reps by Region
⚑
Productivity % by Region
πŸ“‹
Rep Capacity Detail by Region
RegionRampedRampingRamped YieldRamping YieldRamped Prod.Ramping Prod.Yield Est.Productivity Est.
AMER45$272,320$293,76381.1%88.1%$2,558,096$3,141,966
EMEA36$298,234$263,64681.7%85.4%$2,476,578$3,098,233
APAC27$355,725$234,52199.5%80.1%$2,353,096$2,591,126
Japan41$308,405$277,56485.0%85.0%$1,511,183$1,699,677
Total1319β€”β€”β€”β€”$8,898,953$10,531,002
βš–οΈ
Active Forecast Weights β€” adjust using the bar at the top
40%
Yield
Historical rep yield Γ— headcount
40%
Pipeline
Stage-weighted pipeline coverage
15%
Forecast Accuracy
Historical VP call accuracy adjustment
5%
Productivity
Rep productivity Γ— capacity
🎯
Weight Distribution
⚑
Tops Down by Region (Live)
πŸ“Š
Historical Variance by Region
πŸ’‘
How to Read This Model

VP Call / Bottoms Up

Each regional VP submits their own call based on rep-level deals and their gut feel on close probability.

⚑ Tops Down

A live, weighted blend of Yield, Pipeline, Forecast Accuracy, and Productivity estimates β€” combined using the adjustable weights above into a single top-level call.

Historical Yield

Each rep's historical booking per quarter is used to extrapolate expected output based on current team composition.

Pipeline Estimate

Open pipeline is multiplied by stage-specific conversion rates to arrive at expected closed revenue.

Total Deals
0
Across all regions & stages
Total Pipeline
$0
Sum of all deal values
Rep Forecast
$0
Value Γ— confidence %
Manager Forecast
$0
Leader-adjusted call
Account Rep Region Deal Value Stage Close Date Confidence Rep Forecast Manager Forecast Notes Actions
🌍
Deal Forecast Roll-up by Region
Region# DealsTotal PipelineRep ForecastManager Forecast
Reps Submitted
0
Individual forecast submissions
Total Rep Commit
$0
Sum of submitted quarter commits
Itemized Deals
0
Deals attached to submissions
Avg Confidence
0%
Across all submissions
πŸ“
Rep-Submitted Quarter Forecasts
Rep Region Quarter Commit Confidence Itemized Deals Notes Actions
🌍
Rep Commit Roll-up by Region
Region# RepsTotal CommitAvg Confidence
πŸ’‘
How This Feeds the Dashboard

Quarter commits that reps submit here roll up by region and appear as a πŸ“ Rep Submitted figure on the Overview KPIs and in the Detailed Regional Forecast table and Method Comparison chart β€” giving leadership a live, bottoms-up view alongside the VP Call, Tops Down, Yield, and Pipeline estimates.