Start with a physical current-balance check
An ERP export, purchase order, or original reel tag may identify a product, but it may not show the footage still present. Walk the stock by line item and assign a stable reel ID before copying any quantity into an inquiry. Put the original ordered amount in a historical column and enter the currently observed amount in a separate current-balance column.
For every partial reel, state whether the balance is measured, documented on a later record, or estimated. Keep full reels, partial reels, and cut lengths on separate lines even when the printed product is the same. This preserves the continuous-length difference that a single aggregate total hides.
- Inventory line ID and current reel ID
- Original quantity beside current balance
- Continuous footage with measured, documented, or estimated basis
Match the reel to its product evidence
Copy the manufacturer, part number, and readable jacket designation against the same reel ID used in the inventory. Photograph the tag or label, a readable stretch of jacket printing, and the full reel. Use the reel ID in the file names so a product record can be followed back to the physical item.
If the label is missing, do not use a nearby reel or a project name as a substitute. List the product field as unknown or cite only a document that can be linked to that reel. Explain the gap—for example, “tag absent; purchase record not yet matched”—rather than converting a likely match into a stated fact.
- Label-photo filename
- Jacket-print photo reference
- Matching document reference
- Label status: readable, missing, or not matched
Treat release status as a separate inventory field
Availability is not established by quantity alone. Mark each line as available, reserved, pending return, or pending owner approval, and identify the person or role that can authorize release. A reserved reel can remain in an inquiry, but its status should remain visible rather than being counted as available inventory.
Add the storage location and any practical access limitation to the same line. This is enough to describe the seller’s situation without assuming an inspection, offer, freight arrangement, or collection method. When ownership or release authority is unknown, say so and identify the record or contact that may resolve it.
- Owner or owning entity
- Release-authority role
- Reservation or approval status
- Storage location and access note
Use local context without treating it as inventory evidence
Wichita's official target-industries page lists Advanced Manufacturing & Materials, Aerospace, Energy, and Transportation & Logistics among its target industries. Those sectors are limited context for why a Wichita seller may be reconciling project or warehouse cable; they do not identify an available lot or establish buyer demand.
For a surplus balance, the governing evidence remains the seller’s reel-by-reel record. A project description can explain why stock is available, but it cannot establish footage, condition, or authority to sell. Keep the city context separate from the product and release fields that support the specific inquiry.
Worked record: show unknowns and pending status
An illustrative fictional inventory record might read: reference OV-WI-01; feeder cable with part number copied from its tag; Reel 1 at 300 ft documented and Reel 2 at 180 ft estimated; original project line retained as historical; release pending owner approval. The example is a format, not an offered or purchased lot.
The common error is presenting original invoice footage as the amount available now and including reserved reels in that total. Correct it by keeping the historical number, creating a current-balance field per reel, and flagging the pending release. If reel-level footage cannot yet be determined, leave it unknown and state what photo, measurement record, or owner confirmation is missing.
