Set the releasable inventory boundary
A project closeout spreadsheet often combines material that is available, reserved for another job, return-pending, or no longer at the listed location. Treat those categories as different records. Walk the storage area against the export or purchase record and give every located reel, coil, or continuous cut length an inventory reference before calling the balance available.
For each missing line, keep the original reference but mark its current state as missing, reserved, return-pending, or unknown. This avoids turning an historic order quantity into a promise about stock that has not been located. It also keeps a release question separate from the material-identification question.
- Match the inventory reference to a physical reel or continuous piece.
- Record a current reel count rather than relying on an invoice total.
- Use a separate release-status field for available, pending, reserved, or unknown material.
Build a reel-level current balance
The useful unit is one reel or continuous length, not one grand footage figure. Record the manufacturer and part number, reel ID, complete readable designation, and the remaining footage for that item. State whether footage is measured, documented by a current record, or estimated. Keep full reels, partial reels, coils, and cut lengths on separate lines even when they share a product designation.
A partial reel with 180 estimated feet and a full reel with 300 documented feet may be listed in the same inquiry, but their quantity basis must remain visible. If a label shows the original shipped amount, preserve it as a historic note; do not substitute it for the balance now on the reel.
- Use one row for each reel or continuous piece.
- Pair every footage figure with measured, documented, or estimated.
- Describe visible packaging or jacket condition on the same row.
Link release evidence to the correct line
Name the person or role that can authorize sale and release, then record the storage site, access restrictions, loading resources, and requested timetable for the actual inventory lines. A warehouse contact who can point out stock is not automatically the release authority. If approval remains unresolved, label the line approval-pending rather than treating it as ready to transfer.
Use the same reference in the inventory, photo filenames, and any release note. Photograph the reel tag, a readable span of jacket printing, the overall reel, and visible condition differences. That map helps prevent a good photo of one reel from standing in for another with a different balance or release status.
- Photo name: inventory reference plus tag, jacket, overview, or condition.
- Keep storage access notes distinct from any future transport discussion.
- Mark missing authority or access information as unknown.
Use Livonia context only for the site note
Livonia's Planning and Economic Development Team emphasizes retaining and expanding existing businesses, attracting new business, and supporting industrial and commercial prospects with planning, infrastructure, zoning and incentive coordination.
That city statement is context for business and facility records; it does not indicate that a particular company has surplus cable or that any lot will be purchased. In a seller record, the practical local detail is the actual storage address or ZIP, access rule, and release contact for the specific reels—not a general statement about the city.
- State the real storage location privately in the inquiry.
- Do not treat a business context as evidence that material is available.
- Keep facility-closeout and project-overrun reasons attached to the applicable line.
Work an honest current-balance example
The following fictional format shows how a release question can remain visible without inflating a quantity. It is not an offered lot or a transaction. The first reel has a documented balance; the second has an estimate. The record keeps both the physical evidence and the unresolved release question in view.
If the tag cannot be read, retain the reel ID and photographs, transcribe only what is visible, and state that the designation and balance need confirmation. Do not merge that reel into a labeled group merely to make the list look complete.
- Illustrative only: OV-LIV-01; feeder designation transcribed from tag.
- Quantity: two reels; 300 ft documented and 180 ft estimated.
- Condition and release: uninstalled; release pending.
