Reconcile the physical balance before listing it
Start with the inventory export or purchase record, but treat it as a locator rather than proof of what remains. Match each line to a physical reel, coil, or continuous cut length. Give that item an inventory line ID, note its storage site, and compare the current reel count with the older record. A reel that is missing, reserved, or awaiting return stays visible in the list instead of disappearing into a grand total.
For every remaining item, preserve the manufacturer, part number, readable jacket legend, and the basis for the quantity. Footage can be measured, supported by a tag or record, or estimated; those are different statements. If a number comes from an old invoice only, label it as an original reference until it has been reconciled to the material on hand.
- Use one current-balance line per reel, coil, or continuous piece.
- Keep measured, documented, and estimated footage visibly distinct.
- Record the storage site so a release record can be tied to the same item.
Separate why stock is available from whether it is releasable
A project overrun, distributor closeout, maintenance release, and facility change can all produce excess cable, but they do not answer the same release question. Put the release reason on the line with the reel and add a project or PO reference only as background. Then identify the person or department that controls release and state the approval status exactly as known.
Do not promote a pending line to available inventory just because it appears in a warehouse system. Mark it “release pending” or “reserved” and say what is unknown. That makes the practical decision clear: which identified reels can be discussed now, and which require an internal decision before they are presented as part of the lot.
- Keep project or PO reference separate from current footage.
- Name the release authority or label the authority unknown.
- Flag reserved, pending-return, and approval-pending stock on its own line.
Keep reel condition and product evidence attached to the line
Full reels, partial reels, coils, and cut lengths should not be merged merely because they came from the same job. Retain the reel ID, continuous footage, condition, and sealed/partial/cut status for each. A partial reel with estimated footage is a different record from an unopened reel with documented footage, even if the jacket printing appears to match.
Use the same reference in the inventory file, reel-tag photo, jacket-print photo, and any matching product sheet. A photo filename such as OV-WR-01-tag and OV-WR-01-jacket is more useful than a folder of unconnected images. If a tag cannot be read, say that directly and keep the item separate until a product record can be associated with it.
- Photograph readable tags and a legible jacket segment for each identified line.
- List reel condition and continuous footage beside the same reel ID.
- Do not combine a sealed reel with a partial reel without item-level evidence.
Use Warwick context without inventing a local lot
RIDOT describes the Airport Connector as the gateway to Rhode Island T.F. Green Airport and reports work on the Connector, Route 1/1A and Post Road sidewalks and pedestrian ramps in Warwick.
That is local infrastructure context only; it does not identify a seller, stock, or cable type. A contractor or distributor using this page should still document the actual product markings and reconcile the current balance before describing material as project-related surplus. The release record, not the project name, controls whether a reel can be included in a seller inquiry.
Illustrative current-balance record and incomplete items
Illustrative only — not a purchased Warwick lot: reference OV-WR-01; material is project-overrun feeder cable with part number on tag; quantity is two reels, 300 ft documented and 180 ft estimated; condition is uninstalled with release pending. The example shows a balance record, not an offer or a claim about a real inventory.
When the tag, physical count, or approval is incomplete, create an explicit unknown rather than copying an invoice total. Include the best available photo, vendor note, or last-handling record, identify its limits, and keep the uncertain item in a separate current-balance line. That preserves a workable review path without turning an estimate into a confirmed quantity.
