Why reconcile reel-level balances first
Project records and inventory exports commonly show the original reel footage or order quantities, not the current physical lengths. Before offering material for review, the primary task is to reconcile those records against the reels and coils actually present at the storage site in Lakeland.
A reconciliation separates lines that are releasable now from those that are reserved, consumed, or pending internal approval. That distinction matters because an unverified historical footage value is the common source of confusion when a quoted quantity exceeds what can be produced on demand.
Lakeland EDC reports over 28 million square feet of industrial/warehouse space and over 12,500 supply-chain and logistics employees in Lakeland. This is citywide warehouse and logistics context only; it does not identify a particular lot or establish a purchasing outcome.
- Preserve the original record as provenance; do not present it as current availability without verification.
- Mark any uncertain or unapproved footage as pending rather than available.
- Keep continuous lengths and reel identities as your unit of record.
Step 1 — Build a current balance
Start by exporting the project or warehouse list and then perform a physical walk of the Lakeland storage site. For each inventory line, create a spreadsheet row that shows the exported inventory reference and the observed reel-level reality.
Required evidence fields for each row: inventory reference, manufacturer, part number, storage site, and current quantity basis (measured, documented, or estimated). If the exported record differs, keep both values visible: one as provenance and one as the reconciled current-balance.
- Record whether the line is releasable, reserved, returned, or pending approval.
- If quantity was estimated onsite, flag the row and note the estimation method and confidence.
Step 2 — Preserve reel-level quantities
List full reels, partial reels, coils, and cut lengths separately. For every reel include reel ID, continuous footage, reel count, quantity basis (measured/documented/estimated), and condition. Continuous footage is the primary determinative field: for reels, record the continuous footage remaining on that reel rather than distributing footage across an order-level line.
If a reel’s footage is estimated, include how the estimate was derived (e.g., reel diameter measurement, tag footage minus used length) and classify the estimate as high/medium/low confidence.
- Do not aggregate multiple partial reels into a single line without showing each reel’s continuous footage.
- Keep condition notes separate from footage: clean, exposed, jacket-damaged, moisture-exposed, etc.
Step 3 — Tie evidence to each line
Use consistent references in the spreadsheet and the associated photo filenames. For each reel provide photo references that include the tag, visible jacket printing (part number, voltage marking), a reel overview showing continuous footage, and any damage or packaging issues.
Photo filenames should match the inventory reference and reel ID (for example: OV-LK-07-tag.jpg; OV-LK-07-reel.jpg). Include short photo captions in the spreadsheet so reviewers can match images to rows quickly.
- Capture the complete tag and any reel printing to establish manufacturer and part number.
- Note damage or exposed conductor in the damage notes field and show a close-up photo.
Step 4 — Document release authority and approval status
Name the owner or business role who can authorize release for each lot and document approval status and any outstanding internal return or project approvals. Include an available date or seller timetable for when the material can be released.
If release authority is not a person but a process (for example, project manager sign-off), document that process and the expected timeline. If authority is unknown, mark the line pending and describe what is required to clear it.
- Provide contact role, not necessarily personal contact details in this draft, and state whether approval is pending, granted, or withheld.
- Do not treat pending authority as availability; mark it pending with the reason.
Handling unknown or incomplete inventory
If you cannot measure footage for a reel, do not invent a value. Mark the quantity basis as estimated and show the estimate method, confidence, and photo evidence. For unknown release authority, list the last-known business role responsible and what documentation or approval will be required to change status.
When records are incomplete, retain the original exported record as provenance in a separate column and create a current-balance column that is explicitly dated and signed by the preparer. That dated current-balance, with reel-level photos and tags, is the working availability the reviewer will rely on.
Illustrative only—not a purchased lot: OV-LK-07 records project-overrun feeder cable from the reel tag, two reels with 300 ft documented and 180 ft estimated, uninstalled condition, pending release approval, and matching tag and reel photos.
- Include a preparer name and a preparation date on the spreadsheet.
- Flag any line that requires onsite measurement before final confirmation.
