Reconcile the current reel balance
Use the purchase order or inventory export as a reference, then match every listed line to the reel, spool, box, or continuous piece that is physically present. A completed project can leave a partial reel beside a full reel with the same part number, and one of them may already be earmarked for another use. Record the observed reel ID, storage area, and current status instead of carrying the historical total into the offered inventory.
The key decision is whether a reel is available now, reserved, or approval-pending. Keep those statuses visible even when they share a specification. This avoids the common mistake of advertising a purchase-order total that includes material consumed, returned, or retained for another project.
- Match every historical line reference to a current reel or package.
- Use separate status values: available, reserved, approval-pending, or unknown.
- Record the physical storage area and any access limitation for each line.
Separate usable lengths from the original order
List full reels, partial reels, and short cut lengths on separate lines. For a reel, report a single remaining continuous length and say whether the figure is measured, documented on an existing record, or estimated. A sum of several cut pieces is not the same inventory as one continuous reel, even when the aggregate footage is similar.
If an estimate is the only available figure, retain the estimate and its basis instead of inventing precision. For example, note that a partial reel is estimated from remaining wraps, while a documented balance comes from an existing count. This gives a reviewer a clear reason for any difference between the tag quantity and the current balance.
- Keep full reels, partial reels, and cut lengths in distinct inventory lines.
- State continuous footage and label it measured, documented, estimated, or unknown.
- Do not combine reserved material with released material to create one available total.
Capture identity before assigning availability
For each reel that is offered, photograph the readable tag and jacket legend and transcribe the manufacturer, part number, conductor metal, size, conductor count when shown, and marked voltage. A project nickname or invoice description can remain useful background, but it is not a replacement for the product record on the material itself.
When a tag is missing, retain the item as an unknown-specification line and attach the best available marking photographs. Do not copy a neighboring reel description onto it. Keeping the unknown line separate preserves the option to clarify it later without overstating what the seller has verified.
- Match photo filenames to the reel ID or inventory reference.
- Transcribe the full readable designation rather than shortening it to a project name.
- Mark a missing tag or unreadable field as unknown.
Use Broomfield context with the right limits
The city's history identifies Interlocken Business Park and the 96th Street/US 36 interchange as catalysts for southwest Broomfield retail and office development, and later names Arista, Anthem and Anthem Highlands infrastructure development. That history is only context for a hypothetical commercial closeout; it does not identify a current project, a customer, or cable available for sale.
For a private project-overrun list, the useful local step is still the same: document the actual reel, its present status, and the person who can authorize release. The historic development context cannot establish a cable type, remaining footage, or a purchasing outcome.
- Identify the owner of the offered inventory.
- State the role or office that can authorize release.
- Describe release restrictions without treating them as resolved.
Worked record for an approval-pending reel
Illustrative fictional record—not a purchased lot: reference OV-BR-01; fictional feeder-cable reel; 300 ft documented; release status approval-pending; tag photograph OV-BR-01-tag.jpg; storage area warehouse rack B. The part number on this sample is intentionally left unknown until the fictional tag is read.
This format fixes the faulty record that says an old order contained 2,000 ft and therefore all 2,000 ft is sellable. A real list should replace that historic figure with the quantity and status of each current reel, then keep any unresolved approval item visible rather than representing it as released.
- Example quantity: 300 ft documented on one fictional reel.
- Example unknown: part number pending a readable tag photo.
- Example status: approval-pending, not available.
