← All AI ROI products
Founder pricing
AI product · Operations

Forecast Accuracy Audit

For businesses that hold stock: find out how accurate your demand forecast really is, product by product, and what the errors cost you in cash and missed orders.

About 6–10 hours of your time (estimate)Your sales and stock historyRun it yourself or with Geoff
What it answers

Four questions it answers

  1. 1

    How accurate are our forecasts?Product by product, month by month.

  2. 2

    Which products are hardest to forecast?Grouped by value and how steady demand is.

  3. 3

    What do the errors cost?Excess stock and lost sales, in £.

  4. 4

    What should change?Method, routine and who decides.

Founder pricing. The method, the calculation spreadsheet with 16 built-in checks, and a complete worked example are built and tested. The first client for this product gets the founder price, in return for permission to measure the results and, if they are good, write them up as a case study. After that, the price goes up. Book a call to take the founder place.

What you get

What you get

Accuracy by product, checked

Forecast against actual for each product, from your own history, with 16 built-in checks that catch missing months, mismatched product codes and unit errors.

Products grouped

By value and by how steady demand is, so effort goes where it pays.

Cost of error in £

Cash tied up in excess stock and sales lost to stock-outs.

Your planning routine reviewed

Who forecasts, when, and with what information.

An improvement plan and a one-page audit

The changes that will improve accuracy most, with owners and dates.

A monthly agent in your own accounts

With guided or done for you, each month the audit is rerun on the latest month in your own accounts, against the error you set for your most valuable products, and you are told which products are getting worse. Nothing leaves your business, and no decision changes, without one of your people approving it.

Worked example

A South West garden products wholesaler

A fictional 46-person wholesaler with 60 stock lines, seasonal and steady. The audit used 12 months of its forecasts, sales and month-end stock.

Its forecast beat the simple baseline overall (30% error against 44%), but 18 products did worse than just using last month's sales, and outdoor lighting ran out at the peak. The routine, a once-a-year forecast by one person, was the root cause.

Read the full example

Penrose Garden Products LtdFictional · Worked example
Forecast erroragainst a simple baseline
30% vs 44%
Products worse than the baselineof 60
18
Cost of errora year
£174,312
Excess stockcash tied up, once
£49,264
IllustrativeAll names and figures are invented. The cost of error rests on assumed stock cover, holding cost and share of demand lost.
How it works

Five stages

  1. Load

    Export 12–24 months of forecasts, sales and stock by product.

  2. Group

    Sort products by value and demand pattern.

  3. Measure

    Measure accuracy and whether you tend to over- or under-forecast, and cost the errors.

  4. Improve

    Agree changes to method and routine.

  5. Keep

    Each month the agent reruns the audit on the latest month in your own accounts and flags the products whose forecast is getting worse, so the improvements hold.

Three ways to buy

Do it yourself, with Geoff, or done for you

The same method and the same spreadsheet in every option. You choose how much of your own time goes in.

Self-implement kit

Run it yourself

For owners comfortable with a spreadsheet and an AI assistant.

  • The AI skill
  • The calculation spreadsheet
  • A worked example
  • The buyer's guide
Book a call
Guided implementation

Run it with Geoff

For owners who want a second pair of eyes on the data and the analysis.

  • Everything in the kit
  • Three working sessions
  • Geoff reviews your analysis
  • Your improvement plan, reviewed
  • The monthly agent, set up with you in your own accounts
Book a call
Done for you

Geoff runs it

For owners who would rather hand over the data and get the answer.

  • Geoff runs the audit in your own systems, from your exports
  • Cost of error and improvement plan
  • A session with your planning team
  • A written handover for your planning team
  • The agent's first monthly rerun in your account, its note reviewed with you
Book a call
What you'll need

Data you already have

  • 12–24 months of sales by product
  • Your past forecasts or purchase plans (if you have none, the audit sets a baseline instead)
  • Stock levels by product
  • About 6–10 hours of your time over two weeks (estimate)
  • For the monthly agent (guided and done for you): an AI assistant your business already uses or approves, that can run a scheduled task and connect read-only to your stock or sales system and your purchasing spreadsheet; we confirm this with your IT before you commit
Which AI?

Designed for Claude, in an open format

It is built on the open Agent Skills standard and designed for Claude (any plan, with code execution switched on). A paste-in version is included for ChatGPT, Gemini and Microsoft Copilot; it has not yet been tested on them.

The calculations live in the spreadsheet, not in the AI, so the numbers don't depend on which assistant reads them.

Hold the right stock

Book a short call to talk through how you plan stock and demand.

Book a call
Geoff@fox.coach · 07770 683883 · fox.coach