Case study 01
Transforming fragmented sales, purchasing, inventory and margin information into practical commercial decisions.
Portfolio StrategyPurchasingInventoryMarginWorking CapitalDecision Support
A healthcare distribution environment needed better visibility across portfolio performance, stock levels, purchasing activity, margins and working capital. The information existed. What did not exist was a way of reading it together.
Sales, purchasing, inventory, margin and supplier conditions are usually held by different people, reviewed on different cycles and read one at a time. Each is defensible on its own; together they decide whether a portfolio is earning its working capital. I built the analytical framework that connects them, so that every item resolves into one commercial position with a decision attached to it.
An item that sells well is treated as a good item. An item with a strong margin is treated as a profitable one. Neither judgement survives contact with how much stock is standing behind it, or what it cost to hold.
The instinct not to run out is a sound one, and unchecked it is also how a portfolio accumulates cover it will never sell. Without a commercial position attached to an item, every item argues equally for replenishment.
Capital is committed by purchasing decisions taken item by item, months earlier, by people reading availability rather than exposure. By the time it appears as a finance problem the decisions that caused it are long made.
Lines get added for a reason and are rarely reviewed once the reason has passed. What accumulates is not a portfolio so much as a record of past decisions, each of which still consumes shelf space, attention and cash.
Without agreed positions, every discussion about an item restarts from raw figures and ends in judgement that cannot be applied consistently to the next item, or explained to the person who has to execute it.
Portfolio decisions are slow to show their consequences and expensive to reverse, which is what makes the absence of a framework costly rather than merely untidy.
Every item in a distribution portfolio is holding cash. The question is not whether it sells, but whether what it returns justifies what it is holding.
Cash committed to stock that will not move within any reasonable horizon is cash unavailable for the lines that would have moved. The cost is the opportunity, not the storage.
A portfolio that grows only by addition dilutes attention across more lines than the operation can genuinely manage, and the strong lines are managed no better for it.
Replenishment decided line by line, without a position, produces a purchasing pattern nobody chose and nobody can defend at the level of the portfolio.
Margin read without supplier conditions, holding period and movement is a headline number. Read with them, it often describes a different item than the one on the report.
Any correction that treats stock reduction as the objective will eventually cut into the lines the business exists to supply. Availability has to be a constraint on the framework, not a casualty of it.
I built the analytical framework and the decision language that sat on top of it. The commercial decisions remained management decisions — the work was making them answerable from evidence rather than from instinct.
Sales, purchasing, inventory, margin, supplier conditions and the role an item plays in the assortment, brought into one structure that could be read per item rather than per report.
Grouped the portfolio by commercial behaviour rather than by category, so that items which behave the same way commercially are managed the same way regardless of what they are.
Established where capital was committed, how long it had been committed, and which of those commitments were recoverable without reducing the availability the business depends on.
Turned the analysis into a purchasing order of precedence — what must be bought, what can wait, and what should not be bought again — expressed per item rather than as a principle.
Identified the lines carrying cost without carrying a commercial role, and the conditions under which each could be reduced, finished or discontinued.
Presented the position and the trade-off for each group so management could decide with the consequence visible, then apply the same reasoning to the next review without rebuilding it.
Six inputs decide an item’s commercial position. Read individually any one of them can justify almost any decision; read together they usually only support one.
How the item actually moves — the pattern over time, not the total.
What has been committed to it, how recently, and on what cycle.
What is standing behind the demand, and how long it has been standing there.
What the item returns once the terms it was bought on are included.
The terms attached to buying it: what they enable, and what they oblige.
What the item is for — whether it earns, protects a category, or completes a range.
The framework is deliberately structural. Thresholds, review periods and the weighting between inputs belong to the operation that runs it, change with commercial conditions, and are not published here.
The output is not a score. It is a position — one of six — and each position commits the business to something specific. That is what makes it a decision rather than a report.
Earns its capital and matters to the customers the business depends on. The risk here is under-supply, not over-supply.
Commits toAvailability first. Purchasing priority, and stock cover defended even when the portfolio is being reduced elsewhere.
Performing acceptably against its role in the assortment. No case for investment, no case for intervention.
Commits toContinued replenishment at current terms, and periodic review rather than active management.
Justifies its place but not its current cover. The item is sound; the position behind it is heavier than the demand supports.
Commits toPurchasing slowed or paused until cover returns to a level the demand actually justifies. The line stays.
No longer earning its place, but the stock on hand is saleable through normal demand without intervention.
Commits toSell through what exists, buy none, and remove the line once the position clears. A planned exit, not a write-off.
Capital is committed and will not release through normal demand. Left alone, the position does not improve — it ages.
Commits toAn active recovery route, decided per item, and acceptance that recovery is a commercial trade-off rather than a saving.
Whatever the item once did for the portfolio, further purchasing adds exposure without adding commercial value.
Commits toA purchasing block that holds across reorder cycles, supplier offers and availability pressure — the decision most likely to be quietly reversed.
Six positions rather than a good/bad split, because the useful distinctions are in the middle. "Reduce", "Finish" and "Recover" all describe items the business is stepping back from, and each requires a different action — collapsing them is how a portfolio review turns into an across-the-board stock cut.
The framework is only worth something if it survives the moment someone wants to buy the item anyway.
Analysis that produces a position is straightforward. The commercial value is in the position holding — through a supplier offer, a reorder cycle, a quiet worry about availability, or a month when the number looks different.
The framework is not permitted to reduce stock on lines the business exists to supply. Protected items are named first, before any reduction is considered, so a portfolio correction can never quietly become a service failure.
Every position states what the business does next. A classification that does not change a purchasing decision has produced a description, not a decision, and will be ignored on its second reading.
The framework makes the trade-off visible and consistent. It does not approve, execute or overrule a commercial judgement — the point is that the judgement is made against evidence, and the same way each time.
A review that only works once is an exercise. The structure was built so the next review starts from the framework rather than from the raw figures again, which is what makes the second one faster than the first.
Stated as what the work made visible and decidable. No value, percentage or saving is published here — the results belong to the business, not to this portfolio.
Portfolio quality became a question with an answer. Management could see which parts of the range were earning their capital and which were being carried, expressed per item rather than as an impression of the category.
Purchasing gained an order of precedence. Replenishment could be argued from a commercial position rather than from the fear of running out, and the items that should not be bought again were named rather than assumed.
Stock exposure became legible before it became a finance problem. Where capital was committed, how long it had been committed and whether normal demand would release it were visible at the point where purchasing decisions are actually taken.
Working-capital opportunities were identified with the trade-off attached. Each recoverable position came with what recovering it would cost commercially, so the choice was a real one rather than a headline number.
Availability was protected through the correction. Because protected lines were established first, portfolio reduction could proceed without cutting into the supply the business depends on — the failure mode this kind of exercise is most prone to.
No figure from the environment this work was carried out in appears anywhere on this page. The framework is published; the portfolio it was applied to is not.
Commercial analysis is not the production of a report. It is the production of a decision that can be defended next month, by someone who was not in the room.
This case is centred entirely on commercial decision-making. The deliverable was not a system or interface, but a clearer way of reading portfolio performance and translating that information into defensible management decisions.
It draws on the operational side rather than setting it aside. Knowing what a stock position feels like on the shelf, what a supplier offer does to a purchasing decision, and how quickly an availability worry overrides a commercial instruction is what stops a framework like this from being theoretically sound and practically ignored.
Commercial analysis Portfolio judgement Working capital Management decision
The same reasoning runs through the rest of this portfolio. Understand what the operation is actually doing, establish what the evidence supports, and turn it into something a person can act on — whether that ends in a commercial framework, a redesigned workflow or a system.
This case study describes an analytical and commercial framework. No organisation, customer, supplier, brand, item, price, quantity, stock value, margin figure or working-capital amount appears, and the environment is described by category and country only. The diagrams show structure rather than results: thresholds, review periods and item-level outcomes are set by the operation and are not published.
Contact
If sales, purchasing, stock and margin are each reviewed on their own — and nobody can say per item what the business should protect, reduce or stop buying — describe how the reviews run now. I'll tell you what I'd connect first.