Lumeis

Plant, channel and counter reading the same batch

Production, distributors, pharmacies and regulatory each hold a piece of the same product. Lumeis OS brings them into one base and shows where stock stalled before it expires.

Monday briefingWeek 46
  • CommercialProducts with sell-in above sell-out for three months46
  • Shelf lifeBatches in the channel expiring in under 180 days312
  • PricingItems sold above the PMC price cap in at least one store17
  • LogisticsCold-chain deliveries outside the temperature range23
  • PharmaciesStores missing at least one of their 50 top sellers138
ERP · distributors · POS · WMS and TMS · CMED price tableIllustrative example

The stock is still in the channel. Its shelf life is running out.

When the manufacturer only looks at channel volume, coverage looks healthy. Batches close to expiry only show up later, as returns and write-offs.

Generics line · distributors and pharmacies · 2026

Illustrative example
  • Stock in the channel (distributors and pharmacies)
  • With more than 12 months of shelf life
  • Stock that entered the expiry window
6007008009001,000M1M2M3M4M5M6M7M8

thousand units, counted at the end of each month

Returns due to expiry

0.8 2.9 %

Lumeis OS matches channel stock with the batch and expiry date of every unit. When the expiry window grows, the alert arrives in time to reallocate.

Each link in the channel holds one part of the product

The plant sees the batch. The distributor sees the order. The pharmacy sees the sale. Regulatory sees the registration. Stalled stock shows up where these views meet.

  1. Manufacturing and quality

    Batches, production orders, certificates and release.

    Where visibility stopsThe batch is released and the expiry date drops off the order.

  2. Distribution

    Orders, stock by DC, deliveries and temperature.

    Where visibility stopsDistributor stock reaches the manufacturer once a month.

  3. Commercial and trade

    Quotas, campaigns, discounts and medical visits.

    Where visibility stopsThe discount becomes an order and counter sales go uncounted.

  4. Pharmacy and POS

    Sales by store, prescriptions, shelf price and loyalty.

    Where visibility stopsA store stockout becomes a lost sale with no record.

  5. Regulatory and pharmacovigilance

    Registrations, CMED pricing, adverse event reports and recalls.

    Where visibility stopsA recall has to find the batch in every store, by hand.

Lumeis OSOne view of the product from batch to counter, with the source of every number.

The health calendar with stock measured

Pharma follows the health and pricing calendar: summer, flu, the CMED adjustment and retail dates. Stock has to be in place before demand.

  1. jan

    Summer and dengue

    Tracks repellent, painkillers and sunscreen by region, against store stock.

  2. mar

    Annual CMED price adjustment

    Simulates each line's margin under the new cap and updates prices in every store.

  3. may

    Flu and respiratory season

    Measures stockouts and turnover of flu and cough products by region, week by week.

  4. jul

    Demand plan review

    Compares the semester forecast with actual sell-out, by product and channel.

  5. sep

    Budget and quotas

    Brings each distributor's turnover and returns for the year into planning.

  6. nov

    Black Friday

    Separates new sales from pulled-forward purchases, by store and category.

  7. dec

    Year-end inventory count

    Shows batches close to expiry before the count, by DC and by store.

Every month · sell-in and sell-outEvery channel order read together with counter sales and stock, by product and region.

Each team's question, answered with its source

Questions Lumeis OS answers

  1. 01Which products have sell-in above sell-out?
  2. 02Which distributors buy more than they pass on to pharmacies?
  3. 03How much of this quarter's growth became counter sales?
AnswerIllustrative example

46 products billed above sell-out for the last three months in a row.

Why
Two thirds were part of the quarter-end campaign, with volume discounts for distributors.
Next step
Review each distributor's quota before the next order, with current channel stock.
Sources
  • ERP · invoicing
  • Distributors · sell-out and stock
  • Market panel · sell-out

One definition for every number in the channel

The manufacturer counts stock one way, the pharmacy another. In Lumeis OS each metric has one definition in the context, and every team uses the same one.

  • Sell-out

    Definition

    Units sold to consumers at pharmacies, by product, region and period.

    SourcePOS and market panel
  • Channel stock in days

    Definition

    Stock at distributors and pharmacies, over average daily sell-out.

    SourceDistributors · stock and POS
  • Stockout rate

    Definition

    Stores with no stock of an active item, over the stores that sell the item.

    SourceERP · stock by store
  • Expiry loss

    Definition

    Value of products expired or returned for expiry, over the value billed in the period.

    SourceERP · batches and returns
  • PMC compliance

    Definition

    Items sold at or below the Maximum Consumer Price, over items sold.

    SourcePOS and CMED table
  • On time and in range

    Definition

    Deliveries on time and within the temperature range, over deliveries in the period.

    SourceTMS and data loggers

Talk about a pharmacy retail process

Tell us which process hurts the most today.