Why one-row grand totals fail operations
A single grand-total footage figure hides differences that matter for disposition: per-reel length, reel condition, storage site, exposure history and who can release each reel. Those differences affect how inventory is inspected, grouped for transport, and cleared for release. Our process is designed so an independent reviewer can match each inventory line to a physical reel, a photo and a release contact without returning to the site.
When a submission uses a single aggregate number, reviewers and planners must assume or request clarifications, which delays decisions and may prevent practical grouping by site or specification. We ask that you preserve the original structure of the lot: one spreadsheet row per reel or continuous piece, with site grouping intact.
Local context: The city’s business resources page says Torrance is within a Foreign Trade Zone and identifies FTZ No. 50 (Port of Long Beach) and FTZ No. 202 (Los Angeles). That location fact does not promise port handling, freight, a transaction, or the presence of a particular lot. It is relevant only to the need to keep storage site and release documentation distinct when a commercial inventory is spread across locations.
- Maintain per-reel rows; do not replace with a grand total
- Record whether lengths are measured, documented or estimated
- Group only truly identical products in a single line
Step 1 — Assign stable line references
Use a stable identifier for each reel or continuous run in your spreadsheets, documents and photo filenames. The identifier should appear on the reel label if present and match the spreadsheet line. Group only genuinely identical reels under a single reference and include the specification group so reviewers can confirm interchangeability.
Required evidence fields for this step include line/reel ID, manufacturer/part number, complete marking, photo filename and specification group. Photo filenames should embed the same line/reel reference to make cross-checking immediate.
- Example: BL-TOR-01 in spreadsheet and on photos
- Attach a specification group (e.g., insulation type, conductor size) to each line
Step 2 — Retain each quantity and length
List the reel count and per-reel length; indicate whether each length is measured, documented (e.g., factory tag) or estimated and include the quantity basis. Record condition and, if useful, weight basis for large reels. Never collapse the submission to a single cumulative footage figure.
Required evidence fields here include reel count, per-reel length, quantity basis, condition and weight basis. If a reel is partially used or cut, show the continuous remaining length for that reel as its own line.
- Record measured lengths where available; mark estimated lengths as such
- For continuous pieces, list the remaining continuous footage per item
Step 3 — Separate sites and conditions
Group inventory lines by actual storage site: warehouse, yard, dock or other location. For each storage grouping, record storage condition, service history and any damage or exposure. Keep unused, removed and recovery-only material visibly distinct in the submission so reviewers can decide on handling and access separately for each group.
Evidence fields required: storage site, storage condition, service history, damage/exposure and release group. This separation lets planners and loaders prepare the right equipment and timeline for each site rather than treating the lot as a single homogeneous mass.
- Label site names consistently across the spreadsheet and photo set
- Flag exposed or weathered reels explicitly in the condition field
Step 4 — Document site authority and access
For each site, provide the release authority and a contact, access restrictions, available loading equipment and any requested timetable. Do not book transport in advance; instead, supply these details so a reviewer can assess the practical next discussion. Required evidence fields include release authority, access restrictions, loading equipment, dimensions and site timetable.
Include clear notes about gates, hours, and whether site personnel can stage loads. If authority is not yet confirmed, state that explicitly and give the best available contact information so a reviewer can follow up without assuming permission is granted.
- List a release contact for each distinct storage site
- Describe loading resources (forklift, crane, dock leveler) and any dimensional constraints
Handling unknown or incomplete inventory
If some reels lack markings or measured lengths, keep them as separate rows and mark which fields are unknown. Provide the photo filename and condition notes for each unknown reel so a reviewer can assess visibility and plausibility. Honest, line-level unknowns are acceptable; collapsing unknowns into an aggregate figure is not.
When release authority or site dimensions are unknown, state the unknown explicitly in the release authority or dimensions field and provide the best contact or the person who can confirm access. We prefer clear placeholders over inferred assumptions because that preserves traceability and avoids later disputes.
- Mark unknown lengths as 'estimated' and include how the estimate was derived
- Keep unmarked reels as individual lines with clear photos showing any partial markings
