Reconcile purchase history with current cable
An invoice, purchase order, or warehouse export can identify a product, but it can also preserve the footage that was ordered rather than the footage still on a reel. Start a current-balance sheet beside the source record. Give each physical reel or continuous cutoff an inventory reference, then compare the label, manufacturer part number, and remaining amount with the older entry.
When the record and the reel disagree, do not solve the difference by selecting the larger number. Keep both values: record the original quantity, the current quantity, and whether the current figure is measured, documented from a label, or estimated. A line that cannot be tied to a visible reel stays in the sheet as unknown rather than becoming part of the offered total.
- Retain the original record as background, not as the current balance.
- Use a separate inventory reference for every partial reel and cutoff.
- State the basis for each current quantity.
Keep reel balances separate from old totals
Group only cable that has the same confirmed specification, but preserve the reel count and continuous footage for each reel. One line may describe matching full reels when the tags and condition align; a partial reel belongs on its own line if its remaining length or evidence differs. Match photo filenames to the same inventory reference used in the balance sheet.
A common inventory error is to combine a documented full reel, an estimated partial reel, and an unlocated line from an old export into one figure. The correction is practical: retain individual quantities and status, show the tag and jacket marking where available, and identify the unsupported line as unknown. The list remains usable without claiming a precision it does not have.
- Reel ID and photo filename should match exactly.
- List continuous footage, not only aggregate footage.
- Keep documented, measured, and estimated amounts visible.
Draw a clear release boundary
The key seller decision is not simply whether cable appears on an inventory report. It is which identified lines are offered now, which remain reserved for a project, and which still need approval. Add owner, release authority, approval status, reserved quantity, and offered quantity to the record. A named site contact is useful only if that person can confirm the status of the specific line.
Keep pending lines in the inquiry if they help explain the broader inventory, but label them pending and exclude them from the amount offered. If release authority is unknown, say so. This approach prevents a reviewer from treating a planning list as a releasable cable lot and lets the seller update one status field rather than rebuild the inventory later.
- Mark each line offered, reserved, pending approval, or unknown.
- Identify the business role that controls release.
- Do not include held quantities in the offered total.
Use a project name only as local context
South Burlington’s Projects & Initiatives page lists the Bartlett Bay wastewater treatment facility upgrade, City Center/TIF work, stormwater projects, paving and other initiatives.
That city-level list can help a seller describe the background of a project-related overrun, but it does not identify cable, prove a quantity, or establish that any project material is available. If a project name appears in a record, pair it with the actual reel reference, markings, current-balance basis, and release status. The cable evidence—not the project label—carries the seller task.
- Name the actual storage location or ZIP in a private inquiry.
- Use a project name as context rather than a product description.
- Keep project records matched to the line they actually support.
Worked current-balance record
Illustrative example only—not a purchased South Burlington lot: OV-SB-17 is a feeder-cable line whose manufacturer part number is photographed. The old project export shows 1,000 ft. The current balance records two distinct reels: 300 ft documented on one tag and 180 ft estimated on a partial reel. The remaining export quantity has no matching reel and is shown as unknown.
The mistake in this example would be presenting 1,000 ft as a current sale quantity. The resolution is to retain the two individual reel entries, attach their photo references, mark one reel offered and the other release pending, and keep the unmatched balance out of the offered total. This is a record-format example, not a statement about a real lot.
- Reference: OV-SB-17.
- Current balance: 300 ft documented; 180 ft estimated; remaining export quantity unknown.
- Release: one reel offered; one line pending approval.
