1. Reconcile the physical stock
Start with the inventory export or the original purchase record and walk every line across to the physical reels, packages or cut lengths on site. For each item, record the inventory line, the reel ID or tag number, the manufacturer or part number, the original order footage and the measured current quantity.
Note and document any discrepancy between the original quantity and what remains. Discrepancies should be logged as a positive field, not corrected by assumption. If an original invoice shows 500 ft but a tagged reel and a measured count show 320 ft, mark 320 ft as the current balance and record the discrepancy as 180 ft with the evidence basis.
- Required evidence fields: inventory line, reel ID, manufacturer/part number, original quantity, current quantity, discrepancy
- Use stable identifiers (inventory line + reel ID) so photos and exports can be cross-referenced later
2. Preserve specification and length
Group only genuinely matching products. Keep the footage and condition of every full reel, partial reel and cut length visible in your records. Identify cable designation, conductor metal/size and whether the item is a full reel, partial reel or a cutoff.
When cataloging, supply the reel count and continuous length per reel rather than rolling cutoffs into a single aggregate footage line. That prevents misrepresentation where a single full reel is reserved and partials are available.
- Evidence fields to include: cable designation, conductor metal/size, reel count, continuous length per reel, full/partial/cut, quantity basis
3. Explain why it is surplus and note reservations
State the surplus reason explicitly: project overrun, distributor stock, maintenance inventory, or closeout. Record whether any portion is reserved, pending return, or earmarked for another project. If a portion is reserved, do not describe it as available.
For every reserved or pending quantity, record the amount, reason, and known release status. Keep it outside the offered balance until the seller can document otherwise; a historic project record is not a current availability record.
- Required evidence fields: surplus reason, reserved stock, pending return, storage condition, release status
4. Match photos, ownership and release authority
Use photo filenames and stable references that match the inventory line and reel ID. Capture tags, part numbers and any visible markings that confirm the manufacturer/part number. Provide photo references that can be matched to the inventory export.
Identify the owner and seller-controlled release authority, then state the requested timetable and storage-location details that affect the discussion. If authorization is pending, retain the item in the inventory but mark its release status as pending rather than calling it available.
- Evidence fields to include: photo references, ownership, release authority, storage location, requested timetable
Public project listings do not clear stock
The City Utilities—Construction & Engineering page links to a Capital Improvement Program and advertised projects/bid results.
That city page is useful context for a project-document workflow only. It does not show that a seller owns a lot, that original order footage still remains, or that any material is cleared for sale; those points must come from the seller’s current record.
- Use a seller-controlled inventory line, physical reel reference, and release-status field for every offered item.
5. How to handle unknown or incomplete inventory
Use a clearly fictional example record to show the format for reference, description, quantity, status, and evidence. The example should make a discrepancy, pending-release amount, and photo reference visible without being mixed into the real inventory.
For incomplete records, separate the lines that have a current balance and seller-controlled release information from lines that remain estimated or pending. That preserves a workable offered list while making unresolved quantities explicit for a later lot-specific discussion.
- Practical actions: label estimated footage explicitly; supply the exact evidence needed to convert an estimate into a verified current quantity
6. Illustrative record and how to present it
Provide an example record in the same format you will use for all lots. For clarity, include the illustrative fictional example from your records as a template: reference, description, quantity, status and evidence. That lets reviewers and the release authority see the exact format and the evidence attached.
Do not mix the example with real lot data. Use the example to show how discrepancies, pending release amounts and photo references will be presented, and how release authority will be recorded.
- Example format fields: reference, description, quantity, status, evidence
