Set the offered boundary before listing footage
Start with an inventory snapshot, then give every line a status: available, reserved, pending return, or not offered. A line should also identify the storage site, the person or entity with release authority, and whether its quantity comes from a measurement, an existing record, or an estimate. This separates a real offerable balance from a warehouse report that still includes future project stock.
Do not turn a reservation into a quantity problem. If a reel is earmarked for another job, keep it in a non-offered group with its status and the reason for the hold. The available group can then show a current subtotal without implying that the held material is part of the request.
- Use one current status for each physical reel or continuous piece.
- Keep available, reserved, pending-return, and not-offered lines distinct.
- Record the release contact or state that the contact is unknown.
Reconcile the record to the physical reel
Match a purchase order, inventory export, or project record to the reel tag and the cable that is actually present. Capture manufacturer, part number, reel ID, original quantity, and current quantity basis. If the original label reports 1,000 feet while the remaining length is different, preserve both numbers and label the first one as the original reference rather than the current balance.
A missing tag does not justify a guessed specification. Create a separate line, note which marking is unreadable, attach a close image and a wider reel image, and call the footage estimated only if the basis is stated. This gives a reviewer a usable question to resolve instead of a confident-looking but unsupported line.
- Tie the reel ID to its tag and jacket images.
- Keep original quantity and current quantity in separate fields.
- Label footage as measured, documented, or estimated.
Preserve length and condition item by item
Full reels, partial reels, coils, and cut lengths should not share one total merely because their part numbers look alike. List the continuous length for each item, its condition category, and a photo reference. Two short pieces do not create the same record as one long reel, and a partial reel cannot be represented by the footage printed on a new-reel label.
The likely inventory error is carrying invoice footage forward as the sale quantity after a portion has been assigned elsewhere. The workable correction is a reel-by-reel balance: retain the source record, state the current evidence, and exclude reserved or pending-return lines from the offered balance.
- Use one line per actual reel or continuous piece.
- Keep uninstalled stock, partial reels, and cut lengths visibly distinct.
- Place unknown condition or footage in a labeled field, not in a total.
Use Denver context without treating it as inventory evidence
Denver DOTI lists current transportation and infrastructure work including 8th Avenue and Bannock Street bridge repairs that include electrical repairs, as well as streetscape, corridor, signal and public-infrastructure projects.
That public project context does not identify material for sale, a customer, or a buyer relationship. It is relevant only as a reminder that a contractor closeout should document its own reel IDs, current balance, release status, and records instead of relying on a project name to establish what is available.
- Name the actual inventory reference rather than only the project.
- Keep release documentation with the matching item.
Worked surplus record: balance first
Illustrative inventory example—not a purchased lot: OV-DEN-01 records project-overrun feeder cable. One reel is listed as 300 feet documented and available; a second is 180 feet estimated with release pending. The example is fictional and shows why the footage basis and release status belong beside each reel rather than in a single grand total.
Before sending an inquiry, check that the available lines include tag or jacket photos, storage location, current footage basis, and the release contact. Missing details may stay marked unknown; the important step is not silently treating unknown or held material as present, releasable stock.
- Example reference: OV-DEN-01.
- Fictional quantities: 300 ft documented and 180 ft estimated.
- Separate pending-release material from the current offered balance.
