Robot cells, PLC and SCADA controls and line integration for food, packaging and manufacturing plants. 46 staff. Forecast of orders won for 1 Nov 2026 to 31 Jan 2027 (3 months).
Verdict: For 1 Nov 2026 to 31 Jan 2027 (3 months) the orders-won target is £1,400,000. Your salespeople have committed £1,517,500 (worth £587,558 at your own win rates), £672,000 of it on 5 deals already past the close date; past commits ran 29% above what was won, so adjusted that’s £1,173,004. From your own win rates the honest expected is £1,241,017 (£1,043,528 from open deals, £197,489 from new enquiries), likely between £918,963 and £1,563,071 (about a 2 in 3 chance). The target sits inside the range: it could go either way. At the expected, the gap is £158,983 (£54,054 of gross profit): about 2 more deals at your average. Possibly: 24 extra enquiries a month from now, on top of your 30. Act now on the deals already open: get the stale ones decided, and see which deals due after the window could honestly come forward. 7 deals worth £757,000 are past their close date: re-date them with the buyer or close them as lost.
The dashed line is the target. The honest expected counts every open deal at Brackenholt’s own win rate for its stage, cut for deals that are stale or may slip, plus £197,489 from new enquiries that, at the pace Brackenholt’s deals are really won, can close by 31 January. Taking the usual 29% optimism out of the commit gives £1,173,004. The whisker is one standard deviation either way (£322,054), combining the uncertainty of the deals themselves (£305,206) with how far forecasts here usually miss once their optimism is removed: about a 2 in 3 chance the window lands inside it. A few big deals make the range wide.
| Step | £ | Why |
|---|---|---|
| Open deals in the window, at their value | £3,095,500 | |
| At each stage's own win rate | £1,520,781 | £1,574,719 less: most deals at each stage are lost |
| Less: stale deals counted down | −£288,495 | past their close date, due just before the window, unusually old, or no real contact |
| Less: won deals slipping past the window | −£188,758 | the assumed 80% on time |
| Plus: new enquiries that can still land | £197,489 | by how fast Brackenholt’s deals are really won |
| Honest expected | £1,241,017 | the five biggest deals make up 36% of it |
The Deals sheet totals within 0% of the CRM’s own pipeline report, so nothing material is missing. As a cross-check, the honest expected is 1.12× the orders won in the same months last year.
| Flag | Deals | Value in the window | Expected at own rates | Expected ÷ value |
|---|---|---|---|---|
| Commit | 15 | £1,517,500 | £587,558 | 39% |
| Best case | 10 | £1,097,000 | £328,559 | 30% |
| Pipeline | 8 | £443,000 | £110,881 | 25% |
| Salesperson | Open deals | Committed | Honest expected, all their deals | Commit ÷ expected |
|---|---|---|---|---|
| Sales director | 6 | £481,000 | £393,595 | 1.2× |
| Account manager North | 11 | £577,000 | £271,868 | 2.1× |
| Account manager Midlands | 11 | £377,000 | £262,512 | 1.4× |
| Internal sales | 10 | £82,500 | £115,553 | 0.7× |
A Commit flag here means what the business’s own history says: deals flagged Commit are expected to bring 39% of their value, against 30% for Best case. 2 committed deals worth £240,000 sit at Proposal sent, a stage Brackenholt wins less than half the time. The salespeople’s table needs no forecast history: it compares each person’s commit with what all their deals are expected to bring. Account manager North has committed more than twice that, so start the conversation there.
Committed at the start of the month Orders actually won · the figure above each pair is how far the commit was over.
Orders won averaged £394,222 a month against a target of £466,667 a month for the window. Unless more deals are won, faster or bigger, the next window will fall short too.
| Stage | Won of reached | Win rate used | Open deals | Their value | Expected in the window |
|---|---|---|---|---|---|
| Enquiry qualified Your records · won deals usually here by day 25 | 96 of 380 | 25% | 5 | £267,000 | £38,602 |
| Site survey done Your records · won deals usually here by day 45 | 90 of 260 | 35% | 6 | £668,000 | £93,288 |
| Proposal sent Your records · won deals usually here by day 70 | 84 of 215 | 39% | 12 | £1,066,000 | £230,433 |
| Technical sign-off Your records · won deals usually here by day 85 | 70 of 128 | 55% | 6 | £611,000 | £243,195 |
| Negotiating Your records · won deals usually here by day 95 | 62 of 96 | 65% | 6 | £860,000 | £389,115 |
| Verbal order Blended: 16 of your deals + 4 at the assumed rate · won deals usually here by day 100 | 14 of 16 | 87% | 3 | £84,500 | £48,894 |
Win rates rise stage by stage, as they should. Only 16 closed deals reached Verbal order, so its rate is topped up to 20 deals at an assumed 85%. Pipeline coverage looks healthy at 2.2×, but at these win rates the deals in the window need 3.0× to deliver what they are expected to: a coverage rule of thumb would mislead here.
| Deal | Flags | Value | Win chance in the window | Expected |
|---|---|---|---|---|
| Thornhaugh Dairies: case packer and palletiser cell Sales director · Negotiating · close 30 Sep 2026 | Past close date Commit | £285,000 | 32% | £92,031 |
| Hartsop Brewery: keg line PLC replacement Account manager North · Technical sign-off · close 28 Aug 2026 | Past close date Commit | £118,000 | 27% | £32,266 |
| Brendon Castings: fettling robot Account manager North · Site survey done · close 08 Jan 2027 | No contact Best case | £155,000 | 17% | £26,827 |
| Shapwick Polymers: extrusion line controls Sales director · Proposal sent · close 18 Dec 2026 | 2.2× usual age Best case | £134,000 | 20% | £26,177 |
| Salcott Seafoods: washdown robot picker Account manager North · Proposal sent · close 02 Oct 2026 | Past close date Commit | £128,000 | 20% | £25,005 |
| Grisedale Mills: bagging line robot Account manager North · Proposal sent · close 31 Jul 2026 | Past close date Commit | £112,000 | 20% | £21,879 |
| Ullswick Foods: end-of-line labelling Internal sales · Verbal order · close 30 Oct 2026 | Due just before the window Commit | £38,000 | 44% | £16,530 |
| Elmstead Joinery: CNC loading cell Account manager Midlands · Proposal sent · close 09 Dec 2026 | No contact Best case | £67,000 | 20% | £13,088 |
| Abbotsley Feeds: bulk intake controls Internal sales · Proposal sent · close 25 Sep 2026 | Past close date Best case | £61,000 | 20% | £11,916 |
| Inglesham Timber: stacker controls Account manager Midlands · Proposal sent · close 30 Nov 2026 | 4.6× usual age Best case | £52,000 | 20% | £10,158 |
| Rockbeare Foods: X-ray reject integration Internal sales · Technical sign-off · close 09 Oct 2026 | Past close date Commit | £29,000 | 27% | £7,930 |
| Draycote Packaging: shrink-wrap retrofit Internal sales · Proposal sent · close 15 Sep 2026 | Past close date Best case | £24,000 | 20% | £4,688 |
| Frampley Auto Trim: assembly line PLC and HMI Sales director · Negotiating · close 15 Jan 2027 | Best case | £240,000 | 52% | £124,000 |
| Quenby Confectionery: pick-and-place robots Sales director · Technical sign-off · close 22 Jan 2027 | Commit | £196,000 | 44% | £85,750 |
| Ashwell Pet Foods: bag palletiser Account manager Midlands · Negotiating · close 04 Dec 2026 | Commit | £165,000 | 52% | £85,250 |
| Corringham Pharma: serialisation upgrade Sales director · Proposal sent · close 29 Jan 2027 | Best case | £210,000 | 31% | £65,637 |
| Wexcombe Plastics: robot unload for four moulders Account manager North · Technical sign-off · close 20 Nov 2026 | Commit | £148,000 | 44% | £64,750 |
| Tolland Engineering: cobot machine tending, two cells Account manager Midlands · Technical sign-off · close 11 Dec 2026 | Commit | £86,000 | 44% | £37,625 |
| Penlow Metals: welding cell guarding and controls Account manager North · Site survey done · close 20 Jan 2027 | Pipeline | £135,000 | 28% | £37,385 |
| Kelmarsh Components: vision inspection, three stations Account manager Midlands · Negotiating · close 10 Nov 2026 | Commit | £72,000 | 52% | £37,200 |
| Ravensholt Bakeries: line SCADA upgrade Account manager Midlands · Proposal sent · close 15 Dec 2026 | Best case | £96,000 | 31% | £30,006 |
| Wendling Salt: packing line PLC Account manager Midlands · Negotiating · close 17 Nov 2026 | Commit | £54,000 | 52% | £27,900 |
| Bodenham Labels: print-and-apply automation Account manager North · Negotiating · close 16 Dec 2026 | Commit | £44,000 | 52% | £22,733 |
| Lydcombe Beverages: palletiser safety upgrade Account manager North · Verbal order · close 13 Nov 2026 | Commit | £27,000 | 70% | £18,792 |
| Marlstead Tyres: bead handling automation Account manager North · Enquiry qualified · close 30 Jan 2027 | Pipeline | £88,000 | 20% | £17,785 |
| Mereworth Logistics: conveyor controls Internal sales · Site survey done · close 27 Nov 2026 | Best case | £58,000 | 28% | £16,062 |
| Nettlecombe Bottling: line efficiency monitoring Internal sales · Technical sign-off · close 24 Nov 2026 | Commit | £34,000 | 44% | £14,875 |
| Halstock Chilled: checkweigher integration Internal sales · Verbal order · close 03 Nov 2026 | Commit | £19,500 | 70% | £13,572 |
| Pilsdon Dairy: CIP control upgrade Internal sales · Site survey done · close 02 Dec 2026 | Pipeline | £47,000 | 28% | £13,015 |
| Hexworthy Fabrications: press brake cobot Account manager Midlands · Proposal sent · close 12 Jan 2027 | Pipeline | £39,000 | 31% | £12,190 |
| Quarrendon Cider: depalletiser controls Internal sales · Proposal sent · close 06 Nov 2026 | Pipeline | £31,000 | 31% | £9,689 |
| Ludford Glass: robot handling trial cell Account manager Midlands · Enquiry qualified · close 18 Dec 2026 | Pipeline | £45,000 | 20% | £9,095 |
| Yarcombe Nuts: robot case packing Internal sales · Enquiry qualified · close 28 Nov 2026 | Pipeline | £36,000 | 20% | £7,276 |
| Wraxall Paper: reel handling AGV study Account manager North · Enquiry qualified · close 31 Dec 2026 | Pipeline | £22,000 | 20% | £4,446 |
Win chance = the stage’s rate × 50% for a stale deal (past its close date, due in the 30 days before the window, older than twice the usual age at its stage, or no real contact with the buyer for over 30 days), or × 80% for the chance a deal that will be won lands inside the window. Both are assumptions until Brackenholt measures how often its overdue deals were won. Five Commit deals worth £672,000 are already overdue: they need new dates from the buyers, not a place in the commit. Ullswick Foods, due 30 October, is counted as slipping in at the stale rate; if it closes on time it belongs to October.
Win chances come from 18 months of closed deals in your own records, stage by stage; 1 stage(s) with fewer than 20 closed deals are topped up with an assumed rate. Deals past their close date, due in the 30 days before the window, older than twice the usual age at their stage, or with no real contact for over 30 days count at 50% of their stage’s rate, and the rest at 80% of it for deals that are won but slip past the window (both assumed until your records replace them). New enquiries count by how fast your won deals were won (within 30, 60 and 90 days), at your average deal value. The range is one standard deviation, from the deals’ own uncertainty and 9 months of past commits against what was won. These are orders won, not turnover or cash. Gross profit uses the average margin of 34%.
These are orders won, not turnover or cash: an automation project is invoiced in stage payments and earned over months, so the cash from November’s orders arrives well into 2027. December’s holiday shutdowns, Brackenholt’s and its customers’, cut the selling days in the window. Re-run this monthly and record each month’s commit so the history keeps building.
Brackenholt chose the guided route. At the final session the agent was set up in an AI assistant the business already uses, with read-only access to the CRM and the budget. Every Monday at 7:00 it loads the open deals into a new dated copy of the review, with the window starting on the 1st of next month and the budget's target for those months, runs the checks and sends the managing director a short note. On the first run of each month it adds last month's commit and orders won to History, so the bias keeps being measured. It uses the rules on Inputs: the gap is flagged when it widens by more than 5% of the target in a week, and a deal counts as stale after 30 days without real contact. Nothing left Brackenholt, and no decision changed, without one of its own people approving it. These events continue the fictional example; the figures in them were worked by hand.
| Date | What the agent found | What was decided |
|---|---|---|
| 19 Oct 2026 No flag | The first weekly refresh: honest expected £1,226,000, gap £174,000, the target still inside the range. | Nothing needed. |
| 26 Oct 2026 Flag | Thornhaugh Dairies' overdue £285,000 commit marked lost: the gap widened by £92,000 to £266,000. | A plan on the three biggest deals left in the window; no change to the target. |
| 2 Nov 2026 No flag | October added to History (bias now 32% over 10 months); the window moved on to December to February. | Nothing needed. |
| 9 Nov 2026 Flag | A £19,500 committed deal past its close date with no order recorded. | The order had arrived and wasn't entered; marked won. |
| 9 Nov 2026 Flag | Four deals, £451,000 together, passed 30 days without real contact with the buyer. | Calls or visits booked with all four; one closed as lost. |
| 7 Dec 2026 No flag | November added to History; the window moved on to January to March, with the target inside the range. | Nothing needed. |
At the 30-day check-in on 16 November, Geoff and the managing director read the log together. No rule needed changing.
What the agent added. The method is unchanged: same win rates, same stale rules, same range. The agent made sure the forecast was refreshed every week and the commit recorded every month, so the lost Thornhaugh deal reached the managing director within three days, while there were still three months to act, and the history behind the bias kept growing without anyone digging out old reports. No £ figure is claimed for any of this; the review's figures above are unchanged.