Sales Forecast Builder (Bottom-Up, B2B)

Build a bottoms-up B2B sales forecast for my company. Use the following inputs: **Company / Product:** {&{COMPANY_AND_PRODUCT}} **Average Deal Size (ACV):** {&{ACV}} **Average Sales Cycle Length (days):** {&{SALES_CYCLE}} **Current Win Rate (qualified pipeline to closed-won):** {&{WIN_RATE}} **Current Pipeline by Stage:** {&{PIPELINE_BREAKDOWN}} (e.g., Prospecting: $X, Discovery: $X, Proposal: $X, Negotiation: $X) **Current AE Headcount:** {&{AE_COUNT}} **Target AE Headcount by Q4:** {&{TARGET_AE_COUNT}} **Fully Ramped AE Quota:** {&{AE_QUOTA}} --- Deliver the following: **1. Pipeline Stage Conversion Model** Define conversion rates from each stage to the next (use your inputs or benchmarks). Apply probability weights to current pipeline. Show: Stage | Current Pipeline $ | Probability Weight | Weighted Pipeline $ **2. Rep Capacity Model** For each current and planned AE: Start date | Ramp period (months) | First fully productive quarter | Annual quota contribution Show total team quota capacity by quarter for Q1–Q4. **3. 12-Month Revenue Forecast** Show monthly forecast for 12 months broken into 3 buckets: - Commit: high-confidence revenue - Upside: probable but not certain - Best Case: all opportunities converting Present as a table: Month | Commit | Upside | Best Case **4. Pipeline Coverage Requirement** To hit the commit number each quarter, how much total qualified pipeline is required? State the pipeline coverage ratio and what actions generate it. **5. Forecast Variance Analysis** Show the impact on annual revenue if: - Win rate drops from current to [current - 10%] - Average sales cycle extends by 20% - 1 AE hire is delayed by one quarter **6. Sales Forecast Health Check** Is this forecast achievable? Rate it: Conservative / On Track / Aggressive. What is the single biggest risk to the commit number?