Reconcile what is present, not what was ordered
Start with the physical reels, coils, and boxed cable that can be located today. Assign an inventory reference, then compare it with the purchase order or warehouse export. Record the manufacturer, part number, current reel count, remaining continuous length, and whether that length is measured, documented, or estimated. Keep the original quantity in a history field; it is not the quantity offered for review.
A common error is carrying an invoice total into a sale list after material was issued, returned, reserved, or partially used. Resolve each difference beside the affected reel. If a length cannot be confirmed, state “unknown” or “estimated,” explain the basis, and do not turn an old reel label into a current balance.
- Use one current-balance field for each physical reel or coil.
- Keep order quantity and current available quantity in separate columns.
- Mark the basis for every footage figure: measured, documented, estimated, or unknown.
Do not mix full reels, partials, and cut pieces
A full reel, a partial reel, a coil, and a group of cut pieces are different inventory records even when their jacket markings look alike. Give each item a reel ID or line ID and describe its status, specification group, and length. Group only products that truly match; preserve each reel’s own length and condition in the backing list.
This separation matters when a seller has one intact reel and several short remnants. Reporting one combined number hides the continuous lengths that exist. Photograph the tag, readable jacket printing, and the reel overview under the same reference used in the list so the record remains traceable.
- Record full, partial, coil, or cutoff status on every line.
- Key tag, jacket, and overview photographs to the same reel ID.
- Keep an unmeasured partial separate rather than adding it to a documented total.
Make release status visible before discussing the lot
For each line, identify the owner, the person or role able to authorize release, reservation or return status, and any release note. A reel awaiting an internal decision may still be worth documenting, but it should not be presented as currently available. Use a plain status such as “release approval pending” rather than implying that an internal authorization exists.
This is the practical distinction between a useful surplus inquiry and a list of possible inventory. It lets the review focus on reels that are actually available while preserving a separate record for items with unresolved ownership, project-return, or approval questions.
- Name the release authority or mark it unknown.
- Keep reserved and pending-return items out of the available subtotal.
- Attach a release note to the reel reference, not only to the overall lot.
Use local context only to improve the handoff record
The City of Federal Way describes the city as between Seattle and Tacoma, with direct access to Interstate 5, proximity to Seattle-Tacoma International Airport and the Ports of Seattle and Tacoma, and access to State Route 18 and regional transit. That context is relevant only to recording the actual storage location and access limits for an identified seller lot; it does not identify cable, establish demand, or describe a transaction.
For the review, provide the location privately through the inquiry process along with reel dimensions, documented weight basis if available, access restrictions, and any on-site loading information. Those facts belong with the current inventory record, not with the old purchase-order total.
- Describe the actual storage site and access constraints.
- State whether dimensions and weight are documented, estimated, or unknown.
- Keep logistics facts attached to the reconciled reel list.
Worked format for a pending-release reel
Illustrative only — not a purchased lot: reference FW-OV-07; material project-overrun feeder cable with the exact part number recorded; quantity two reels, 300 feet documented and 180 feet estimated; status uninstalled with release approval pending. The example has two quantity bases, so it should not be reduced to one asserted available total.
The resolution is a current-balance entry for every reel, with the original invoice quantity retained only as history. If the release contact or remaining footage is unknown, leave it unknown and identify the next record or photograph that could clarify it.
- Reference: FW-OV-07.
- Quantity: 300 ft documented; 180 ft estimated.
- Status: release approval pending.
