All use cases
Margin Drop When Old Stock Runs Out · Predictive · about to happen
  1. 01How it is found
  2. 02What you see
  3. 03What you do next
  4. 04The money
  5. 05In both engines' views
  6. 06On from the start

The margin looks fine. That's the old stock talking.

You are still selling stock bought at the old, lower cost. The newest purchase cost more. Otiox works out the margin you will have once the cheaper stock is gone, and roughly when, while you can still reprice.
app.otiox.comFig. 00
Predictive · margin
Margin 32 % → 18 % when cheaper stock runs out
About 21 days at today's pace
SignalMeasuredValue
Stock on handaverage cost$6.80
Latest purchaseper unit$8.20
Priceunchanged$10.00
Extra cost a month: $68
What to do

Review the price now, before the dearer stock is what you sell.

The new price holds the margin at the new cost.

01The Challenge

Today's margin is last quarter's cost.

For example: stock on hand cost $6.80 on average, the latest purchase $8.20. At a $10 price the margin falls from 32 % to 18 % in about three weeks, when the cheaper stock is sold.
  1. 01
    Old cost layers hide the new cost
  2. 02
    Margins look fine until they don't
  3. 03
    Repricing comes after the drop
  4. 04
    Nobody knows when it will hit
02SEE IT IN OTIOX

The same situation, in the product.

Real screens from the Otiox demo workspace, step by step.
  1. 01

    The forecast, with its cascade

    The Predictive Engine's card shows the numbers behind the warning, the cascade from the record to the money and the recommended action. Review the price now, before the dearer stock is what you sell.

    The forecast, with its cascade
  2. 02

    On, shadow or off

    The scenario's row on the Scenario switches page: how many findings are open, and its switch. It is on from the start; shadow keeps it counting without raising findings.

    On, shadow or off
03

How It Works

Purpose-built features that solve these exact problems.
01

How it is found

Products whose newest purchase cost is more than 2 % above the average cost of stock on hand. It fires when the margin at the new cost is under the target (or drops 10 points or more), and the stock on hand runs out within "Stock runs out within (days)", 60 by default, at the last 30 days' sales pace.
02

What you see

The Risk Inbox line "{product}: margin 32 % → 18 % once the cheaper stock runs out (~21 days)" with an Open product button, in the Predictive Engine.
03

What you do next

Review the price now, before the dearer stock is what you sell.
04

The money

Extra cost per month at today's sales pace.
05

In both engines' views

The finding appears in the Predictive Engine with its cascade from the record to the money, in the Risk Inbox and in the Loss Prevention Report.
06

On from the start

The scenario is on by default. Put it in shadow to keep it counting on the margin scenarios screen, with a six-month backtest, without raising findings, or switch it off.
04

What You'll Gain

Tangible improvements that impact your bottom line.
  1. 01
    Before, not after

    You reprice while the cheap stock is still selling.

  2. 02
    A date to act by

    Roughly when the margin will drop.

  3. 03
    Counted with every other loss

    Margin findings feed the Loss Prevention Report next to the other engine findings.

  4. 04
    Nothing changes by itself

    No scenario changes a price, a discount or an order. You decide.

05

Real-World Scenarios

See how this works in practice.
Scenario 1

Dearer stock behind

Stock on hand cost $6.80; the latest purchase $8.20.
Scenario 2

Warned

The finding shows 32 % → 18 % in about 21 days.
Scenario 3

Fixed

The price moves now, before the new cost arrives in sales.
06

The Transformation

From chaos to clarity.
Before
  • Margin on old cost
  • New cost unseen
  • Repriced too late
  • No date
After
  • Margin at the new cost
  • Run-out date estimated
  • Repriced in time
  • Monthly cost shown
07

Frequently Asked Questions

Quick answers to common questions.
01How is the run-out date worked out?
From stock on hand and the last 30 days of sales.
02Which cost is 'new'?
The newest purchase cost, compared with the average cost of stock on hand.
03Who sees the numbers?
Cost and margin figures are shown only to people with cost or accounting rights.
04Does Otiox change prices or orders?
No. No scenario changes a price, a discount or an order. It raises the finding and opens the record; the decision is yours.
05Can I put it in shadow or switch it off?
Yes. Every scenario is on from the start. Per scenario, you can put it in shadow (it keeps counting on the margin scenarios screen, with a six-month backtest, but raises nothing) or switch it off, on the margin card or the Scenario switches page. Thresholds are workspace settings.
06Which currency are the amounts in?
Your books currency, at the store's own rate. With no rate, the amount is left empty, never guessed. VAT is taken out before margins; test, cancelled, refunded, draft and abandoned orders are left out.
Margin Drop When Old Stock Runs Out

Ready to transform your margin drop when old stock runs out?

See how Otiox can solve your specific challenges.