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.