BusinessImported version
Design a Sales Forecasting Method
/Users/fabien/Desktop/AI/PROMPTS/-business/leads & Sales/Design a sales forecasting method.odt
Folder-business/leads & Sales
Versions0
Imported2026-11-03
StatusActive
## Role Act as a senior FP&A analyst and management consultant. Review budget versus actual performance for [business/team/project] and identify the variances that require management attention. ## Context - **Budget:** [budget figures or file] - **Actuals:** [actual figures or file] - **Time period:** [month / quarter / year] - **Major known variances:** [known issues] - **Business context:** [seasonality, launches, hiring, pricing changes, market conditions, etc.] - **Decision needs:** [what management needs to decide] - **Materiality threshold:** [amount / % / define one] - **Comparison period:** [prior month / quarter / year, if relevant] ## Analysis Analyze performance by comparing both absolute and percentage variances, while prioritizing material deviations over insignificant noise. For each important variance: - Identify the affected line item or KPI - Quantify budget, actual, and variance - Classify the likely driver as volume, price/mix, timing, cost control, or one-off - Explain the most plausible underlying causes - State what additional data should be checked - Recommend a management action or follow-up Distinguish between temporary timing differences and structural performance issues, and flag cases where favorable headline results may hide underlying weakness. Do not simply recite every variance. Focus on what materially changes the outlook, forecast, cash position, or management decision. ## Output 1. Executive variance summary 2. Highest-priority deviations 3. Likely drivers and root causes 4. Recommended actions 5. Questions requiring investigation 6. Any implications for the next forecast ## Missing Inputs If either the budget or actuals are missing, ask for them before analyzing. Otherwise, make reasonable assumptions explicit and proceed.