Overview: reconcile records to physical stock
A common mismatch occurs when an original project order or invoice lists footage that no longer matches the reels physically on site. The objective is to produce a current-balance column tied to physical reel IDs and to document which items are genuinely releasable now. Use the four-step workflow below to create evidence-backed inventory suitable for an inquiry.
This page focuses on availability and release approval for excess inventory in Lansing, not on construction type or multi-site logistics. If you cannot fully identify every reel, record the uncertainty and estimate the quantity basis rather than carrying original order footage forward as current quantity.
The City of Lansing says its Michigan Avenue Rehabilitation included road reconstruction, sidewalk replacement, traffic-signal modernization, and sewer and water-main upgrades. That is local context for a changed-scope record; it does not identify any offered cable, so the current reel balance and release authority remain the seller task.
- Freeze a physical inventory snapshot with stable line/reel IDs.
- Record per-reel continuous lengths and mark the quantity basis.
- Identify reserved or approval-pending material and name the release authority.
- Attach matching photos and document references for each line ID.
Step 1 — Freeze the current inventory snapshot
Walk the stock and assign a stable line ID to each reel or genuinely matching group. Do not reuse the original order footage as the current quantity. For each line ID, capture the required evidence fields: line/reel ID, manufacturer, part number, storage location, and current status.
If reels lack clear tags or jacket printing, give them a temporary line ID on a durable tag and note that the designation is pending. Record whether the designation came from a tag, jacket print, or other documentation.
- Assign permanent line/reel ID (visible on tag and in filenames).
- Record manufacturer and part number from tag or documentation.
- Note storage location and the current status (available, reserved, pending return).
Step 2 — Reconcile quantities by reel
Record each full reel, partial reel and cutoff separately, preserving per-reel continuous length and marking the basis as measured, documented or estimated. Required evidence includes reel count, continuous length per reel, quantity basis, and whether the item is full/partial/cutoff.
When you measure is not possible, document the method used to estimate lengths (visual gauge, reel diameter estimate, or records) and mark the quantity basis explicitly so buyers understand uncertainty.
Create a current-balance column tied to the line ID; retain the original project quantity in a separate column as background only.
- List each reel with continuous length and basis: measured, documented, or estimated.
- Distinctly flag cutoffs and partial reels so they are not aggregated with full reels.
- Keep original project footage only as a historical reference column.
Step 3 — Mark what is genuinely releasable
Identify stock reserved for another project, pending return, or awaiting internal sale approval. For every line ID, provide release status, reservation/return note, release authority, and an ownership note. Name the person or entity authorized to release items so inquiries can progress without assuming availability.
If you are unsure whether material is releasable, label it 'approval pending' or 'reserved' rather than offering it as available. That prevents the common mistake of presenting original invoice footage as current available quantity.
- Record release status and any reservation or return notes.
- List release authority by name and role (or mark pending if unknown).
- Attach owner/department note to clarify ownership or title questions.
Step 4 — Match proof to the list
Use the same line IDs in the inventory and in filenames for readable reel tags, jacket printing and representative condition photos. Required evidence items include tag photo reference, jacket-print photo reference, condition note, and document references that tie the physical item to records.
Photo examples should show the line ID tag next to jacket printing or the reel core so an external reviewer can verify the match. File names should use the line ID (for example: OV-LAN-07-tag.jpg).
Keep a document reference for any records used to establish a measured or documented length (packing slips, cutting logs, or warehouse receipts).
- Name photo files with the same line ID used in the inventory.
- Include at least one tag photo and one overview photo per line ID when possible.
- Attach any documents that support measured or documented lengths.
Handling unknown or incomplete inventory
If inventory is partially unknown, be explicit: state which fields are unknown and why, and give a best-estimate with a clear quantity basis. Example fields to flag include missing jacket printing, unreadable tags, or reels stacked without visible identifiers.
Do not convert unknowns into available footage. Instead, add an 'uncertain' flag and note how the uncertainty could be resolved (re-tagging, sample measurement, or owner confirmation). This honest approach speeds decision-making and avoids the mistake in the brief.
- Flag unknowns with 'designation pending' or 'length estimated' and explain the estimation method.
- Propose a simple next action to resolve each unknown (photo tag, measure a sample, or contact release authority).
- Keep original order footage as background only, never as a substitute for current-balance evidence.
