Reconcile the historical export to physical stock
Use the purchase order or inventory export as a starting reference, not proof of current quantity. For every line, record the original inventory reference, manufacturer or part number, physical reel or package ID, and the actual storage location. When a listed reel cannot be found, identify it as missing instead of retaining it in the offer total.
A stable physical ID prevents double-counting when similar reels share a part number. It also makes the photo set useful: a tag image and reel overview can be matched to the same line that appears in the current balance.
- Historical inventory reference plus a physical reel or package ID.
- Storage location for each current item.
- Missing stock separated from the offered balance.
Show the current quantity, not only the original order
List full reels, partial reels, cut lengths, and unopened packages separately. Show per-reel continuous footage and label every figure measured, documented, or estimated. An aggregate number can follow, but it should not erase how much of that number is in individual continuous pieces.
The central error is reporting invoice footage as the remaining quantity after material has been consumed or moved. Correct it by tying every current balance to an actual reel and a stated quantity basis, with condition and tag readability noted on the same line.
- Per-reel continuous length and reel count.
- Measured, documented, or estimated quantity basis.
- Full, partial, cut, or unopened status.
Separate offered, reserved, and approval-pending material
Set a clear status for each current line: offered, reserved for another project, or pending internal release approval. Name the release contact and, if available, the approval reference that supports the status. Do not treat reserved stock or an unapproved balance as part of the offered group.
For the defined offered group, provide photo filenames, actual site access notes, available loading information, and the earliest release date if known. If any of those fields are not known, state the gap and the contact who can clarify it; do not assume a transport or schedule term.
- Offered, reserved, or pending-approval status.
- Authorized contact and release reference where available.
- Photo, access, loading, and release-date fields tied to offered line IDs.
Keep local context out of the quantity claim
The City of Santa Maria says local industries include aerospace, communications, high-tech research and development, energy production, military operations and manufacturing. That is local business context, not evidence that a Santa Maria project has surplus cable or that any historical export is releasable. The physical count and release record remain the basis of a seller’s submission.
A candid reconciliation can still include unknowns. Flag estimated footage, missing reels, and pending authority on the relevant line, and preserve the original export reference for follow-up. This makes the record actionable without turning an old order into a claim about present availability.
- Original record retained as a reference, not a current balance.
- Unknown and missing values kept visible.
- Release authority identified before an item is presented as offered.
