Compare the source document with the reels on hand
Begin with the purchase order, warehouse export, or project closeout list, but treat it as a starting point rather than the current balance. Assign each visible reel, box, or continuous cut length a reference and compare that physical item with the source record. Note any discrepancy instead of silently carrying the original ordered footage into the offer list.
A missing reel, a consumed partial reel, and a pending return require different notes. The record should say what was physically seen, what the older record says, and why the two figures differ when that is known. This is the core task of overrun reconciliation.
- Source document ID
- Physical reel or package reference
- Original quantity and current quantity
- Reason or unknown status for each discrepancy
Keep product and quantity situations separate
Group only genuinely matching cable specifications. Full reels, partial reels, unopened boxes, and cut lengths should remain separate quantity situations even when their product designation matches. Record the manufacturer or part number, full readable designation, reel count, and continuous footage per item or matching group.
State whether each remaining figure is measured, documented, or estimated. Do not add short cuts into one long run or call a historic ordered amount a current reel balance. A seller can still submit an incomplete record; the important point is that the limitation is clear.
- Manufacturer or part number
- Full readable designation
- Full, partial, box, or cut-length status
- Per-reel footage and quantity basis
Show condition and reservation status together
Mark each line as unused, removed, or otherwise limited by its known history. Photograph missing seals, packaging damage, exposure, or visible jacket damage and list dates only when they are actually known. A condition description should document what the seller knows, not make a performance claim.
Separately identify inventory that is reserved for another job, awaiting a customer return, under internal review, or not yet cleared for release. A line that is physically in the warehouse is not necessarily available for sale. Keeping availability separate from quantity eliminates a common source of confusion.
- Condition status and known storage facts
- Missing seals or visible damage
- Reserved, pending-return, or cleared status
- Known or unknown date information
Clear the sale and release record before presenting availability
For each group, identify the owner, the person or role able to approve sale and release, the storage ZIP, access limits, and available loading information. Do not rely on a buyer-facing project contact to establish ownership. If an approval step remains, say release pending rather than calling the line available.
This is also the point to split a multi-site list. A record that ties each reel to its physical location and authorization status is more useful than a single project total that hides the underlying inventory.
- Owner and release authority
- Storage ZIP or actual location
- Access and loading facts
- Pending approval or return status
A public capital-program fact is not a stock record
The City’s FY 2026–27 adopted budget and five-year Capital Improvement Program totals $283 million.
That official context can make a documented contractor or distributor overrun scenario intelligible, but it does not show that any City-related material is available or that a particular seller supplied a project. The submitted balance and authorization evidence, not the public program, must support the offered line items.
Worked record: make the outdated number visible
Illustrative inventory example—not a purchased lot: Line OV-SV-02 has a part number photographed on its tag. The prior document lists more footage than the current record: two reels show 300 ft documented and 180 ft estimated. The item is uninstalled, but release is pending, so the line is not presented as a final available balance.
The workable next step is to attach photos to the two reel references, retain the original quantity in a source-document column, and ask the responsible owner to resolve release. A reservation or unresolved return remains a separate status, not an excuse to blend the figures.
