Reconcile the physical balance before sending a total
A project purchase order or warehouse export is useful history, but it can include cable consumed on another phase, a reel held for return, or an unopened box transferred internally. Start with a line-by-line check against the physical reels, boxes, and continuous cut lengths. Give each item an inventory reference, copy its manufacturer and part number, and show both the original quantity and the current balance.
The meaningful decision here is availability, not a broad cable classification. Mark each variance as matched, short, excess, reserved, or unknown. A line that cannot be located should remain an open item, not a quantity added to the offer. For partial reels, identify whether the remaining footage is measured, documented, or estimated so the balance is not presented with false precision.
- Inventory line ID, original quantity, current physical quantity, and discrepancy status.
- Manufacturer, part number, readable jacket marking, and matching photo reference.
- Measured, documented, or estimated quantity basis for every balance.
Separate releasable stock from project-held stock
Use a separate availability field for full reels, partial reels, unopened boxes, and pieces with a prior service history. A reel can be physically present yet not available because it is allocated to another job, awaiting a return decision, or subject to internal approval. Keeping those states separate prevents the common error of offering the entire historic order as current surplus.
For every potentially available line, record the owner, release approver, approval status, and available date when known. If a date or approver is unknown, say so. The purchasing inquiry can then focus on cable that is actually releasable while preserving a clear list of items that need a decision first.
- Full reel, partial reel, unopened box, or continuous cut-length status.
- Unused, previously in service, or condition-unknown status.
- Owner, release approver, approval state, and known availability date.
Make the worksheet evidence traceable
Use the same reference in the worksheet, photo filenames, label images, and supporting documents. For example, a line such as FW-OV-014 should point to its reel photograph, the legible jacket text, the source document, and the stated quantity basis. This is different from the bulk-lot page: the core question is whether the balance is available now, rather than how a multi-site shipment should be grouped.
When an original label is missing, preserve the best available evidence instead of creating a substitute specification. A partial jacket legend, package label, or dated inventory note may be useful context, but the line should still show what is unknown. Do not merge a reserved reel with a similar available reel simply to make a larger total.
- Photo filename and document reference on the same row as the inventory ID.
- Exact jacket or package marking, with unreadable portions called out.
- Reserved and approval-pending lines excluded from the available balance.
Use local project context only as context
Fort Wayne's 2026 neighborhood infrastructure program totals $37 million: $28.4 million for streets, roads and bridges, $4.8 million for sidewalks and alleys, and $3.9 million for trails.
That public program does not identify a seller, a cable type, or an available lot. It simply illustrates why a contractor or distributor may need to reconcile a changing project record with material on hand. The inquiry remains about the seller’s own marked reels, their current balance, and their release authority.
- Do not use a public project name as proof that a reel belongs to that project.
- Use the actual reel and release record to establish what is being offered.
Worked balance record for an incomplete release decision
ILLUSTRATIVE ONLY — fictional record, not a purchased lot: FW-OV-014 is listed as a labeled cable reel with 300 ft documented and a second partial reel with 180 ft estimated. The first line is marked available; the second remains release pending. The example shows why a combined 480-ft offer would be misleading before the pending approval is resolved.
A useful submission keeps the product description tied to the readable reel tag, identifies the photo and document references, and leaves unavailable inventory visible but separate. If the partial reel has no dependable footage record, record the estimate and its basis rather than converting it into a documented amount.
- Reference: FW-OV-014; product: manufacturer and part number from reel tag.
- Current balance: 300 ft documented; 180 ft estimated on a separate pending reel.
- Release status: one available line and one line awaiting approval.
