Industry Use Cases

How to Spot Quarry Stockpiles Running Short Against Open Orders

The quarry has plenty of aggregate on site. The customer needs one grade that is already committed to two morning orders.

What to pull

Use Excel stockpile counts, orders and production plans or export inventory, open sales orders and scheduled production. Keep grade, site, available tonnage and due date.

How to check it

Subtract reserved and held stock and apply due-date priorities. Count planned output separately unless confirmed. Use only approved grade substitutions.

Which grades have uncovered open orders by dispatch date? Show available stock, confirmed output, commitments and source rows.

What to do with the result

Give dispatch the earliest short orders and their uncovered tonnage. Review confirmed production or customer-approved rescheduling with planning.

Measured stock and planned production can change. Confirm availability before making commitments.

Try Jolene.pro ยท Follow Jolene.pro on LinkedIn

Leave a comment