Build the line ledger before calculating a total
Assign one reference to every reel or continuous piece and reuse it in the inventory, photo filenames, and any available documents. Record the product marking, reel count, per-reel length, and quantity basis on that line. An aggregate footage total can remain as a summary, but it cannot replace the individual lengths that explain what the lot contains.
Only group reels after their specification, condition, storage site, and release path actually match. A broad description such as mixed cable lot is an organizing label, not an identity. Keeping differences visible lets a buyer see which lines are documented, which are estimates, and which require a separate conversation.
- Use a unique line or reel reference for every physical item.
- Keep the product designation and per-reel continuous length on the same row.
- Label footage as measured, documented, or estimated.
Separate locations and release paths
A lot stored at two sites is not one operational location simply because the cable looks similar. Record each site, its condition differences, the owner or release authority, and any approval status. A buyer can then understand whether the lines may be discussed together without assuming they can be released together.
For mixed inventory, use a site group field rather than moving everything into a single grand-total row. If one facility can provide label photos while another cannot, preserve that difference. If an owner is unknown, make that uncertainty visible instead of assigning the contact from a nearby line.
- Group inventory by real storage site, not only by product family.
- Give each site its own release authority and status.
- Keep unknown ownership or contact fields explicitly unknown.
Describe handling facts without assuming a move
Large reels benefit from documented dimensions, a stated weight basis, access restrictions, and available loading information. State whether a figure is gross, net cable, or estimated; do not turn a loaded-reel weight into conductor weight. Describe a narrow gate, indoor bay, or unknown loading resource as a fact to be considered, not as a request for an assumed service.
Folsom Public Works says it designs and manages capital-improvement projects and maintains streets, roads, street lights, traffic signals and stormwater drainage facilities. That local fact is background for infrastructure-adjacent documentation only. It does not identify city material, establish ownership, or show that any cable lot is available.
- Record reel dimensions and the source of any weight figure.
- List access restrictions and available loading information by site.
- Keep gross loaded-reel, cable-only, and unknown weight bases distinct.
Control the version of a changing lot
Bulk inventories change when reels are counted, moved between sites, or reserved for a job. Put a list date and a simple status field on each line. When footage changes, retain the earlier value as history and update the current basis rather than replacing it without explanation. This keeps a buyer and seller from discussing different versions of the same lot.
Use photos as a check on the line ledger, not as a substitute for it. A good evidence set names the reference in the filename and shows the reel tag, jacket marking, overview, and visible condition. A missing photo should remain a missing evidence field, not an invitation to copy images from a similar reel.
- Date the inventory version and status each line as available, reserved, or unknown.
- Keep prior quantities as history when a current count changes.
- Match tag, jacket, and overview photos to the correct reference.
Worked multi-site lot record
A fictional pair of rows can use BL-FOL-01 and BL-FOL-02. Each may have one reel of matching recorded product, while BL-FOL-01 has 500 feet documented at Site A and BL-FOL-02 has 90 feet estimated at Site B. Gross weight and loading information can remain unknown until records are available. This is an illustrative inventory example, not a purchased lot.
The key correction is to avoid reporting 590 feet as one continuous, one-site quantity. Retaining the line references, footage basis, sites, and separate release contacts gives the buyer a workable picture of the real lot and shows exactly which facts need follow-up.
- Example references: BL-FOL-01 and BL-FOL-02.
- Example quantities: 500 feet documented and 90 feet estimated.
- Example limitation: separate sites and release contacts; handling facts unknown.
