Treat a project reference as context, not proof of stock
Weber County's official Local Transportation Funds gallery lists an Ogden City 26th Street (Phase 1) project.
That public listing is a useful local example of why project documentation can exist, but it does not show cable type, ownership, or remaining material. For a surplus inquiry, the actionable evidence is a physical reel or package matched to the current record, not the fact that a project appears in a public gallery.
- Keep the project name in a source or background field.
- Use a reel or package ID as the evidence link to the material.
- Do not turn an original purchase quantity into a current balance.
Reconcile the export to the physical inventory
Begin with an inventory export, purchase order, or warehouse list, then walk the physical stock. For each line, record the line ID, part number, physical reel or package ID, export quantity, current balance, and a discrepancy note. Mark material as missing, consumed, reserved, unlocated, or present instead of deleting awkward entries from the worksheet.
This task has a narrower purpose than a general cable description: it answers which part of the recorded order is physically present now. A reviewer can understand an incomplete list when the gap is visible; a copied export with no reconciliation cannot show what remains.
- One record for each full reel, partial reel, box, or distinct cutoff.
- Keep a photograph or tag filename with the physical reel or package ID.
- Use present-tense status fields such as present, reserved, unlocated, or pending approval.
Preserve per-reel quantities and the reason for release
List full reels, partial reels, boxes, and cutoffs separately. Record continuous footage per reel and label the quantity as measured, documented, or estimated. A total drawn from several short pieces is not the same as a single continuous length, so do not combine them to make the lot look simpler.
Add the surplus source—such as project overrun, warehouse excess, maintenance stock, or closeout—along with the manufacturer, photo reference, and storage condition. These fields explain why the item is in the worksheet without asserting that it is authorized for sale.
- Current physical balance by reel or package.
- Full, partial, box, or cutoff status.
- Continuous footage and its measurement basis.
- Manufacturer tag or readable marking matched to the inventory line.
Keep a release gate visible
Reserved material, return obligations, internal approval, and site sign-off are separate from the physical count. Record the reserved status, return obligation, approval status, release authority, and the seller’s requested timetable. If approval is pending, list the line as unavailable pending approval rather than adding its footage to the released balance.
This is a documentation step, not a promise that a reservation will clear or that a lot will be purchased. It simply prevents an inquiry from combining material that is physically present with material that can actually be offered.
- Name the release authority only when the seller can provide it.
- State pending or unknown instead of guessing an approval date.
- Retain reserved lines in the worksheet with an explicit availability status.
Worked fictional surplus-record example
This example is fictional and not an actual or purchased Ogden lot. It demonstrates an honest record with one documented balance, one estimate, and an unresolved return decision. It should be copied as a field structure, not read as a claim about local inventory.
Example: Line OG-OV-12; feeder cable with manufacturer tag photographed and part number pending; two partial reels, 300 feet documented and 180 feet estimated; source uninstalled project overrun; one reel reserved pending a project-return decision; release site approval pending. The worksheet retains the reserved reel but excludes it from the available balance.
- Use a discrepancy note when export footage exceeds the physical count.
- Keep part number pending rather than borrowing a similar product number.
