Set the actual offered boundary
Begin with one row per reel, coil, or defined group of genuinely matching cable. Mark each row available now, reserved, pending project return, or awaiting release approval. The status is about what may be offered today; it should not be copied from an old purchase order or project closeout report.
Name the person or internal role that can authorize release and retain the approval reference when one exists. A line without physical confirmation or release authority is still useful to record, but it belongs in a pending column rather than in the available balance.
- Inventory reference and current location
- Availability status and authorizing role
- Reason for release and any reservation
- Whether the line is physically confirmed or still unlocated
Reconcile records to the physical reels
Compare the warehouse export or invoice with the actual reel tag and jacket printing. Record manufacturer, part number, current reel ID, and the remaining continuous length on the same row. An original footage figure can identify a product, but it is not automatically the quantity remaining after a project change.
Keep a discrepancy note when a reel is missing, a balance is shorter than the original record, or a tag cannot be read. State whether footage is measured, documented from a current tag, or estimated. This leaves a buyer able to evaluate the confirmed portion without treating an estimate as a settled quantity.
- Manufacturer and full part number or readable jacket designation
- Current reel ID matched to the inventory row
- Continuous length with measured, documented, or estimated basis
- Record discrepancy and the evidence needed to resolve it
Tie the evidence set to each reel
Use the inventory reference in image filenames and record at least the full tag, readable jacket printing, a reel overview, and visible condition differences. A picture of one good reel should not stand in for a different reel with a partial balance, damaged flange, or missing label.
Birmingham IEO says it manages city-owned properties, oversees industrial parks, supports workforce grants and conducts economic impact analyses. That statement is only local commercial context; it does not identify an available cable lot. The practical task remains matching each listed reel to its own evidence and release status.
- Photo reference tied to the same inventory line
- Full tag and jacket-printing images
- Overview showing reel condition and accessible ends
- Explicit note for missing photographs or unreadable markings
Keep reserved and unknown stock usable in the record
Do not delete a pending reel merely because it cannot be offered yet. Put it on a separate line with a status such as release pending, footage estimated, or reel unlocated, then state the next evidence needed. This prevents a buyer from confusing a planning list with a confirmed buying submission.
If full and partial reels are presented in one inquiry, preserve every reel-level length rather than replacing them with an aggregate. A two-reel total can be a useful summary, but the underlying rows must show which length belongs to which reel and why it is available.
- Separate available-now total from pending or reserved lines
- Do not merge full reels, partial reels, coils, and cut lengths
- Show the evidence gap for each unknown line
- Keep release approval separate from a general project record
Use a fictional balance record before sending the list
For a fictional illustration, an inventory row could read: OV-BHM-01; feeder cable with part number on tag; two reels, 300 feet documented and 180 feet estimated; release pending. It demonstrates that quantity basis and release status can coexist without claiming that either reel is currently offered.
The common error is presenting the original invoice total as the sale quantity while reserved or unlocated reels remain in it. Correct that error by adding a current-balance column, showing the basis for each value, and excluding every line that lacks physical confirmation or release authority from the available-now total.
- Illustrative record only — not a purchased Birmingham lot
- Reference: OV-BHM-01
- Quantity: 300 ft documented plus 180 ft estimated
- Status: uninstalled; release pending
