Reconcile the current balance, not the original order
A purchase order, ERP export, or project schedule can identify a product, but it may show the amount originally issued rather than what remains today. Match each inventory line and part number to a physical reel, box, or continuous piece. Record a current balance for that physical reference and note any discrepancy between the record and the material on hand.
Give the quantity a basis: measured, documented on a current tag, or estimated. An estimate is still useful when labeled with its method and uncertainty. It should not be combined with documented footage and presented as one certain remaining total.
- Match inventory line and part number to a physical reference.
- Record original-record discrepancies instead of hiding them.
- Keep measured, documented, and estimated balances distinct.
- Attach a photo reference and a document reference to the same line.
Show availability states before grouping reels
Create separate entries for full reels, partial reels, and cut lengths. Then show whether each entry is sale-released, reserved for another job, subject to a pending return, or waiting for internal approval. This is a release decision, not a cable classification decision, so it remains distinct from the industrial-cable page’s construction workflow.
A reel may be physically present but not available to offer. Keep that condition visible with a status field and, when known, the role responsible for release. Do not make approval-pending inventory look immediately available merely because it appears on an old warehouse list.
- State form: full reel, partial reel, or cut length.
- Record continuous length per item, not only an aggregate balance.
- Mark reserved, pending-return, and release-pending states separately.
- Identify the seller-side role that can change release status.
Describe why the material is excess and how it is stored
For each line, state whether it is project overrun, distributor stock, maintenance inventory, or previously used cable. Add observed condition, storage exposure, and service history where known. This helps a buyer understand the record without turning a project name or an old invoice into a claim about current condition.
If a tag is missing or the origin is uncertain, retain the physical reference and explain the gap. It is better to say that ownership or storage history needs confirmation than to infer a release path from where the reel happens to be stored.
- Use a specific surplus reason for each inventory line.
- Keep unused, partial, and previously used material distinct.
- Describe visible reel or packaging condition without making a performance claim.
- State indoor, covered, or exposed storage only when known.
Baltimore context without assuming a city-held lot
Baltimore DPW lists current work including large water-main condition assessment, on-call utility engineering and conduit-infrastructure design projects.
The fact provides local project context only. It does not establish that Baltimore DPW owns, offers, or endorses any cable inventory. A seller with project-related surplus still needs a current physical balance, owner or release documentation, and reel-level photos before a buying discussion can address the actual material.
- Treat public project information as background only.
- Use actual inventory records to establish what remains.
- Keep ownership and release evidence with the offered line.
- Do not infer cable availability from a public works project.
Correct the invoice-footage mistake with a fictional record
The recurring mistake is to present original invoice footage as the amount remaining and treat every listed reel as sale-ready. The correction is a current physical balance with a clear quantity basis plus explicit reserved and release-pending flags. That record can be reviewed without hiding a discrepancy or an administrative hold.
Illustrative fictional example—not a purchased lot: OV-BAL-02 is project-overrun feeder cable with the part number on the reel tag; two reels show 300 ft documented and 180 ft estimated; uninstalled; release pending. The example separates physical quantity from authorization and does not state that the inventory will be purchased.
- Keep 300 ft documented separate from 180 ft estimated.
- Mark the illustrated release state as pending.
- Link the part number to the reel-tag photo.
- Do not treat the invoice total as the current balance.
