Reconcile the physical stock before the total
Match each inventory export, purchase record, or project list to the physical reel, coil, or continuous piece at its current storage site. Use a stable line reference, retain the part number or tag wording, and note discrepancies. An original order quantity can identify the material, but it is not evidence of today’s remaining footage.
Treat full reels, partial reels, coils, and cut lengths as separate records. State whether each remaining length is measured, documented, estimated, or unknown. A grand total should never hide the number of continuous pieces or the sites where they are held.
- One row per reel, coil, or continuous piece
- Current footage basis on every row
- Part number or tag wording and storage site
Show why the stock is available and who can release it
State the surplus reason for each line, such as project overrun, warehouse excess, or closeout, without using that label as a substitute for material identity. Record owner or department information when known, identify the person who can authorize release, and flag reserved or approval-pending stock.
A lot can be described accurately even when release is not final. Mark the pending status in the line rather than treating it as available. This separates the commercial decision to release stock from the task of identifying the cable and counting it.
- Surplus reason
- Owner or department when known
- Release authority
- Reserved or pending status
Make photos and locations reconcile
Use the same line or reel reference in the photo filename and the inventory. A useful set includes readable tag or jacket evidence, a reel overview, and visible packaging or condition differences. If a photo represents only one reel, do not use it as proof for every similar entry.
For each site, note location, access restrictions, available loading information, and any requested timetable without assuming a freight or collection arrangement. Multi-site stock can be included in one inquiry when the rows remain site-specific.
- Photo reference matches the inventory line
- Readable identification and reel overview
- Location, access, and loading facts per site
Use local context only as context
Gilbert’s General Plan guides physical, economic and social development decisions over 20+ years and covers growth, transportation, water resources and public facilities. It does not show that any project created surplus cable or that a particular Gilbert inventory is available. Its narrow relevance is the need to reconcile a project or facility record with the physical, current material before describing it as a sale-ready lot.
The controlling seller facts remain the current reel count, remaining length, storage site, condition, and release status. Keep those facts in the line item rather than replacing them with a broad project description.
- Current physical count
- Per-reel length
- Storage site
- Release status
Worked lot row and incomplete records
An illustrative row can read: OV-GIL-06; project-overrun feeder cable; part number on tag; two reels; 300 ft documented and 180 ft documented; uninstalled; Site A; release approval pending; loading equipment unknown. It shows both current evidence and unresolved facts.
If a reel has no readable tag or its present location is uncertain, retain the photo, state the last known site and the unknown field, and avoid blending it into a documented total. That correction prevents an old invoice balance from becoming a misleading available quantity.
- Illustrative record keeps quantities separate
- Unknown location or loading fact stays explicit
- Old invoice total is not substituted for current stock
