Sales Forecasting

Facilitation plan

Begin by naming the four outcomes. For each lesson, model the fictional decision, reveal the method one step at a time, invite an individual attempt, and discuss why the distractors fail. Allow a fresh attempt after feedback. Reserve the final three scenarios for independent practice.

1. Opening and prior knowledge: 5 minutes.
2. Four guided lessons: about 5–7 minutes each, plus discussion.
3. Final check and targeted remediation: 10–15 minutes.
4. Transfer prompt: ask how the method changes with the learner’s industry facts.

Use the text-first study guide as the accessible alternate format. No recorded or live delivery is assumed.

Start with a driver

Outcome: Calculate revenue from a transparent unit assumption.

Demonstrate

A bar line expects 2,000 wholesale units at $8 net and 300 direct units at $16 net. Forecast revenue is $16,000 + $4,800 = $20,800 before returns or discounts.

1. List units by channel and period.
2. Apply the actual net price assumption.
3. Add channels and label uncertainty.

Ask and observe

2,000 wholesale units at $8 and 300 direct units at $16 yield what forecast revenue?

Expected choice: $20,800. 2,000 × $8 = $16,000; 300 × $16 = $4,800; total $20,800.

If missed: Explain the calculation or decision aloud; then present “1,000 units at $10 and 100 units at $20 yield?” Correct choice: $12,000.

Discussion prompt: Separate a target from the model that supports it. Invite a brief verbal explanation. The learner view uses selectable checks and requires no typed submission.

Observe: Can the learner state the decision, identify the relevant facts, and follow the method without cues? A correct guess is not yet evidence of transfer. If a learner misses twice, return to the worked example with new numbers or facts before another attempt.

Forecast a funnel cautiously

Outcome: Use stage evidence without treating every lead as an order.

Demonstrate

Ten similar qualified opportunities worth $2,000 each at an evidence-based 25% win assumption produce an expected planning value of $5,000; this is not $5,000 cash or a guarantee.

1. Define opportunity stage and amount.
2. Use historical conversion where available.
3. Keep expected value separate from booked sales.

Ask and observe

Ten $2,000 opportunities at a 25% planning win rate have what expected value?

Expected choice: $5,000. 10 × $2,000 × 0.25 = $5,000 expected planning value, not a guaranteed order.

If missed: Explain the calculation or decision aloud; then present “Four $1,000 opportunities at a 50% assumption yield expected value?” Correct choice: $2,000.

Discussion prompt: Avoid counting pipeline at full value in the cash plan. Invite a brief verbal explanation. The learner view uses selectable checks and requires no typed submission.

Observe: Can the learner state the decision, identify the relevant facts, and follow the method without cues? A correct guess is not yet evidence of transfer. If a learner misses twice, return to the worked example with new numbers or facts before another attempt.

Separate sales and collection dates

Outcome: Move expected cash into the period it is collected.

Demonstrate

A retailer receives goods in January and is invoiced $20,000 on 60-day terms. The revenue and receivable may be recorded earlier, but the cash plan uses the expected receipt date, subject to payment behavior.

1. Record shipment and invoice dates.
2. Apply contractual and observed payment timing.
3. Place expected cash in the likely collection week.

Ask and observe

A $20k invoice is issued in January and paid in March. When does the cash forecast include the receipt?

Expected choice: March, when collected. The cash forecast records the bank receipt when it arrives, not again at invoicing.

If missed: Explain the calculation or decision aloud; then present “An order is signed Monday but paid next month. When does cash enter?” Correct choice: On actual payment.

Discussion prompt: Pick which period a retailer payment belongs in. Invite a brief verbal explanation. The learner view uses selectable checks and requires no typed submission.

Observe: Can the learner state the decision, identify the relevant facts, and follow the method without cues? A correct guess is not yet evidence of transfer. If a learner misses twice, return to the worked example with new numbers or facts before another attempt.

Build a downside scenario

Outcome: Change one driver and quantify the consequence.

Demonstrate

Base forecast is 2,000 wholesale units at $8. A 25% volume shortfall means 1,500 units and $12,000 wholesale revenue, $4,000 less than base before any cost changes.

1. Choose a plausible driver shock.
2. Recalculate units, revenue, contribution and cash timing.
3. Set a trigger for action if actuals deviate.

Ask and observe

2,000 wholesale units at $8 fall 25%. What is downside wholesale revenue?

Expected choice: $12,000. 1,500 units × $8 = $12,000, compared with $16,000 base.

If missed: Explain the calculation or decision aloud; then present “1,000 units at $10 fall 20%. Downside revenue?” Correct choice: $8,000.

Discussion prompt: Decide when to scale back inventory after orders fall behind plan. Invite a brief verbal explanation. The learner view uses selectable checks and requires no typed submission.

Observe: Can the learner state the decision, identify the relevant facts, and follow the method without cues? A correct guess is not yet evidence of transfer. If a learner misses twice, return to the worked example with new numbers or facts before another attempt.