Define what is available for release
Surplus inventory is a current-status question, not a label copied from an order or warehouse export. This page helps a seller reconcile physical reels and cut lengths against records so quantities that are reserved, pending return or awaiting approval remain visible instead of being offered as available.
Castle Rock Water states a goal of 75% or more renewable water by 2050 and describes planning for growth, drought, conservation and multiple water sources. That planning context can explain a project file, but it cannot establish a reel’s current balance or sale authorization.
- Keep the task concrete: identify which reels and continuous pieces are immediately releasable, and which require authorization.
- Use matching identifiers across tags, photos and inventory files so reviewers can confirm a single physical reel matches a single inventory line.
Step 1 — Set the physical boundary
Walk the storage site and reconcile each offered line to a physical reel, coil, box or cutoff. Do not accept the original purchase total as the remaining balance. For each item, capture a storage location note (bay, pallet or rack), the reel or package reference exactly as tagged, and a short physical status note (full, partial, cut-off, bundled).
If inventory exports list multiple identical part numbers, treat each exported line as a candidate until you can tie it to a reel tag or photo. When identifiers are missing or ambiguous, mark those lines as "unknown inventory match" and follow up with measurement, labeling or a controlled inspection before claiming availability.
- Evidence fields to collect: current storage site; reel/package reference; physical status; inventory export line.
- If a reel tag is smudged or missing, photograph the reel and adjacent markings and log the pallet location to preserve traceability.
Step 2 — Preserve reel-level quantity
Treat each reel, coil or continuous piece as the smallest releasable unit. Separate full reels from partial reels and cut lengths. Record footage per reel or continuous run—document whether that footage is measured, estimated, or taken from a prior documented count. Use the measured/documented/estimated basis field to show how you arrived at the footage.
Where inventory exports include a single footage line for an original purchase, replace that single line with reel-level lines that show the actual remaining footage on each reel. If footage is approximate, label it as estimated and schedule verification prior to release.
- Evidence fields to collect: reel count; length per reel; continuous versus cutoff; measured/documented/estimated basis.
- Preserve separation: do not aggregate two partial reels into one line unless they are physically joined and the tag shows a single reference.
Step 3 — Explain release status and authority
Mark each recorded item with a release status: Available, Reserved, Pending Return, or Release Pending. For any status other than Available, identify the project or PO reference and who is authorized to approve a release. Record the approval needed and any expected timeline for that approval when known.
If warehouse exports or delivery records include items that are reserved for another job or under approval review, show them in the inventory file with the reservation status and the referenced PO or project. This avoids mistakenly presenting reserved footage as available.
- Evidence fields to collect: project/PO reference; reservation status; release authority; approval needed.
- When an item is Pending Approval, include the approver name or department and a copy or filename of the related approval request if available.
Step 4 — Match evidence across records
Use the exact same reel IDs in inventory lines, photo filenames and purchase or delivery records. Include condition notes (uninstalled, cut, damaged) and a photo filename that clearly shows the tag and at least one overall view of the reel in its storage context. This creates a single traceable path between the inventory export and the physical item.
If any inventory line cannot be matched to a photo and a tag, mark it as unmatched and prioritize it for inspection before offering it as releasable.
- Evidence fields to collect: photo filename; reel tag; PO/delivery number; condition notes.
- Example: attach OV-CR-07 as an illustrative worked example record and label it clearly as illustrative and not a purchased lot.
What to do with unknown or incomplete inventory
Be honest in the submitted file: include lines labeled "unknown match" or "requires measurement" rather than assigning footage that may not exist. For unknown items, schedule a short verification visit and record whether the basis for footage is measured, documented or estimated. If the inspection cannot occur before an initial review, present the unknowns separately so they are not misinterpreted as available stock.
When reels are reserved or approval-pending, leave their release field visibly Pending and include the approver and any supporting reference so reviewers understand why quantity is withheld. This follows the resolution: reconcile the physical count, label each reel's balance and release status, and leave pending quantities visibly pending rather than treating them as available.
- Do not substitute original invoice footage for current footage without reconciliation.
- If a partial reel's footage is unknown, document it as estimated and flag it for measurement prior to any release authorization.
Illustrative record (worked example)
Illustrative record only — not a purchased lot. Reference OV-CR-07: project-overrun feeder cable; part number shown on tag. Quantity shown as 2 reels: 300 ft and 180 ft continuous, documented. Condition: uninstalled. Release: pending approval; fictional worked example.
Use this exact style of entry when preparing your inventory export, but mark it clearly as an illustrative example if you are using it for training or demonstration.
- Include the example fields exactly when mirroring the format: reference; material; quantity; condition; release.
- Retain a copy of the photographed tag and the inventory export line that originally claimed the footage so reconciliation reviewers can compare them.
