Draw the boundary around material that is actually offered
Start with the latest inventory export or project order, then mark every line as offered, retained, reserved, pending return, or unresolved. Original purchase footage can remain as a reference column, but it should not be the current offer quantity. A release status beside each line is more useful than a large total with no boundary.
Where a project file has several order numbers, preserve them as background. The actual decision is whether the particular reel is present and can be released. Do not fold pending-return cable into the same subtotal as uninstalled material already cleared by its owner.
- Project or order reference.
- Offered line ID and current status.
- Reserved quantity and return status.
- Release approval or a clearly pending condition.
Walk the storage location against the list
For each export line, locate the physical reel, package, or continuous piece and assign a reel reference. Record the manufacturer or part number, the storage site, the current length, and whether the physical match is confirmed, uncertain, or missing. A line that cannot be found is a discrepancy, not an available quantity.
Use photos that share the inventory reference. If a tag is ambiguous, say so and describe the evidence basis for the length. This prevents a warehouse report from becoming a substitute for the material now on hand.
- One physical reel or piece per entry.
- Current length with its measured, documented, estimated, or unknown basis.
- Physical-match status tied to photo files.
- Unmatched lines kept outside the offered subtotal.
Keep the current balance at reel level
Full reels, partial reels, and cut lengths do not provide the same continuous footage. Keep their quantities separate and show the evidence basis for each. A current-balance column should show what remains after consumption, reservations, and pending returns rather than repeating the original shipment figure.
Daytona Beach Public Works lists engineering services including design, contract administration and inspections. That local fact makes project and contract references sensible background records for a seller’s reconciliation file, but it does not prove that an overrun exists or that a public entity owns the material.
- Original recorded footage retained only as reference.
- Reconciled current balance per reel.
- Net offered footage after exclusions.
- Photo filename and condition note matched to each reel.
Document authority and access without assuming terms
State who owns the offered material, who can authorize release, and the access or loading constraints at each storage location. Project or permit references may help explain why a record exists, but they do not establish that stock can be sold. Treat an unresolved owner or release question as a reason to keep the line out of the available subtotal.
If inventory is split between sites, use distinct location fields and do not merge their reel counts. The goal is a stable current record that can be discussed for this lot, not a promise about inspection, transport, pricing, or acceptance.
- Owner and release authority.
- Storage site and access constraints.
- Separate site subtotals where inventory is split.
- Pending items visibly excluded from offered footage.
Use one clear fictional current-balance example
The mistake is presenting an original invoice total as today’s sale quantity. The correction is a current-balance line tied to physical reel references, evidence basis, and release status. Unknowns stay on the list, but they are not silently converted into available footage.
Illustrative fictional inventory record: OV-DB-01; project-overrun feeder cable with part number on tag; two reels totaling 300 ft documented and 180 ft estimated; uninstalled; release approval pending. This is a record format, not a purchased lot or an indication that the material will be accepted.
- Use a distinct status for reserved, pending, and unresolved lines.
- Do not include an unlocated reel in net offered footage.
- Explain the next evidence needed to resolve a discrepancy.
