Food DistributionTen margin levers, and what can be budgeted
Ten workstreams quantified on the company’s own data, never on market ratios.
What we did : Ten workstreams identified and costed on the company’s own data, never on market ratios.
What you can budget : About €0.36M net per year, from a measured potential of €0.85M to €1.6M gross. Payback in 9 to 26 months.
The situation
A food distribution group: a warehouse that sells fresh and dry goods to business customers and supplies the group’s own network of stores. Warehouse revenue of more than €20M, gross margin of about 20%, a legacy business management system and several point-of-sale systems. Price-setting and knowledge of the systems rest with very few people.
Leadership asked a simple question: what can artificial intelligence do for us, in what order, and for what gain? The ground rules were set on day one: value first, and the data stays with the client.
The approach, step by step
| Step | What was done |
|---|---|
| Economic Baseline, the reference performance | A data foundation built during the engagement from a controlled copy of the management database and the store point-of-sale systems. First benchmark: one point of margin on warehouse sales is worth about €0.2M a year. |
| Value Discovery, identifying the sources of value | Interviews with the teams. More than 160 use cases identified, grouped into ten workstreams that share the same data, the same owner and the same expected result. |
| Value Quantification, quantifying the gains | Every gain quantified from a measurement taken in the company’s own data. No market ratios. |
| Capital Prioritization, prioritizing the investments | Workstreams ranked from A to D by return on investment: annual gain relative to implementation cost. |
| Value Realization, proposed to leadership | No workstream moves to the next stage without a measured result. The tool advises; people decide. |
What the data showed
| Measured finding | Order of magnitude | What it opens up |
|---|---|---|
| Sales below cost | Several thousand sales over twelve months, about €0.6M in losses | The first source of value: price recommendations |
| Price dispersion | The same item sold at prices more than 20% apart in 60% of cases | Fragmented price decisions, and therefore room to improve |
| Inventory with no recorded sale | About €0.45M at purchase cost | The upper bound of the unsold inventory opportunity |
| Inactive suppliers and customers | Several hundred dormant suppliers, dozens of customers with no order in three months | Tool-supported reactivation, with a gain that can be quantified |
| Payments | Nearly 40% of payments late | Three to five days gained free up €0.18M to €0.3M in cash, one time |
| Consolidated margin | No measurement of margin from the price paid to the supplier to the register receipt | The first building block of leadership reporting |
The ten workstreams
| Workstream | Estimated annual gain | Class |
|---|---|---|
| Data foundation and product master data | Indirect: a prerequisite for the other workstreams | Foundation |
| Leadership reporting: dashboards and plain-language questions | €45k to €60k in avoided costs | Foundation |
| Price recommendations and margin management | €250k to €450k | A |
| Reactivation of inactive suppliers and customers | €90k to €180k | A |
| Clearing slow-moving and unsold inventory | €120k to €250k | B |
| Warehouse reliability and cost of poor quality | €100k to €200k | B |
| Accounting, receivables and cash | €80k to €160k, plus €180k to €300k in one-time cash | B |
| Store network management | €100k to €180k | C |
| Automated processing of supplier offers | €60k to €150k | C |
| Critical risks and knowledge continuity | Not quantifiable | D |
| Total | €845k to €1,630k gross per year |
Each workstream was costed with its implementation budget and its running cost: that ratio sets its class. We can walk you through the detailed budgets in a first conversation.
What can be budgeted
About €0.36M net per year can go in the budget. Measured potential does not go into the budget as is. We start from the low end of each gain and apply a haircut that depends on how solid the measurement is:
| Strength of the measurement | Share retained |
|---|---|
| Value observed line by line, or a known avoided cost | 70% |
| Gain that depends on behavior: a recommendation that is followed, a supplier that responds | 50% |
| Figure extrapolated from a sample | 40% |
After the haircut, the gains come to about €0.48M a year. After the running cost of the tools, taken at the high end of the estimate, about €0.36M net a year remains. On this conservative basis, warehouse gross margin rises from about 20% to 21%. Part of the gain comes from cash, avoided costs and the store network, so only the share tied to warehouse sales shows up in that margin. The €0.85M to €1.6M potential would take it to 22% to 24%: that is the target trajectory, not the budget line.
| Period | What is live | Net annual gain achieved, conservative basis | Annual potential |
|---|---|---|---|
| Months 0 to 3 | Data foundation, leadership reporting, first price scope | No euros yet, a first measurement | None |
| Months 3 to 6 | Prices, reactivation of inactive accounts, leadership reporting | €135k | €665k |
| Months 6 to 12 | Slow-moving inventory and store network | €240k | €1,090k |
| Year 2 | Warehouse, accounting and cash | €345k | €1,445k |
| Year 3 | Supplier offers | €360k | €1,585k |
The caveats, stated before any decision
- Margin precision has a limit. Margin is measured when goods enter inventory, not in the general ledger: a gap of about 0.8 points remains and bounds every margin figure.
- End-to-end margin is not complete everywhere. For the share of volume transferred to the store network, margin stops at the transfer price. It is complete for only some of the stores, and one store’s result cannot be extrapolated to the others.
- The gain depends on adoption. A sound recommendation that is not followed produces zero euros. No technology removes that limit.
- Team time is not costed, even though the gain depends on it.
What the engagement teaches
- Separate the potential from the conservative base from the start. The figure announced before any access to the data, €0.45M to €1M a year, was confirmed by the measurements. But what can go in the budget is less than half of the top of that range.
- Check scope before quantifying. A first pass underestimated the share of volume transferred to the store network by a factor of ten, because each legal entity had not been assigned to the right scope.
- The measurement that was most missing was not a workstream. Consolidated margin, from the price paid to the supplier to the register receipt, did not exist anywhere. It is built by combining two sources that were already available, and it is published on a fixed schedule.
The next steps leadership chose
A concrete start: finish the data foundation, launch leadership reporting as a project in its own right, then test price recommendations on a first product family. Three conditions were set: a dated launch with dedicated resources, a business owner for each workstream with time genuinely freed up, and a target gain and cost set before any vendor is consulted.
Do you know what one point of margin is worth to your business?
Peter Guillon will call you back within 8 business hours.
