Assign stable inventory references
Give each reel, continuous piece, or genuinely identical group a stable line reference and reuse it in the inventory, photo filenames, and supporting records. Beside the reference, record manufacturer, part number, storage site, and a clear reel count. A grand total without a route back to each physical item does not let a reviewer identify what is included.
Group only products that genuinely match in designation, condition, length basis, and location. If reels share a product code but sit at different sites or have different footage, retain separate lines. This preserves the facts needed to ask useful follow-up questions without treating an aggregate count as a substitute for evidence.
- Use one line or reel ID in every related file.
- Match photo filenames to the inventory reference.
- Keep location and per-reel differences visible.
Retain specification and quantity differences
For every line, list cable designation, conductor metal and size, marked voltage, reel count, and continuous length per reel. Mark each quantity measured, documented, estimated, or unknown. Do not replace individual reel lengths with only one total; several short pieces may add up to the same footage as a long reel while presenting a different material record.
Keep cable condition and service history alongside the reference. Unused stock, removed material, and mixed recovery pieces should not be blended into a single bulk figure. If a product field is unreadable, retain the line and note the unknown rather than assigning the nearest identified specification to it.
- Record product designation, metal or size, voltage, reel count, and length per reel.
- Label every quantity basis.
- Separate unused, removed, and mixed material.
Group actual storage sites
Organize the inventory by actual warehouse, yard, jobsite, or other storage site. For each group, list access limits, available loading equipment, known dimensions or weight basis, and the contact who can confirm release. Site grouping makes it clear whether two matching-looking reels are governed by different access rules or release contacts.
Redwood City’s Economic Development Division supports businesses of all sizes and assists with business attraction, retention and expansion. That statement is only local business context. It does not identify a local lot, a customer, a price, or any prior purchase. The line-level inventory and owner records are the evidence that make a bulk inquiry usable.
- Separate every storage site in the inventory.
- State loading equipment and access limits as known.
- Identify owner and release authority per site or line.
Control release and handling facts
Record owner, release authority, site restrictions, and requested release timetable for each site or defined group. These fields distinguish a person who can show an item from the person who can authorize its release. They also preserve practical handling facts without assuming that transport, collection, payment, or timing has been agreed.
When access details are incomplete, mark the field unknown and identify the next record needed. Do not merge an unconfirmed jobsite reel into a warehouse group just to make the lot appear available. A controlled inventory makes it possible to discuss the lot without losing the boundary between confirmed and pending material.
- Identify owner and release authority separately.
- Keep site restrictions with the correct location.
- Mark unknown release or access fields clearly.
Replace the grand-total worksheet
An illustrative inventory example—not a purchased lot—could use BL-RC-01 and BL-RC-02: matching product recorded; Site A, one reel with 500 ft documented; Site B, one reel with 90 ft estimated; site and release contacts recorded separately. The example shows that identical product wording does not justify combining locations or quantity bases.
To correct a grand-total worksheet, create one row per reel or continuous piece, restore the photo reference and site, and label each estimate. Keep an overall total only as a summary after the underlying rows remain visible. This produces a seller record that is easier to review without inventing availability or lot terms.
- Keep the worked example clearly fictional.
- Restore one row per reel or continuous piece.
- Use a summary total only after line-level evidence is present.
