Start with the reels that are physically present
A purchase order can identify a product, but it does not prove that every listed reel remains in storage or is free to sell. Walk the actual inventory and give each reel, coil, or continuous cut a reference. Match that reference to the original inventory line, then note whether the item is present, missing, reserved, or awaiting a return decision. This page is about correcting the current balance before it is submitted.
Lake Forest’s capital-improvement program covers water quality, landscaping, parks, streets and streetscapes, and its page links street resurfacing, utility coordination and South County projects. That is limited context for a changed-scope record; it does not identify a cable lot or establish that any project inventory is for sale.
- Compare counted reels with the original line quantity.
- Keep full reels, partial reels, coils, and cut lengths on separate lines.
- Record a discrepancy instead of folding it into a grand total.
Give every remaining length its own basis
For each physical item, record the manufacturer, part number, reel ID, and continuous footage. Say whether the footage is measured, documented by a matching tag or record, or estimated. A partial reel should not inherit the original shipped length merely because the label is still attached. If several small pieces share a product designation, preserve their individual lengths rather than presenting them as one long continuous piece.
Photographs do useful work here when each filename repeats the reel ID. Capture the tag, readable jacket printing, and a complete view of the reel or coil. If a tag and an inventory line conflict, keep both references visible and mark the discrepancy for review.
- Inventory line ID and reel ID
- Current footage and its measured, documented, or estimated basis
- Condition and matching photo filename
Separate a release question from an inventory count
A reel can be physically present but not ready to be offered. Add the reason it is being released, a reserved-stock flag, approval status, and the person or role authorized to release it. Do not label a pending return or approval-pending reel as available simply to make the total look cleaner. This distinction makes the inquiry usable without representing internal decisions as settled.
If one group is cleared and another is not, submit them as separate status groups. The buyer can review the documented material, while final purchasing interest and lot-specific terms remain a separate discussion.
- Release reason
- Reserved or pending-return status
- Authorized seller or release contact
Build a traceable balance packet
Use the same reference in the spreadsheet, the tag photo, jacket-print photo, and any purchase or lot document. A reviewer should be able to follow one row from a current quantity to its supporting files without guessing which reel a photograph shows. Keep supporting records descriptive: an old invoice may help identify the item, while the counted reel and current status establish what is in the proposed list.
Illustrative inventory example—not a purchased lot: Reel OV-LF-01; example designation copied from tag; 300 ft documented; uninstalled; release approval pending. The pending field is intentional: it prevents a fictional sample from implying that every documented reel is immediately releasable.
- Tag photo
- Jacket-print photo
- Supporting document reference
- Filename-to-line match
Resolve unknowns without inventing availability
When a partial reel has not been measured, write quantity estimated and state why, such as a remaining tag balance or visual estimate. When the release contact is unknown, identify the approval status as unknown rather than naming someone based on a department title. The workable fix is to keep the line in the inventory with its uncertainty visible, then update only that line when a measurement or authorization record becomes available.
The common mistake is presenting original invoice footage as the remaining quantity and calling every listed reel available. Replace the invoice total with the reel-by-reel balance, retain the evidence basis for each length, and mark reserved or approval-pending material explicitly.
