How to Find Book Titles That May Run Out Before a Reprint
The warehouse has 900 copies, but a 600-copy order is already allocated and the reprint is three weeks out. Planning needs the stock left after commitments.
What to pull
Use Excel inventory, orders and print schedules or export warehouse stock, open orders and confirmed printer deliveries. Keep ISBN, format and location.
How to check it
Subtract firm allocations and unusable stock. Compare remaining units and recent demand with the next confirmed inbound date.
Select the relevant sheets in Jolene.pro and run this check.
Which ISBNs could run short before their next reprint? Show the projected gap, assumptions and source rows.
What to do with the result
Review firm commitments first. Ask production for an updated print date and sales whether a split shipment would work.
Sample figures. Confirm current stock and printer dates before committing copies.