Start with a physical current-balance count
Use the purchase order, inventory export, or project closeout list as a finding aid, not as the quantity you offer. Give every physical reel, coil, box, and continuous cutoff a reference. At the storage location, mark the line as counted, not found, or not yet checked. Record the remaining amount as measured, documented, estimated, or unknown.
Keep an old line visible when it cannot be reconciled, but label the variance rather than carrying its original footage into the offered balance. This protects a seller from presenting a historical order quantity as available material and gives the buyer a focused follow-up list.
- Inventory reference tied to a physical reel, coil, box, or cutoff
- Manufacturer, part number, and readable jacket or tag markings
- Current quantity with measured, documented, estimated, or unknown basis
- Actual Meridian storage site for that line
Keep usable lengths and condition separate
A full reel, a partial reel, and several cuts are not interchangeable quantities. List each continuous length separately, even when the same product designation appears on several lines. State whether a reel is full or partial, retain its reel ID if present, and describe visible packaging or jacket condition without turning a visual observation into a condition guarantee.
Group only genuinely matching stock after the product marking, current length basis, and condition are visible. A spreadsheet total may still be useful as a summary, but it should never replace the per-reel record that explains how the total was formed.
- Reel ID and count of genuinely matching reels
- Continuous length for each reel or cutoff
- Full, partial, boxed, coil, or cut-length condition
- Photo reference for the tag, jacket printing, and overall reel
Make release status part of every line
For each item, state whether it is approved for sale, reserved, subject to return, or pending internal approval. Identify the owner or business unit and the role that can authorize release. A project name, a warehouse location, or a past invoice does not establish that the material can be transferred.
When authorization is incomplete, leave the line in the inventory but flag it as pending. That is more useful than deleting the record or calling it available prematurely: it distinguishes the physical balance from the separate decision to release it.
- Release status and concise reason for the status
- Owner or controlling business unit
- Release-authority name or role when known
- Any access or documentation gap recorded as unknown
Build an evidence crosswalk before sending the list
Use the same reference in the spreadsheet, image filenames, and any purchase or product records. Photograph readable reel tags and a stretch of jacket printing; add a condition view where it helps distinguish lines. If a tag is missing, say so and preserve whatever identifier remains rather than substituting another reel’s description.
The common mistake is using invoice footage or a downtown project name as both the present quantity and the product identification. Correct it by matching each current reel to its own marking, quantity basis, photograph, and release status. Unknown data is a valid field, not a reason to invent a match.
- Stable line reference repeated in photos and records
- Jacket marking transcription or an explicit unreadable note
- Condition photograph tied to the same line
- Release note kept separate from product identification
Use local project context carefully
ACHD’s Meridian downtown project covered repaving or reconstruction plus sidewalks, pedestrian ramps, crosswalks, stormwater and irrigation upgrades across named downtown street segments, and the page records the project as substantially complete.
That completed-work context may prompt a contractor or distributor to check its own records for documented excess stock, but it does not show that cable exists, belongs to a seller, or is available. An illustrative record—not a purchased lot—would read: OV-MER-01; tagged part number retained; two reels, 300 ft documented and 180 ft estimated; uninstalled; release pending; fictional Meridian storage reference.
