Define the offered surplus boundary
Start with the physical inventory rather than the original purchase total. Make one working list for every reel, coil, or continuous piece and mark whether it is retained for a future job, reserved, pending return, awaiting approval, or offered. A purchase order can identify an item, but it does not prove that the item remains in the offered balance.
Use a stable inventory line ID beside the manufacturer part number, storage location, release status, and name or role of the person who can authorize release. This lets a buyer see the difference between a cable item that can be discussed now and one that belongs in a non-offered reference list.
- Keep retained, reserved, pending-return, and offered material in separate status fields.
- Do not treat an old ERP quantity as the current quantity without a physical check.
Reconcile reel-by-reel quantity
Record full reels, partial reels, and cut lengths separately. For every line, state the reel reference, number of reels, remaining continuous footage, quantity basis, and visible condition. Label footage as measured, documented, or estimated; an estimate should include the method or record used to arrive at it.
This is not a request to alter cable to obtain a number. When footage is unknown, leave it unknown, add the readable tag or jacket printing that remains, and photograph the reel and accessible ends. The missing field is more useful than a guessed balance that later conflicts with the reel.
- Use one row per reel or continuous piece until the lot scope is settled.
- Tie each estimate to a stated basis instead of presenting it as measured footage.
Keep release proof with the inventory line
Match the same reference across the spreadsheet, photo filenames, tags, and product records. A photo such as OV-LAW-01-tag.jpg should correspond to the OV-LAW-01 row rather than serve as general evidence for a group of similar reels. Add the readable manufacturer tag, jacket legend, and any matching data-sheet reference where they exist.
For access planning, state the site description, known restrictions, available loading equipment, requested release date, and a contact who can clarify release. These details describe the seller’s situation; they do not set inspection, freight, payment, or transport terms for the lot.
- Match every photo and document name to the inventory line ID.
- Mark unreadable labels and unresolved approval as unknown or pending, not as confirmed.
Use local context without inventing inventory
Lawrence’s official business-resources page places the city 25 miles north of Boston in the Merrimack Valley and describes historic mill buildings with adaptable manufacturing and office space. That city context can explain why a seller is organizing a mill, warehouse, or commercial closeout, but it does not identify a cable lot, owner, or buyer. The reel record remains the evidence that matters for the submitted inventory.
Illustrative inventory record—not a purchased lot: OV-LAW-01; project-overrun feeder cable with part number on tag; two reels, one 300 ft documented and one 180 ft estimated; uninstalled condition; one reel release approval pending. The pending reel stays separate from the offered balance until authority is confirmed.
- Describe the actual site and material only; do not infer availability from a Lawrence setting.
- Keep a pending approval visible on the same reel line that needs it.
Resolve incomplete records before the inquiry
If a label is missing, a release contact is uncertain, or footage cannot be supported, use a notes field that names the gap and the next evidence to seek. For example, a line can say “jacket printing unreadable; tag photo attached” or “release authority pending with inventory owner.” It is better to submit a transparent incomplete record than to combine unlike reels under a convenient total.
Before sending the inquiry, compare the offered rows against the physical count once more. Remove retained and reserved stock from the offered subtotal, retain their references for reconciliation, and keep the photo set unchanged so that later questions point to the same material.
- Add a notes/unknowns field to every inventory row.
- Recheck physical reel count before sending the offered subtotal.
