Stark Consultancy

Orders & inventory · 20 / 20

Sales order fill-rate tracking

Ordered vs. shipped, on every order — with the exact reason behind every short-shipment.

Sample data · synthetic

What actually changes

See your real fill rate today, not a number finance reconstructs once a month.

'Fill rate' is a number finance rebuilds by hand from ordered and shipped exports once a month, long after the shortfall happened.

See fill rate computed per order the moment it ships, not at month-end
Know the actual cause behind every short-shipment — stockout, substitution, backorder, or cancellation
Watch the network-wide fill-rate trend catch a slipping number weeks before the monthly review would

What was built

A live fill-rate tracker comparing ordered vs. shipped quantity per order, tagging every shortfall with its actual cause and rolling up into a network-wide fill-rate trend.

Result

%

network fill rate, computed live

The mechanics

How this actually runs, step by step.

  1. 1Every sales order carries both its ordered quantity and what was actually shipped.
  2. 2Fill rate is computed per order the moment it ships — no end-of-month reconstruction from two separate exports.
  3. 3Any order shipped short is tagged with the actual cause — stockout, substitution, backorder, or customer-cancelled — not left unexplained.
  4. 4Order-level fill rates roll up into a network-wide weighted fill rate and a 12-week trend, so a slipping number is caught long before the monthly review.
Fill-rate calcShortfall taggingTrend tracking