Define the offered-reel boundary
The task on this page is not to repeat an old purchase order. It is to establish which identifiable wire or cable reels are currently offered and which are still reserved, pending approval, or outside the inquiry. Start one row for each reel or genuinely identical reel group, then give that row a stable inventory reference.
For every row, state the release status, the owner, and the person authorized to release the material. A reel with an unknown owner or incomplete authorization is useful to list, but it should remain marked pending rather than represented as released. This keeps a project-overrun balance distinct from material still committed elsewhere.
- Use available, reserved, pending approval, or not offered as the release-status field.
- Keep the inventory reference, owner, and release contact on the same row.
- State the reason for release without turning an old purchase record into a current balance.
Reconcile old records to the reels in hand
Use an invoice, project record, or inventory export as identification support, then compare it with the reel actually present. Record the manufacturer, part number, original quantity, current reel count, and a discrepancy note. If an original 500-foot reel is now partial, the original figure remains background information; the current continuous length needs its own basis.
The frequent inventory mistake is presenting an old project invoice as the quantity for sale after reels have been consumed or set aside. Resolve it with a current-balance row per reel. If the remaining footage is estimated, say so and identify the basis, such as an existing measurement record or a visual reel estimate.
- Record original quantity and current reel count as separate fields.
- Label each current length measured, documented, or estimated.
- Explain a mismatch as consumed, reassigned, reserved, or unknown rather than silently carrying it forward.
Keep usable lengths and conditions visible
List full reels, partial reels, coils, and cut lengths separately. Record the continuous footage for each and the observed condition rather than reporting one aggregate total. A group is only genuinely identical if the product marking, current length basis, and condition are all the same; otherwise, retain individual rows.
Do not change the material merely to make the list simpler. Clear existing tags, jacket printing, and long continuous lengths are useful evidence for an inventory review. If a reel has no readable tag or its footage cannot yet be supported, identify that gap explicitly beside the reel reference.
- Keep full, partial, coil, and cut status in a dedicated field.
- Pair each continuous length with its quantity basis and condition note.
- Leave unreadable markings and unsupported footage as unknown.
Match proof to each current-balance row
Build a small proof bundle around the same reference: spreadsheet row, reel-tag photograph, jacket-print photograph, and the matching project or product record. Photo filenames should repeat the inventory reference so a reviewer does not have to guess which image belongs to which reel. A document that identifies the product but not the current physical reel should be labeled with that limitation.
The City of Joliet says its assets include multimodal infrastructure and a productive logistics and manufacturing sector, with available industrial sites and buildings. That limited context makes warehouse, facility, and project-overrun records useful places to organize an inquiry; it does not identify a particular seller, cable lot, or purchasing term.
- Use the inventory reference in every photo filename and document note.
- Show both a readable tag and readable jacket printing when available.
- Flag missing proof beside the reel rather than treating it as a completed record.
Resolve pending lines before presenting a balance
The worked fictional record in this page uses reference OV-JOL-01: two project-overrun feeder-cable reels with 300 feet and 180 feet documented, an uninstalled status, and release pending. It is a formatting example, not a record of an actual lot. Its point is to show that the length, status, and unresolved release detail can coexist without being blurred into a confirmed offering.
For an incomplete line, name the next record that would reduce uncertainty: a tag photograph, a current length measurement, the matching project record, or confirmation from the release contact. Keep the item pending until that evidence is attached. This release-reconciliation task is distinct from cable construction identification and from a multi-site handling worksheet.
- Mark a missing authorization as pending approval, not available.
- Name the specific missing tag, quantity basis, or contact record.
- Retain the invoice as support while the current balance remains unresolved.
