Start with the current cable balance
A purchase order or warehouse export can identify an original cable order, but neither proves what remains. Create one line for every physical reel, partial reel or continuous cut length. Keep the original quantity in a historical column and place the measured, documented or estimated balance in a separate current-balance column.
The city reports 43 new 2024/25 Capital Improvement Program projects totaling approximately $35 million. That is local context for why a contractor may need an overrun record; it does not identify a cable type, an available lot or a buyer commitment. The line-item evidence still controls the buying discussion.
- Inventory line ID tied to the original record
- Manufacturer and part number exactly as marked
- Original quantity kept separate from current balance
- Discrepancy note for each missing, consumed or unmatched reel
Separate release states before submitting
A full reel, a partial reel, a cut length, reserved stock and approval-pending material are different availability states. Do not let a total-footage summary hide that difference. Give each row its own status and identify the role that can authorize release where authorization is still pending.
This is a current-availability task, not a construction-classification exercise. A marked reel can remain in the record even when it is not yet available. Label it reserved or release pending rather than calling it offered, and update only when the seller has authority to do so.
- Continuous footage per reel or cut length
- Full, partial or cut-length condition
- Available, reserved or release-pending status
- Release-approver role and known access constraint
Make the balance auditable with photos
Use a stable reel ID in the spreadsheet, the photo filenames and any supporting documents. For each distinct specification, include a readable tag image and a jacket-marking image. State whether the current footage came from a measurement, a retained record or an estimate; an estimate is useful when it is labeled rather than presented as a fact.
When an export lists more footage than the physical count supports, do not erase the conflict. Keep the historical figure, list the documented reels, and add a discrepancy note such as “two reel references not located.” That gives the buyer a defined record instead of an inflated total.
- Reel tag photo and jacket-marking photo
- Photo filename that repeats the inventory line ID
- Quantity basis: measured, documented or estimated
- Condition note for exposed ends, damaged packaging or unknown storage
Handle unknowns without overstating the lot
If a reel has no readable marking, give it a temporary reference and list what is genuinely known: visible construction, apparent reel condition, approximate footage basis and photos. Do not transfer a neighboring reel’s part number or size into that row. An unknown field is more useful than a confident but unsupported specification.
Likewise, a pending release does not need to disappear from the inventory. Keep it separate from material currently offered, describe what confirmation is needed, and avoid making transport or timing assumptions while the seller’s own release question remains open.
- Unknown product fields explicitly marked unknown
- Unverified remainder retained as history, not current availability
- Pending next action such as re-tagging, measurement or release confirmation
- Site-access limitations noted only where known
Worked overrun record for a buying review
A concise record gives the purchasing review a stable starting point. The example below is fictional and does not represent a purchased lot. Its purpose is to show why the original order, the present balance and release status must be separate fields.
Send the record with matching images and a reachable seller contact. An inquiry is not an acceptance, offer, payment or transport agreement; those terms are considered only for the identified lot. Keeping the current balance intact makes that later conversation clearer.
- Illustrative inventory example—not a purchased lot
- Line OV-HB-07; feeder cable with part number on tag
- Current balance: two reels, 300 ft documented and 180 ft documented
- Status: uninstalled; release pending
