Set a boundary around what is actually offered
Start with the physical and approval boundary, not the purchase order. Make one list for reels and cut lengths that are available now, then separate material retained for a future job, promised to a return, or awaiting internal approval. A line can stay in the workbook without being counted as currently offered.
For each available line, record the project or inventory reference, storage location, release status, and authorized release contact. If one of those fields is not known, say so beside the reel ID. That creates a useful follow-up list without turning an estimate or a pending return into an available quantity.
- Project or inventory reference tied to each physical item
- Storage location and release status kept as separate fields
- Authorized release contact for every line presented as available
Reconcile each paper line to the present reel
A receiving record may identify the original product but cannot establish the footage left after job use. Match that record to a reel, coil, or defined cut length. Transcribe the manufacturer and part number, give the item a reel ID, and state whether its present footage is measured, documented, or estimated.
Do not repair a missing tag by borrowing a neighboring reel’s identity. Assign a temporary reel ID, attach a photo filename, and mark the product field unknown until a matching record is found. A separate unknown line is more useful than an apparently precise total with no physical match.
- Manufacturer and part number copied from the matching item or record
- Reel ID and photo filename used on the same inventory line
- Current footage basis shown as measured, documented, or estimated
Keep full reels, partials, and pending quantities visible
List full reels, partial reels, coils, and cut lengths as their actual forms. Two partial reels with the same designation are not one continuous run, and an original reel length is not a current balance. Preserve the continuous length per reel, reel count, and the basis for every quantity before making a grouped total.
The common error is presenting the original project total as material ready for release. Correct it with a current-balance column tied to reel IDs: confirmed available, reserved, pending return, and estimated. A seller can discuss the whole inventory while allowing the buyer to see exactly which lines are not yet release-ready.
- Continuous length per reel rather than only aggregate footage
- Reserved and pending-return columns outside the available balance
- Grouped lines only when designation and quantity basis truly match
Use a fictional balance record to expose unknowns
Illustrative only—not a purchased Vallejo lot: OV-VJ-01 is project-overrun feeder cable with the exact part number still to be read from the tag. The record shows two partial reels, one with 310 feet documented and one with 185 feet estimated. The release-status field reads “approval pending,” so neither figure is represented as a settled available total.
That example is a format, not a claim about local inventory. If an estimated reel later proves shorter, update that single line and retain the earlier basis. If a return is declined or the release contact changes, move the item out of the available balance rather than changing a grand total with no explanation.
- Reference: OV-VJ-01
- Quantity: 310 feet documented plus 185 feet estimated on separate partial reels
- Status: uninstalled; release approval pending
Use Vallejo context without turning it into a stock claim
Vallejo says its Economic Development Department provides new-business recruitment, technical assistance for existing businesses, business retention, site-selection assistance, management of City-owned property and Mare Island conversion. That description is local business context only; it does not identify a cable lot, customer, City relationship, or buying demand.
For a Vallejo overrun, the useful local detail is the seller’s own storage and release information, not a project name standing in for documentation. Include access hours and known loading constraints with the record. Photos and a line-item file can be sent to saleselectricalbuyers@gmail.com after the inquiry identifies the reel references.
- State access hours and known loading constraints
- Keep the local context separate from the actual inventory evidence
- Email photos using the same reel IDs as the balance list
