How much stock is beyond what the business actually needs?
Weeks of cover, and stock above target
- 1Average weekly sales over the last 12 complete weeks. Complete weeks only, because a part week at either end drags the average in a direction nobody intended.
- 2Weeks of cover on hand = stock on hand ÷ average weekly sales. Here, 400 ÷ 11 = 36 weeks.
- 3Target cover = your supplier lead time + your safety cover. Here, 2 + 1 = 3 weeks. This is your number, not ours.
- 4Target units = average weekly sales × target cover = 33 units.
- 5Units above target = stock on hand − target units = 367 units.
- 6Value = units above target × landed cost = £6,826.
What it accounts for
- Landed cost, not invoice price. For an imported line, freight, duty and clearance are part of the money tied up, and using invoice price alone understates it.
- Stock on order is counted separately, never folded into this figure. Projected cover after inbound is reported as its own number.
- Case size and minimum order quantity are read before any suggestion to reduce an order, because a reduction that cannot be made is not a recommendation.
- Shelf life and ageing are read. Twenty weeks of ambient rice and twenty weeks of a short-dated line are not the same exposure.
- A line marked as a deliberate bulk buy is excluded, with the reason recorded.
When it produces no figure
If the stock file is stale, or sales history is too short to give a stable velocity, MarginLoop lowers confidence or suppresses the recommendation rather than producing a number from a bad input.
