Reconcile the physical balance before listing it
Start with the reel, box, or continuous piece rather than the purchase order. Give each item an inventory line or reel ID, record the manufacturer and part number shown on its tag or jacket, and write the current remaining footage beside it. An original order quantity is useful history, but it is not a current quantity claim.
For every balance, state its basis: measured, documented, or estimated. A recent count sheet may support a documented balance; a partial-reel visual estimate should stay labeled as an estimate. If an export says 1,000 feet but the physical inventory shows two partial reels, keep the discrepancy visible instead of rolling it into a convenient total.
- Inventory line or reel ID
- Manufacturer and part number
- Current footage for each physical item
- Measured, documented, or estimated basis
Separate sale status from the material description
Create distinct lines for full reels, partial reels, unopened boxes, and cut pieces. Then add a separate release-status field: available, reserved, return-pending, owner hold, or release pending. A matching part number does not make items interchangeable when one is committed to another job or controlled by a different owner.
The practical error is treating every record in a project export as immediately sellable. Resolve it by showing the name or role of the authorizer, the storage location, and the outstanding approval if one exists. A buyer can then review the cable record without mistaking an internal hold for an available quantity.
- Condition and packaging status
- Release status
- Owner or authorizer
- Actual storage location
Make the evidence follow the row
Use the same ID in the spreadsheet, reel-tag photo, jacket-print photo, and any supporting document. A row such as OV-BIL-07 should point to its own photos and evidence, not to a representative reel from another part of the job. Include a readable designation and note which image or document supports the footage figure.
If two reels share a specification, retain both physical references and their individual balances. This keeps a documented 300-foot reel distinct from an estimated 180-foot reel and prevents a combined total from disguising the weaker evidence behind one part of the line.
- Photo filenames matched to line IDs
- Readable tag or jacket designation
- Quantity evidence for each item
- Document reference for the record or release
Use a worked record to expose unknowns
A fictional record can show the level of detail that prevents an overrun from being misdescribed. Example: OV-BIL-07; project-overrun feeder cable with part number on tag; two reels, 300 feet documented and 180 feet estimated; uninstalled; release pending. The example is a format only, not a report of a real lot.
If a box is in a locked area or a reel cannot be checked, keep it in a separate unknown line. State what is missing—tag photo, balance count, or release approval—and do not add its presumed footage to the confirmed quantity. That makes the next record-gathering task clear without asserting a sale outcome.
Keep the Billings reference proportionate
The City of Billings identifies the East Billings Urban Renewal District as an east-end industrial area, with boundaries extending toward the city/county boundary.
That city fact provides limited context for an east-end industrial area; it does not identify any seller, project, cable type, or stock. The useful local application is simply to keep project records and physical inventory matched at the actual storage point rather than relying on broad location assumptions.
Submit a stable overrun inventory
Before submitting a quote request, freeze the list long enough to distinguish historical order data from the present balance. Include the material description, each current quantity and its basis, photo references, storage location, and release status. Keep any deadline as seller context rather than treating it as an agreed collection arrangement.
The focused decision here is current availability after a project change. It is not a multi-site logistics page or a technical construction-identification page: the core question is whether the original record, physical balance, and authority to release the same item now agree.
