Reconcile the physical balance before listing a reel
A purchase order or ERP export can identify an item, but it may include footage that has already been used, transferred, or reserved. Walk the storage area and create one line for each reel or group of truly matching reels. Keep an original-quantity column only as history and add a separate current-balance column for the amount now present.
For every balance, state whether the footage is measured, documented on a current tag, or estimated. An estimate is useful when it is labeled as such and tied to its basis, such as a recent count or a visible partial reel. Do not turn an old order total into current availability merely because the part number matches.
- Use a stable inventory reference for every reel or package.
- Record manufacturer, part number, full designation, and remaining continuous footage.
- State measured, documented, estimated, or unknown beside the current balance.
Sort availability from internal hold status
A full reel, partial reel, short cutoff, retained maintenance stock, and a line awaiting approval are not interchangeable. Place them on separate rows even when the jacket printing is the same. This keeps the purchasing review focused on the stock that is actually offered while retaining useful context about related inventory.
The common inventory error is calling all material on an old project list available, including a reel already consumed or reserved for another job. Mark a reserved or approval-pending line clearly and identify its status rather than describing it as ready for release. The result is a more honest list and fewer avoidable corrections.
- Separate full reels, partial reels, cutoffs, retained stock, and pending-release lines.
- Record unused or removed status without treating those conditions as equivalent.
- Keep the continuous length visible; do not replace it with one combined total.
Make photographs and records follow the line item
Use the same reference in the spreadsheet, image filename, reel tag photograph, and any product file. Capture the readable jacket legend, the reel or package identifier, the cable ends when accessible, and visible storage or packaging condition. A wide warehouse image can supplement those records, but it cannot establish the specification for each line.
If a legend is unreadable or a document cannot be matched to the reel, write unknown or mismatch instead of filling the field from a neighboring product. A data sheet can be listed as a reference only when its part number matches. This prevents a plausible-looking record from being attached to the wrong remaining balance.
- Match photo reference, jacket legend, and data-sheet reference to the same reel ID.
- Keep unknown fields explicit rather than borrowing a neighboring reel’s details.
- Photograph enough of the tag and printing to preserve the actual designation.
Provide release and site facts without assuming terms
For each offered line, identify the storage location, the person or role with authority to approve release, practical access restrictions, available loading information, and the seller’s requested timetable. These details describe the lot; they do not establish a movement arrangement or an accepted transaction.
If authority is still pending, leave the line in the inventory with that limitation visible. A named contact may be the person gathering details rather than the release authority, so distinguish those roles. Treat the date requested by the seller as a planning fact, not a commitment about when material will move.
- Record owner or release authority and storage location.
- Describe dock, ground-level, aisle, or other access facts that are known.
- State the requested release timetable and flag pending approval.
Use a Gresham context only as context
Gresham’s traded-sector strategy says the city is working to strengthen and grow its existing manufacturing sector and identifies advanced electronics and specialized machinery and equipment as targeted opportunities. That is useful context for keeping an overrun list tied to current product evidence; it does not show that any particular Gresham reel exists or that it will be purchased.
An illustrative inventory record—not a purchased lot—could read: reference OV-GR-01; manufacturer and part number photographed, full designation pending; two reels with 300 feet documented and 180 feet estimated; uninstalled project overrun; release approval pending. The value of the example is the separation between a factual balance, an estimate, and an approval gap.
