Why per-reel detail matters
Large OEM, contractor and public-project inventories often list a single footage total that masks meaningful differences between reels: documented versus estimated footage, differing conditions, and separate storage sites with different access constraints. A reviewer evaluating a multi-reel lot needs a one-row-per-reel structure so each physical unit can be matched to photos, markings and an authorized release contact.
Following the brief steps preserves traceability and reduces back-and-forth. Use the provided evidence fields for every reel: a stable line or reel ID, the manufacturer/part number, the reel count and footage per reel. If reels are continuous pieces rather than standard reels, treat each continuous piece as its own line with its measured footage.
The city’s automotive and advanced manufacturing page names four OEM vehicle production plants: the Sterling Heights Assembly Plant, Sterling Heights Stamping Plant, Ford Van Dyke Transmission Plant and Ford Axle Plant. That list is only local context for a multi-reel inventory workflow; it does not show that any named site has cable available.
- Assign a stable line/reel ID that appears in spreadsheets, filenames and photos.
- Record manufacturer and part numbers even when multiple reels share the same product.
- Always list footage per reel; do not replace it with only a summed total.
Group by actual storage location
Keep separate groups for warehouses, yards and project sites. For each group, include the storage location name, the site contact, the specific release authority and any access restrictions. These site-level facts let a reviewer understand which reels can be collected together and which will require separate approvals or logistics.
When a multi-site lot could be treated as one sale, note that this is a business decision to be confirmed: the list must still preserve the separate site rows and release contacts so reviewers and logistics planners can evaluate feasibility.
- List storage location and site contact on every reel row when the reel is not co-located with others.
- Document the release authority per site and specify any access restrictions (gates, hours, credential requirements).
- If you propose combining sites for a single transaction, flag that as 'needs business confirmation' rather than removing site distinctions.
Match photos to each line
Photographs are the primary verification tool. Filenames should include the line/reel ID. For each reel provide: a tag photo showing the reel ID or tag, a jacket legend or marking close-up showing part numbers and lot marks, a reel overview showing condition and winding, and any material-specific condition photos (insulation damage, end terminations). Also include a document-match image when you reference paperwork such as inventory labels or cut tags.
When photos cannot show every required element for every reel, annotate the spreadsheet with the missing photo references and explain why (e.g., covered by shrink wrap, on a nested pallet). The reviewer needs honest notes rather than aggregated claims.
- Include at minimum: tag, jacket legend/marking, reel overview, and document match images for each reel.
- Use line/reel ID in every filename to allow automated matching.
- If a reel's markings are unreadable, record that as a separate condition field and include an overall reel photo.
Report handling and loading facts as seller constraints
Provide dimensions and a weight basis (gross, net, or estimated) for each reel or grouped pallet, and record the available loading equipment and site timetable. State these items clearly as seller-provided constraints — not as a promise of transport or pickup. This distinction is necessary so buyers and carriers can plan resources without assuming seller-arranged movement.
If you do not know exact weights or dimensions, record your estimation method (e.g., manufacturer spec, measurement, scale ticket), and mark those fields as estimated. Unknowns should stay visible to prevent mismatches in logistics planning.
- Supply dimensions and gross/net/estimated weight per reel or pallet.
- List available loading equipment (forklift capacity, dock access) and the site timetable for when loading can occur.
- If weight or size is unknown, state the estimation method and leave the field marked 'estimated'.
What to do with incomplete or uncertain inventory
Be explicit about unknowns. If footage for a reel is estimated rather than measured, mark it as 'estimated' and provide the basis. If release authority has not been documented, mark the site row accordingly and include the contact name and role even if written authorization is pending. A single grand-total should never replace per-reel footage fields.
If reels are identical and you wish to group them, you may group identical reels only if you still preserve per-reel footage fields (for example: '3 reels; reel 1=500 ft doc, reel 2=90 ft est, reel 3=120 ft doc'). That keeps the reviewer able to reconcile each physical unit to its evidence without losing the benefit of grouping.
- Never replace per-reel footage with only a grand-total.
- When authorization is pending, list the site contact and mark 'authorization not documented' in the release authority field.
- Group identical reels only when each reel’s footage and condition remain separately recorded.
Illustrative record (how to present the lot)
Use a clear, tabular record as an index for photos and site facts. The illustrative record below shows how to present a small multi-site lot. It is an example only and not a purchased lot.
Provide matching filenames and references so a reviewer can pull each image and confirm the line-to-photo match quickly.
- Illustrative record — not a purchased lot:
- line A: BL-SH-01; matching product; 1 reel, 500 ft documented; warehouse A
- line B: BL-SH-02; same product; 1 reel, 90 ft estimated; warehouse B
- release: separate site contacts; authorization not yet documented
