Start with the current reel balance
A purchase order or inventory export is a useful lead, but it may include material already issued, reserved for another job, waiting on a return, or no longer present. Open a working list with one reference per reel or genuinely matching package. Match each reference to the item in storage before calling it available.
For each line, record the manufacturer and part number or jacket legend, storage location, reel type, and availability status. Use a separate status such as available, reserved, return-pending, approval-pending, or count not completed. That distinction lets a seller offer the real balance without implying that every historical line can be released.
- Keep original purchase quantity in a reference column, separate from current remaining quantity.
- Label footage as measured, documented from a current record, or estimated.
- Keep a reserved reel on its own line instead of subtracting it silently from a total.
Keep material form and specification visible
Full reels, partial reels, coils, cut lengths, and previously used cable should not be collapsed into one project total. Record the continuous length for the particular reel or piece, then retain its condition/history and quantity basis. A combined number can hide the difference between one long reel and several short pieces.
Where several reels carry the same designation, retain individual reel identifiers and photo references even if they are grouped for reading. If conductor metal, size, voltage marking, or visible condition differs, split the group. Do not use a similar reel to fill a missing marking on another line.
- Record reel ID, product designation, conductor metal, size, and marked voltage.
- State whether each line is full, partial, coiled, cut length, or previously used.
- Match photo filenames to the same reel reference used in the inventory.
Vacaville context does not identify a seller lot
Solano EDC reports 5.7 million square feet of industrial, R&D and manufacturing space across three Vacaville business parks. That setting can explain why a seller may be reconciling commercial stock or a project balance, but it does not establish the type, ownership, or availability of any offered cable.
Use the local context only as background. The sellable record still needs the reel’s actual marking, quantity basis, storage location, and the party who can release it. A public project or business-park reference is never a substitute for those seller-provided facts.
- Use source context as background only.
- Use reel records and release authorization to describe the offered material.
- Leave an unconfirmed field marked unknown rather than borrowing an assumption.
Resolve release gaps before presenting the balance
Identify the owner or role that can authorize sale and state whether approval is complete, pending, or unknown. Add practical access limits, such as separate warehouse areas or scheduled gate access, as facts for a later logistics discussion rather than as a movement commitment.
The common record error is reporting original invoice footage as current available quantity while a reserved reel remains inside the count. Correct the list by counting the current reels, preserving the status of each line, and showing whether the footage was measured, documented, or estimated.
- Owner or release authority.
- Approval status and release date, if known.
- Storage location and access constraint.
- Current availability status for every reel.
Worked balance record and unknowns
Illustrative fictional inventory record — not an actual or purchased lot: OV-VV-01 is a reel with its part number copied from the tag. The list shows two reels: 300 ft documented and 180 ft estimated. One is uninstalled and one remains release-pending. The record does not convert the estimate into a confirmed total.
If a tag is missing or a reel cannot be counted yet, keep the item on a separate unknown line. Attach the available inventory reference and a readable image when possible, explain whether the gap is quantity, identity, or approval, and update only that field when new evidence is found. This preserves the original record while making the uncertainty useful.
- Example reference: OV-VV-01.
- Quantity: 300 ft documented plus 180 ft estimated.
- Status: one reel release-pending.
- Unknowns stay visible rather than being folded into an available total.
