A Regional Sales Director checks his region's commit deal by deal before his VP takes the number to the CEO, with any AI chat his company allows.
A VP who's taking his number to the CEO, a confident slide, six deals from the CRM, the forecast policy, and two short notes from reps. The policy and the notes change the number.
Here the AI checks a forecast against your own rules. The prompt lists exactly what to test.
Use the AI tool your company approves: ChatGPT, Claude, Gemini or Copilot.
Copy the prompt and the five fictional inputs from the appendix into one message.
Add the deals that pass, in one currency. Then decide what you'll tell your VP before the call.
I'm a Regional Sales Director at an industrial automation company. My region's fourth-quarter forecast goes to our VP Sales on Monday, December 7, and she's taking the commit number to the CEO. Today is December 2. Below are her email, our draft roll-up slide, the commit deals from our CRM, our forecast policy and notes from two reps.
Please give me:
Check every deal against the policy: stage, close date, quarter and currency. Look for deals counted twice and dates that have already passed. Show your arithmetic. Don't add facts that aren't in the inputs.
Exactly as it came back, not edited. Read it the way Owen did: check each point against the source it cites.
1. Is the commit number solid?
No. The $14.2M is the six amounts added together as listed, so it includes two deals that are not at a commit stage, one deal that closes outside Q4 (and is also in Ana's Q1 number), and two euro amounts counted as if they were dollars. Only three deals meet the policy, for a corrected commit of $6.7M. found
2. Commit deals checked against policy
Policy [4]: commit means a signed PO or verbal award, with a close date on or before December 31, reported in USD at EUR 1 = USD 1.08.
| Deal | Rep | Amount | Stage | Close date | Meets policy? | Why |
|---|---|---|---|---|---|---|
| Ferro Mining line upgrade | Lucas | USD 3.0M | Negotiation | Nov 20 | No | Negotiation is not a signed PO or a verbal award. The Nov 20 close date has already passed (today is Dec 2). Lucas says procurement has been quiet since Nov 12 [5]. found |
| Calder Steel automation | Lucas | USD 2.8M | Proposal | Dec 22 | No | Proposal is not a signed PO or a verbal award. The date is inside Q4, but the stage fails. found |
| Nordhaven Ports retrofit | Ana | EUR 2.5M | Verbal award | Dec 18 | Yes | Stage and date qualify. It has to be converted: EUR 2.5M = USD 2.70M. found |
| Brightwell Foods controls | Mei | USD 2.4M | Signed PO | Dec 4 | Yes | Signed PO, closes inside Q4. |
| Tessin Pharma packaging | Ana | EUR 1.9M | Verbal award | Jan 15 | No | The close date is in Q1, after Q4 ends on Dec 31. Ana has also put it in her Q1 number [5], so it is counted twice. It is also in euros (EUR 1.9M = USD 2.052M). found |
| Kepler Water SCADA | Mei | USD 1.6M | Verbal award | Dec 11 | Yes | Verbal award, closes inside Q4. |
3. Corrected commit number (USD)
How the draft got $14.2M: 3.0 + 2.8 + 2.5 + 2.4 + 1.9 + 1.6 = 14.2. That is every row added as listed, with EUR treated as USD.
Corrected, counting qualifying deals only:
What comes out (14.2 − 6.7 = 7.5 in the draft's mixed units): A: one currency
Check: 14.2 − 3.0 − 2.8 − 1.9 + 0.2 = 6.7.
Two knock-on points for the slide:
4. Deals to question with your reps before Monday
For Priya: the region's commit under policy is USD 6.7M (three deals). Ferro and Calder (USD 5.8M combined) can be shown as best case only if the reps give you a reason to. Tessin belongs in Q1 only. C: tell her today
Claude found every planted problem and showed its arithmetic. Owen fixed one slip in the bridge and decided what his VP should hear, and when.
Use it whenever a number built from many lines goes to someone senior: a forecast, a pipeline, a bookings report.
I'm the [your role] at a [industry] company. [The forecast] goes to [who] on [date], and [how it will be used]. Today is [date]. Below are [the request, the draft, the deal list, our policy and notes from the team].
Please give me: 1. Is the [commit] number solid? Yes or no, in two sentences. 2. A table of the deals: each one, whether it meets our policy, and why. 3. A corrected number in [currency], with the arithmetic shown. 4. The deals I should question before [the meeting].
Check every deal against the policy: stage, close date, quarter and currency. Look for deals counted twice and dates that have already passed. Show your arithmetic. Don't add facts that aren't in the inputs.
Copy the prompt, then all five inputs, into one message in a new chat. Everything here is fictional and safe to paste.
I'm a Regional Sales Director at an industrial automation company. My region's fourth-quarter forecast goes to our VP Sales on Monday, December 7, and she's taking the commit number to the CEO. Today is December 2. Below are her email, our draft roll-up slide, the commit deals from our CRM, our forecast policy and notes from two reps. Please give me: 1. Is the commit number solid? Yes or no, in two sentences. 2. A table of the commit deals: each one, whether it meets our policy, and why. 3. A corrected commit number in US dollars, with the arithmetic shown. 4. The deals I should question with my reps before Monday. Check every deal against the policy: stage, close date, quarter and currency. Look for deals counted twice and dates that have already passed. Show your arithmetic. Don't add facts that aren't in the inputs. [1] Email from Priya Raman, VP Sales Subject: Q4 forecast call, Monday Owen, your region's draft shows a commit of $14.2M. I'm taking the commit number to the CEO, so it needs to be solid. See you Monday. [2] Draft roll-up slide Q4 commit: $14.2M. Up 18% on last quarter's $12.0M. Best case: $19.0M. Pipeline: $31M. [3] Commit deals, from the CRM (amounts in millions) | Deal | Rep | Amount | Currency | Stage | Close date | |---|---|---|---|---|---| | Ferro Mining line upgrade | Lucas | 3.0 | USD | Negotiation | Nov 20 | | Calder Steel automation | Lucas | 2.8 | USD | Proposal | Dec 22 | | Nordhaven Ports retrofit | Ana | 2.5 | EUR | Verbal award | Dec 18 | | Brightwell Foods controls | Mei | 2.4 | USD | Signed PO | Dec 4 | | Tessin Pharma packaging | Ana | 1.9 | EUR | Verbal award | Jan 15 | | Kepler Water SCADA | Mei | 1.6 | USD | Verbal award | Dec 11 | [4] Forecast policy Commit means a signed purchase order or a verbal award, with a close date inside the quarter. Q4 ends December 31. Report in US dollars at the plan rate: EUR 1 = USD 1.08. [5] Notes from two reps Ana: Tessin will probably slip to January. I've also put it in my Q1 number. Lucas: Ferro's procurement team has gone quiet since November 12.I'm a Regional Sales Director at an industrial automation company. My region's fourth-quarter forecast goes to our VP Sales on Monday, December 7, and she's taking the commit number to the CEO. Today is December 2. Below are her email, our draft roll-up slide, the commit deals from our CRM, our forecast policy and notes from two reps.
Please give me:
Check every deal against the policy: stage, close date, quarter and currency. Look for deals counted twice and dates that have already passed. Show your arithmetic. Don't add facts that aren't in the inputs.
Subject: Q4 forecast call, Monday
Owen, your region's draft shows a commit of $14.2M. I'm taking the commit number to the CEO, so it needs to be solid. See you Monday.
Q4 commit: $14.2M. Up 18% on last quarter's $12.0M. Best case: $19.0M. Pipeline: $31M.
| Deal | Rep | Amount | Currency | Stage | Close date |
|---|---|---|---|---|---|
| Ferro Mining line upgrade | Lucas | 3.0 | USD | Negotiation | Nov 20 |
| Calder Steel automation | Lucas | 2.8 | USD | Proposal | Dec 22 |
| Nordhaven Ports retrofit | Ana | 2.5 | EUR | Verbal award | Dec 18 |
| Brightwell Foods controls | Mei | 2.4 | USD | Signed PO | Dec 4 |
| Tessin Pharma packaging | Ana | 1.9 | EUR | Verbal award | Jan 15 |
| Kepler Water SCADA | Mei | 1.6 | USD | Verbal award | Dec 11 |
Commit means a signed purchase order or a verbal award, with a close date inside the quarter. Q4 ends December 31. Report in US dollars at the plan rate: EUR 1 = USD 1.08.
Ana: Tessin will probably slip to January. I've also put it in my Q1 number. Lucas: Ferro's procurement team has gone quiet since November 12.