Draw a clear boundary around what is offered
Start with the inventory line, then mark it offered, retained, reserved for return, awaiting approval, or unknown. Add the owner and the person or business authority that can release the line. This turns a broad surplus list into a current disposition record without treating everything on a warehouse report as available.
Keep the reason for a hold visible. A reel reserved for a project or internal return can remain in the inventory, but it should not be included in the offered total. If approval is pending, record the pending status rather than predicting the outcome.
- Record offered status, reservation or return status, approval status, owner, and release authority.
- Keep retained and pending lines out of the offered quantity.
- Use a short note to explain a known hold or missing approval.
Reconcile physical reels to current records
Match each inventory line to a physical reel, package, or documented cut length. Use a reel ID, photo filename, current count, and full, partial, or cut-length status. An old purchase order may identify what was originally delivered, but it does not establish what remains on the floor today.
Record per-reel length with its basis—measured, documented, or estimated—and keep it separate from the original invoice quantity. If a line cannot be physically matched, mark it pending verification. That is more reliable than presenting unconfirmed footage as current inventory.
- Record inventory line, reel ID, photo filename, current count, and full, partial, or cut-length status.
- Label each per-reel length measured, documented, or estimated.
- Mark an unmatched inventory line pending verification.
Group only matching specifications and conditions
Group reels only after manufacturer, part number, designation, per-reel length, and storage condition match. Retain full and partial reels as distinct quantities even when their jacket printing is identical. A clear group can contain several reels, but the record should still show the identity and current balance of each one.
The City says its Advanced Manufacturing District is open to manufacturers in aerospace, defense and advanced manufacturing, with a development-ready industrial area at El Paso International Airport. That is limited city context for keeping project or warehouse lines organized by actual marked reels; it does not identify a particular manufacturer, facility stock, or customer.
- Record manufacturer, part number, designation, per-reel length, and storage condition.
- Do not merge different part numbers, exposure histories, or partial balances.
- Keep unreadable tags and unknown specifications on separate lines.
Keep release and access facts with the offered lines
For each offered group, note material location, practical access limits, release authority, and any stated timing preference. A storage contact does not necessarily control release, so the two roles should remain separate. The facts help make the inquiry understandable without assuming a collection method or transaction timing.
If an item is split across locations, retain the location on every affected row. If access or release is unknown, mark it unknown. The aim is an accurate seller inventory record, not an implied promise concerning payment, freight, pickup, or acceptance.
- Record material location, access limits, release authority, and requested timetable.
- Keep storage contact and release authority in different fields.
- Attach unknown facts to the specific line rather than the entire lot.
Use a fictional overrun record to find errors
Illustrative example only—not a purchased lot: OV-EP-01 is a project-overrun feeder cable with a part number on the tag. It has two reels, one with 300 feet documented and one with 180 feet documented; both are uninstalled, and release is pending. The example does not call the original invoice quantity current stock.
The usual error is including reserved reels and original invoice footage in the same offered balance. Correct it by identifying pending or reserved quantities, matching every offered line to a current reel or package, and labeling the evidence basis for each remaining length.
- Example label: Illustrative example only—not a purchased lot.
- Let the offered balance reflect current physical evidence, not the original order.
