Start with the current balance, not the old order
An original purchase order can identify a product, but it is not proof that the listed footage remains available. Walk the storage area and create one current row for each full reel, partial reel or continuous cut length. Keep the old order number as reference material, then show the present balance beside it.
Give every row a reel ID, manufacturer, part number, storage site and readable tag or jacket-photo filename. That makes a difference between an accounting total and material that can actually be reviewed. Do not carry a quantity forward merely because it appears in a historical export.
- Record original order reference separately from current reel ID.
- Mark footage as measured, documented from a tag, estimated or unknown.
- Keep a tag photo and jacket photo tied to the current row.
Show partial reels and holds without hiding them
List a partial reel independently from a full reel even when the product designation matches. State its remaining continuous footage, whether an exposed end is visible and how the footage was established. A short cut length is a separate line, not an addition to a full-reel quantity.
Use an availability field for material retained for a return, reserved for another project or awaiting owner approval. The practical decision is whether a marked reel is currently releasable, not whether it was once purchased for the same job.
- Full, partial and cut status for each line.
- Reservation or return-pending note where applicable.
- Release approver role and any outstanding release note.
Match photos and supporting records to the same item
Name photo files with the same reference used in the inventory, such as a reel ID followed by tag or jacket. If the tag and printed jacket do not agree, preserve both records and flag the mismatch instead of selecting the more favorable description. A clear mismatch is more useful than a polished but unreliable list.
Where a warehouse export uses a bin number, add it as an additional reference rather than replacing the physical reel ID. That lets a reviewer trace the chain from historical record to present material without treating either source as conclusive on its own.
- Inventory reference, reel ID and photo filename on every line.
- Readable manufacturer and part-number transcription.
- Supporting record reference and any discrepancy note.
Handle missing data as an inventory state
If a reel has no legible tag, write unknown for the missing designation and retain the visible jacket printing, location and approximate quantity basis. Do not borrow a nearby reel specification. If release approval has not been obtained, leave the line visible but mark it pending rather than describing it as available.
Illustrative inventory example—not a purchased lot: OV-CC-07 is a fictional record with two reels, 300 ft documented and 180 ft estimated, an attached tag photo, and owner release pending. The example shows why the documented and estimated balances remain separate.
- Unknown designation or footage is a valid field value.
- Keep pending-release lines separate from releasable lines.
- Explain the method behind any estimate.
Use Cape Coral context only to label the source record
The city’s Utilities Extension Project says it provides water, sewer and irrigation services and includes new roads and stormwater improvements; it reports utilities extended to nearly all of Cape Coral south of Pine Island Road while work continues north.
That public project description is context for a private contractor or developer organizing a documented overrun; it does not identify the offered cable, prove ownership or show that any material is available. The decisive evidence remains the current reel, its markings and the private release record.
- Name a project only as background, not as a cable specification.
- Provide private owner and release authority for the offered line.
