Design the inventory around traceable lines
The City's five-year Capital Improvement Program includes water-main replacement, sewer repairs, facility-system upgrades, traffic safety improvements and street rehabilitation; it is organized into eight capital program areas. The range of city project categories is local context for a seller sorting a closeout, not evidence that any listed reel belongs to a particular project or is available for sale.
Assign one line reference to each reel or to a genuinely identical group, and repeat it in inventory rows, photo filenames, and matching documents. Add manufacturer, product designation, metal, size, marked rating, reel count, and continuous footage for that exact line. A grand total cannot replace these fields.
- Stable reel or line reference
- Photo and document filename matched to the line
- Per-reel specification and continuous footage
Group locations without losing product differences
Keep different yards, rooms, racks, or secured areas in distinct storage groups. For each group, record access limits, known loading resources, and the condition differences that apply to its reels. Do not use one photo or one site note as proof for a product that is stored somewhere else.
Within each location, maintain one row per reel or continuous piece where specifications or lengths differ. Identical grouping is appropriate only when labels, construction, condition, and quantity basis genuinely match.
- Storage group
- Access restriction
- Loading information
- Condition note by reel or group
Map release scope alongside each group
State whether the seller is describing one combined lot or defined groups, then identify the owner or release-authority role for each group. If release status is unknown for a site, say so. Do not treat one contact as blanket authority for unrelated storage areas.
The release record must remain separate from an inventory total. It is a seller-provided fact used to organize discussion, not an acceptance decision or a commitment on inspection, freight, payment, pickup, or timing.
- Offered lot grouping
- Owner or release-authority role
- Known release status
- Seller timetable if the seller has one
Protect unknown lines from the confirmed subtotal
An untagged reel can remain in the inventory if it has its own reference, photos, and clearly marked unknown fields. Keep it out of a subtotal labeled as fully identified. The next action may be to find a matching record or confirm a measurement, but the uncertainty should travel with the same reel reference.
The common mistake is one grand-total footage number spanning different cable constructions and two locations, supported by one photo and one release contact. The correction is line-by-line traceability: correct photo, specification, condition, site, and release facts for each group.
- Unknown specification or footage noted per line
- Confirmed and unconfirmed quantities not merged
- Correct release contact tied to each group
Worked fictional multi-site record
Illustrative inventory example—not a purchased lot: BL-FUL-01; product designation recorded; one reel, 500 ft documented; Site A; release role identified. BL-FUL-02; different reel, 90 ft estimated; Site B; release authorization unknown. Each fictional line keeps its location and quantity basis visible rather than hiding both inside a total.
If the lot will only be offered in groups, record that grouping before submitting the list. A reviewer can then ask about the actual boundaries of each group without treating a combined figure as a promise that every reel is available together.
- Fictional example uses two site-specific lines
- Estimated and documented footage remain distinct
