Name why the cable is available without using that label as a specification
Start each group with an availability reason: project overrun, distributor excess, discontinued stock, maintenance inventory, or another documented reason. Then place the manufacturer, part number, product designation, and location of the matching physical reel beside that reason. Availability explains why a line is being considered; it does not identify the cable itself.
An old order, ERP export, or invoice can be valuable evidence, but it is a starting point. Retain the record reference so a reviewer can trace the line, while making clear that the physical stock and its current balance must be checked separately.
- Use a documented availability reason and the related project or order reference.
- Pair it with the actual manufacturer, part number, and product designation.
- Do not let the word surplus replace a cable specification or a physical count.
Reconcile the old record to each physical reel
Match each export or purchase line to the reel, coil, or cut-length group now in storage. Record the original quantity, the current quantity, and a discrepancy note beside the same inventory reference. A discrepancy might say that a reel was partly issued to a project, transferred to another location, or cannot yet be found; it should not be silently erased by carrying the old total forward.
For a partial reel, show its remaining continuous footage and whether that figure is documented, measured, or estimated. A grand total can conceal the difference between one usable long reel and several short pieces, so preserve the per-reel record until the actual inventory is clear.
- Match record line, reel ID, original quantity, current quantity, and discrepancy note.
- Give every partial reel a current continuous-length record and quantity basis.
- Do not use an original order total as proof that the material remains in storage.
Keep reserved and approval-pending stock out of the offered balance
Use separate lines for full reels, partial reels, coils, cut lengths, reserved material, and stock awaiting release approval. A cable line can be physically present but not available for a purchasing discussion. Marking that distinction early keeps a potential offer from being based on stock another project still controls.
State which role or document is needed to authorize release. If the answer is not known, say that approval is pending rather than naming an unconfirmed person. The record should make the current scope transparent without promising that every listed line can be transferred.
- Show reserved or pending status separately from material identity and quantity.
- Identify the known release authority or mark it unknown or pending.
- Keep current releasable balance distinct from physically present but controlled stock.
Attach access evidence to the reconciled inventory
The City of Sparks comprehensive plan identifies Interstate 80 as the only interstate highway passing through Sparks and lists principal arterials including Pyramid Way, Sparks Boulevard, Vista Boulevard, Prater Way and McCarran Boulevard. This describes transportation context, not a pickup route, local office, or movement promise. For a reconciled Sparks inventory, its practical relevance is to record the actual site or ZIP, access restrictions, known loading resources, and photo/document filenames against the same reel references used in the balance sheet.
Use a matching identifier across the export, photographs, tag close-ups, and any supporting correspondence. Where access or loading information is incomplete, place that unknown next to the affected line. It is better to identify the gap than to make a mixed warehouse list look more available than it is.
- Match inventory references to photo filenames, records, site or ZIP, and access notes.
- Include a tag close-up and a reel overview for each distinct specification.
- Mark unknown loading resources or access limits as unresolved line-specific facts.
Fix the original-footage mistake with a fictional balance record
The common mistake is to present original invoice footage as the remaining quantity and to call a project-reserved reel immediately available. The correction is to show the current balance for every reel, its evidence basis, and its release status. An old order remains supporting context, not a substitute for a physical count and authorization check.
Illustrative fictional record: OV-SP-07 identifies project-overrun feeder cable by its tag. It has two reels: one with 300 ft documented and one with 180 ft estimated. Both are uninstalled; one is reserved pending a project decision, and only the other has a releasable status recorded. The Sparks warehouse has unknown access and loading details. This is not a purchased lot.
- Use per-reel current quantity and evidence basis before reporting a total.
- Retain reserved or approval-pending material in the record without including it in the releasable balance.
- Make the fictional example’s unknown site facts visible rather than turning them into assumptions.
