Start with a current balance, not the order total
An invoice or warehouse export may explain what was originally ordered, but it does not establish today's sale inventory. Match every listed item to a reel, coil, or defined continuous length that is physically present. Use the old quantity only as a historical field; put a separately labeled current balance beside it.
The recurring error is treating a purchase total as releasable footage even though one reel was consumed, reserved, pending return, or waiting for internal approval. Resolve it by assigning a physical reel ID, recording its present state, and leaving a line unavailable until its release status is documented.
- Record inventory line ID, reel ID, manufacturer, part number, storage location, and the record-to-physical difference.
- Label each quantity measured, documented, estimated, or unknown rather than presenting one merged total.
Keep each form of surplus cable distinct
A full reel, partial reel, coil, and cut length should not share a single footage field. They answer different seller questions: a full reel may retain its original tag, a partial reel needs a current balance, and a group of cuts is not one continuous length. Keep the item description and photo reference with the exact physical unit.
If an estimate is the only available quantity, state how it was obtained and do not upgrade it to a measured figure later in the worksheet. A missing tag is useful information too: mark it missing, photograph the reel and visible jacket printing, and retain the line as incomplete instead of borrowing a neighbor's label.
- Use one row per reel or continuous piece, with a full, partial, coil, or cut-length status.
- Match filename references for the tag, jacket print, and reel overview to the same row.
Show what can actually be released
Availability is separate from identification. For each item, note whether it is available, reserved, pending approval, or pending return; identify the owner or title holder and the person authorized to release it. A project name or storage address does not prove that a particular reel is available to sell.
If a release deadline, reservation note, or contact is unknown, write unknown rather than supplying a tentative date as fact. The practical fix is a short follow-up list that names the missing approval record and keeps that line distinct from items whose release authority is already documented.
- Keep reservation or return notes attached to the affected reel, not only to the overall lot.
- Record release authority and an access limitation separately; neither implies a transport arrangement.
Use Lakewood context without substituting it for records
Lakewood's economic-development office says its priorities include sustainable growth, diverse job creation, small-business and entrepreneur support, and retention and expansion of existing businesses.
That description is a limited local context for business inventory changes; it does not identify a company, a cable lot, or purchaser demand. The usable submission remains the seller's current reel list, photos, and release evidence rather than an economic-development statement.
- Keep local background separate from the part number, current footage, and release fields that describe the actual inventory.
Worked example: a reconciled overrun entry
This fictional example shows the useful distinction between old paperwork and the current record. It is not an actual or purchased lot: an inventory row reads OV-LK-01; manufacturer and part number copied from the reel tag; two reels present; 300 ft documented on one reel; 180 ft estimated on the other; and one reel marked release pending.
The example does not convert the two balances into a claimed sale total until the reservation note and release authority are resolved. A seller with a similar uncertainty can submit the documented line first and leave the pending line visibly incomplete.
- Example fields: original record reference, current reel ID, continuous footage, quantity basis, availability status, and release authority.
- For unknown footage or authority, enter unknown and identify the photo or internal record that could resolve it.
