Start with today’s physical balance
A purchase order or warehouse export is a reference point, not proof of what remains. Walk the stored cable and assign a line ID to each reel, coil, or continuous piece. For every line, record the part number or readable jacket designation, current footage, and whether the footage is measured, documented, or estimated.
The specific risk in an overrun is a grand total that still includes cable returned to project stock, material held for another phase, or a partly used reel. Keep those states visible. A line can be included in the working list without being described as released for sale.
- Use a stable reel or line ID in the inventory, photo filename, and any project record.
- Show the current footage basis: measured, documented, or estimated.
- List full reels, partial reels, coils, and cut lengths as different forms.
Separate quantities that cannot be substituted
One total can conceal a material difference: two short pieces do not provide the same continuous length as one reel. Split a physical count from footage, and retain continuous length per reel even when several reels share the same product designation. Photograph the tag and a readable length of jacket printing for the exact line being described.
If a tag gives the original shipped length, do not repeat it as the current balance unless a record supports that conclusion. When the balance is only an estimate, state the estimate and the reason it remains an estimate. This is more useful than supplying invented precision.
- Keep original label footage separate from remaining footage.
- Match label and jacket-print photos to the same line ID.
- Flag missing reels rather than silently retaining them in the total.
Make release status a field, not an assumption
Record the owner, the person or role that can authorize release, the current approval status, and any internal milestone that remains. A project manager may know where a reel sits without being the person able to release it. Mark a pending line as pending instead of treating it as an available cable line.
The city context is limited but relevant to this workflow. The city Public Works page provides contractor, engineer/architect and private-development resources, including standards for city projects and private development. That supports a contractor or private-development documentation scenario; it does not identify a city project, cable lot, or buyer customer.
- Record owner and release authority separately when they are different.
- Use an approval-status field such as released, reserved, or pending.
- Keep any internal reference with the inventory line rather than only in an email thread.
Use a reel-level evidence packet
For each line, keep the manufacturer or designation, a photo of the tag, a photo of jacket printing, the quantity basis, and the release note together. A simple spreadsheet works when the same line ID appears in every file. It also makes an uncertain field easy to see rather than burying it in a general note.
Use the quote form to begin the discussion and email a readable inventory and photo set to saleselectricalbuyers@gmail.com when the file set is ready. Include the actual storage location and access notes with the record, but do not assume that a review establishes movement or sale terms.
- File names should repeat the line ID shown in the spreadsheet.
- Keep label photos and jacket-print photos as separate evidence when both are available.
- State storage access limits alongside, not instead of, product details.
Illustrative current-balance record
Illustrative inventory example—not a purchased lot: line OV-OKC-01 is a project-overrun feeder cable with its part number recorded from the reel tag. The record lists one reel at 300 ft documented and one partial reel at 180 ft estimated; the release field is pending. The values demonstrate how a current balance can preserve uncertainty without hiding it.
The common mistake is presenting the original invoice footage as the amount remaining while reserved and partial stock sits inside the same number. The workable fix is one current-balance line per reel or continuous piece, with an evidence basis and a visible release status.
- Example line ID: OV-OKC-01.
- Quantity: 300 ft documented plus 180 ft estimated on separate physical reels.
- Release: pending, not represented as available.
