Sales Forecast and Pipeline Review · October 2026

Brackenholt Automation Ltd

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).

Worked example. Brackenholt Automation, every customer named on this page, and its figures are fictional. All figures come from the worked-example spreadsheet: ALL CHECKS PASSED (with 8 notes).
The headline

Committed £1,517,500; honest expected £1,241,017; the target sits inside the range

Honest expected
£1,241,017
orders won; likely £918,963 to £1,563,071 (about 2 in 3)
Gap to target
£158,983
£54,054 of gross profit, against a £1,400,000 target
Commit
£1,517,500
£672,000 of it on 5 deals already overdue; past commits ran 29% high
Past close date
£757,000
7 deals; 8 older than twice the usual age at their stage

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.

From commit to honest forecast

The commit is 22% above the honest expected, and 44% of it is on overdue deals

Target£1,400,000Salespeople's commit£1,517,500Commit adjusted for past bias£1,173,004Honest expected£1,241,017

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.

From open deals to the honest expected

How each step takes the pipeline down to a realistic figure

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,495past their close date, due just before the window, unusually old, or no real contact
Less: won deals slipping past the window−£188,758the assumed 80% on time
Plus: new enquiries that can still land£197,489by how fast Brackenholt’s deals are really won
Honest expected£1,241,017the 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.

The team's own flags

The £1,517,500 commit is worth £587,558 at Brackenholt’s own win rates

FlagDealsValue in the windowExpected at own ratesExpected ÷ value
Commit15£1,517,500£587,55839%
Best case10£1,097,000£328,55930%
Pipeline8£443,000£110,88125%
SalespersonOpen dealsCommittedHonest expected, all their dealsCommit ÷ expected
Sales director6£481,000£393,5951.2×
Account manager North11£577,000£271,8682.1×
Account manager Midlands11£377,000£262,5121.4×
Internal sales10£82,500£115,5530.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.

How past forecasts did

Nine months of commits ran 29% above what was won

Jan+18%Feb+54%Mar+28%Apr+12%May+43%Jun+30%Jul+18%Aug+45%Sep+30%

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.

Win rates by stage

From 18 months of closed deals

StageWon of reachedWin rate usedOpen dealsTheir valueExpected in the window
Enquiry qualified
Your records · won deals usually here by day 25
96 of 38025%5£267,000£38,602
Site survey done
Your records · won deals usually here by day 45
90 of 26035%6£668,000£93,288
Proposal sent
Your records · won deals usually here by day 70
84 of 21539%12£1,066,000£230,433
Technical sign-off
Your records · won deals usually here by day 85
70 of 12855%6£611,000£243,195
Negotiating
Your records · won deals usually here by day 95
62 of 9665%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 1687%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.

The deals in the window

12 stale deals first, then the rest by what they're expected to bring

DealFlagsValueWin chance in the windowExpected
Thornhaugh Dairies: case packer and palletiser cell
Sales director · Negotiating · close 30 Sep 2026
Past close date Commit£285,00032%£92,031
Hartsop Brewery: keg line PLC replacement
Account manager North · Technical sign-off · close 28 Aug 2026
Past close date Commit£118,00027%£32,266
Brendon Castings: fettling robot
Account manager North · Site survey done · close 08 Jan 2027
No contact Best case£155,00017%£26,827
Shapwick Polymers: extrusion line controls
Sales director · Proposal sent · close 18 Dec 2026
2.2× usual age Best case£134,00020%£26,177
Salcott Seafoods: washdown robot picker
Account manager North · Proposal sent · close 02 Oct 2026
Past close date Commit£128,00020%£25,005
Grisedale Mills: bagging line robot
Account manager North · Proposal sent · close 31 Jul 2026
Past close date Commit£112,00020%£21,879
Ullswick Foods: end-of-line labelling
Internal sales · Verbal order · close 30 Oct 2026
Due just before the window Commit£38,00044%£16,530
Elmstead Joinery: CNC loading cell
Account manager Midlands · Proposal sent · close 09 Dec 2026
No contact Best case£67,00020%£13,088
Abbotsley Feeds: bulk intake controls
Internal sales · Proposal sent · close 25 Sep 2026
Past close date Best case£61,00020%£11,916
Inglesham Timber: stacker controls
Account manager Midlands · Proposal sent · close 30 Nov 2026
4.6× usual age Best case£52,00020%£10,158
Rockbeare Foods: X-ray reject integration
Internal sales · Technical sign-off · close 09 Oct 2026
Past close date Commit£29,00027%£7,930
Draycote Packaging: shrink-wrap retrofit
Internal sales · Proposal sent · close 15 Sep 2026
Past close date Best case£24,00020%£4,688
Frampley Auto Trim: assembly line PLC and HMI
Sales director · Negotiating · close 15 Jan 2027
Best case£240,00052%£124,000
Quenby Confectionery: pick-and-place robots
Sales director · Technical sign-off · close 22 Jan 2027
Commit£196,00044%£85,750
Ashwell Pet Foods: bag palletiser
Account manager Midlands · Negotiating · close 04 Dec 2026
Commit£165,00052%£85,250
Corringham Pharma: serialisation upgrade
Sales director · Proposal sent · close 29 Jan 2027
Best case£210,00031%£65,637
Wexcombe Plastics: robot unload for four moulders
Account manager North · Technical sign-off · close 20 Nov 2026
Commit£148,00044%£64,750
Tolland Engineering: cobot machine tending, two cells
Account manager Midlands · Technical sign-off · close 11 Dec 2026
Commit£86,00044%£37,625
Penlow Metals: welding cell guarding and controls
Account manager North · Site survey done · close 20 Jan 2027
Pipeline£135,00028%£37,385
Kelmarsh Components: vision inspection, three stations
Account manager Midlands · Negotiating · close 10 Nov 2026
Commit£72,00052%£37,200
Ravensholt Bakeries: line SCADA upgrade
Account manager Midlands · Proposal sent · close 15 Dec 2026
Best case£96,00031%£30,006
Wendling Salt: packing line PLC
Account manager Midlands · Negotiating · close 17 Nov 2026
Commit£54,00052%£27,900
Bodenham Labels: print-and-apply automation
Account manager North · Negotiating · close 16 Dec 2026
Commit£44,00052%£22,733
Lydcombe Beverages: palletiser safety upgrade
Account manager North · Verbal order · close 13 Nov 2026
Commit£27,00070%£18,792
Marlstead Tyres: bead handling automation
Account manager North · Enquiry qualified · close 30 Jan 2027
Pipeline£88,00020%£17,785
Mereworth Logistics: conveyor controls
Internal sales · Site survey done · close 27 Nov 2026
Best case£58,00028%£16,062
Nettlecombe Bottling: line efficiency monitoring
Internal sales · Technical sign-off · close 24 Nov 2026
Commit£34,00044%£14,875
Halstock Chilled: checkweigher integration
Internal sales · Verbal order · close 03 Nov 2026
Commit£19,50070%£13,572
Pilsdon Dairy: CIP control upgrade
Internal sales · Site survey done · close 02 Dec 2026
Pipeline£47,00028%£13,015
Hexworthy Fabrications: press brake cobot
Account manager Midlands · Proposal sent · close 12 Jan 2027
Pipeline£39,00031%£12,190
Quarrendon Cider: depalletiser controls
Internal sales · Proposal sent · close 06 Nov 2026
Pipeline£31,00031%£9,689
Ludford Glass: robot handling trial cell
Account manager Midlands · Enquiry qualified · close 18 Dec 2026
Pipeline£45,00020%£9,095
Yarcombe Nuts: robot case packing
Internal sales · Enquiry qualified · close 28 Nov 2026
Pipeline£36,00020%£7,276
Wraxall Paper: reel handling AGV study
Account manager North · Enquiry qualified · close 31 Dec 2026
Pipeline£22,00020%£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.

How confident are we?

What this rests on

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.

The months after

What the agent flagged, and what people decided

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.

DateWhat the agent foundWhat 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.