Make the physical balance the offerable list
Walk the storage area with the old order, export, or project list as a reference, then create a new line for every reel, box, coil, or cutoff that is actually present. Give each line an inventory reference and mark it full, partial, boxed, reserved, missing, or pending release. A historic quantity can help recognize a part number, but it is not proof of the amount available today.
The local business record can help a commercial seller locate the right internal records and contact. The City of Roseville business portal links commercial users to economic development, permits and licenses, procurement services, utilities customer care and utility rebates. That is context only; it does not identify a cable lot, prove ownership, or indicate that the City is involved in a transaction.
- Use a new current-status field rather than overwriting the original order quantity.
- Keep missing, reserved, and release-pending material visible as separate statuses.
Separate the forms of quantity
A full reel, a partial reel, boxed building wire, and short cut pieces should not be rolled into one footage number. For a reel, show its count, remaining continuous footage, and whether that footage is measured, documented, or estimated. For boxed stock, show the package count and the marking that identifies it. For cut pieces, list the separate continuous lengths instead of adding them into a fictitious long run.
A practical line might read: OV-RV-01, part number from tag, partial reel, 300 feet documented, storage rack B, release pending. If the core label is unreadable or the material cannot be reached, say so and retain an estimated or unknown field rather than copying a number from the initial order.
- Record the quantity basis beside each length.
- Attach reel-tag and jacket-print photo names to the same inventory reference.
Keep release separate from identification
A part number can be known while authority to release the material is still unresolved. Record ownership, the business contact who can authorize release, the approval status, and any seller-reported deadline. Material held for a return or future project should remain on its own line rather than being represented as available.
This distinction fixes the common error of treating an invoice total as a sale balance. The useful result is a list that shows which physical packages are confirmed, which quantities are estimates, and which lines need internal approval before they can be discussed further.
- Use “approval pending” rather than a blank release field.
- Preserve the original record as identification support, not as a current availability claim.
Match supporting files to the balance
Use the same reference in the inventory sheet, photo file names, label close-ups, and supporting documents. A tag image called OV-RV-01-tag and a jacket image called OV-RV-01-jacket are more useful than a folder of unnamed pictures. When a document identifies only part of the lot, say which line it supports.
Do not correct an uncertainty by borrowing a specification from a neighboring reel. State the exact unknown field, such as footage not measured, tag missing, or release contact pending. That gives the buyer a clear next question without making an unsupported claim about the material.
- Match every file to one inventory reference.
- Describe the gap in the record, not an assumed solution.
Worked balance example
Illustrative inventory example—not a purchased lot: OV-RV-01 is a partial reel with a manufacturer and part number transcribed from its tag, 300 feet documented and 180 feet estimated, stored on a warehouse rack; one release approval is pending. The example shows a format, not a Roseville purchase or an indication that any listed material will be accepted.
Before requesting a purchasing review, compare each visible item with the current list, distinguish package types, and identify the release contact. That focused reconciliation is different from the industrial-cable page, which resolves construction and service history, and from the bulk-lot page, which maps multiple storage sites.
- Illustrative fields: reference, marking, physical status, footage basis, storage location, release status.
- State unknowns explicitly before sending the list.
