CSM Sales Forecasting & Budgeting 2 — Questions and Answers
Question 1: Which forecasting approach collects individual sales rep estimates and aggregates them into an overall company forecast?
- Top-down forecasting
- Market-share forecasting
- Bottom-up forecasting (Correct answer)
- Regression-based forecasting
Correct answer: Bottom-up forecasting
Bottom-up forecasting compiles each rep's deal-level or territory-level estimates and rolls them up into a total organizational forecast.
Question 2: Opportunity-based forecasting differs from time-series forecasting primarily because it:
- Uses stock market trends as a proxy for demand
- Relies on current pipeline deals rather than historical data (Correct answer)
- Is only applicable to subscription-based businesses
- Requires input from finance rather than sales managers
Correct answer: Relies on current pipeline deals rather than historical data
Opportunity-based forecasting uses the real-time status and value of deals currently in the pipeline, making it more responsive to present conditions than historical trend analysis.
Question 3: In sales budgeting, a variance analysis is conducted to:
- Identify differences between budgeted and actual performance figures (Correct answer)
- Rank sales reps from highest to lowest quota attainment
- Calculate the return on investment for a marketing campaign
- Determine which territories have the highest growth potential
Correct answer: Identify differences between budgeted and actual performance figures
Variance analysis compares budgeted figures to actual results to identify gaps, understand root causes, and inform corrective actions.
Question 4: In the context of sales budget planning, ROI (Return on Investment) is used to:
- Set compensation caps for sales managers
- Evaluate whether a sales initiative generates sufficient revenue relative to its cost (Correct answer)
- Determine the geographic size of a sales territory
- Schedule performance review cycles
Correct answer: Evaluate whether a sales initiative generates sufficient revenue relative to its cost
ROI measures the financial return generated by a sales investment, helping managers justify spending and prioritize budget allocations.
Question 5: Weighted pipeline forecasting assigns a probability percentage to each deal based on:
- The rep's historical close rate regardless of deal specifics
- The deal's current stage in the sales process (Correct answer)
- The prospect's industry sector
- The size of the sales territory
Correct answer: The deal's current stage in the sales process
Each stage in the sales process is assigned a close probability, and the deal value is multiplied by that percentage to produce a weighted forecast contribution.
Question 6: A rolling forecast differs from a static annual forecast primarily because it:
- Is prepared by external auditors rather than the sales team
- Is updated continuously on a set cadence, always projecting the same number of periods forward (Correct answer)
- Only covers the current quarter and discards prior data
- Requires board approval before it can be revised
Correct answer: Is updated continuously on a set cadence, always projecting the same number of periods forward
A rolling forecast is refreshed regularly (e.g., monthly) and always looks a fixed horizon ahead, providing more current and flexible projections than a static annual plan.
Question 7: A sales quota relates to the sales budget by serving as:
- The maximum expense a rep is permitted to incur
- The individual or team revenue target that, when aggregated, should meet or exceed the budgeted revenue goal (Correct answer)
- A legal contract between the rep and the company
- The minimum number of calls required each week
Correct answer: The individual or team revenue target that, when aggregated, should meet or exceed the budgeted revenue goal
Quotas translate the overall budgeted revenue target into individual and team-level goals, ensuring that collective attainment covers the budget.
Which forecasting approach collects individual sales rep estimates and aggregates them into an overall company forecast?