Start with the material that is present now
An original purchase order, warehouse export, or project takeoff can help identify a product, but it is not a current availability record. Walk the stored inventory and make one row for each reel, box, coil, or continuous cut length that is physically present. Preserve the original-order figure in a separate historical column when it helps explain the overrun; do not copy it into the amount offered today.
Give each row an inventory or reel ID, manufacturer and part number, current continuous footage, and a quantity basis. A documented balance can cite the supporting record; a measured balance can cite the measurement date; an estimate should say how it was estimated. This distinction is important when two partial reels have the same product label but different remaining lengths.
- Inventory or reel ID tied to the physical item
- Manufacturer, part number, and readable designation
- Current continuous footage with measured, documented, or estimated basis
Keep release states separate from cable identity
Create a release-status field for every line: available for review, reserved for another project, pending return, pending internal approval, or not currently offered. Also record the quantity affected and the approval owner. A reel can be completely identified yet still not be releasable; combining that reel with an available balance makes the inquiry misleading.
Separate full reels, partial reels, unopened boxes, and cut lengths rather than treating them as one product total. Describe visible packaging or label condition, but do not convert a photograph into a condition certification. If one reel is reserved, leave it in the reconciliation sheet with its status visible instead of silently removing it from the total.
- Condition state and visible packaging or label condition
- Release status and any reserved quantity
- Approval owner and owner of the material
Link records, photos, and project context carefully
Maricopa Engineering is responsible for development and implementation of commercial and residential projects and reviews site plans, plats, special-use permits and construction documents for new development. That local administrative context can explain why a seller may have changed-scope paperwork, but it does not identify a cable product or prove that material is for sale. Use a project document only as a cross-reference beside the reel tag, jacket printing, and current-balance record.
Name photographs with the same reel ID used in the sheet. For each line, retain a tag or label image, legible jacket printing where available, an overview of the item, and a note about any missing label. If a project record conflicts with the item in storage, identify the conflict rather than choosing the more favorable description.
- Photo reference matched to the inventory row
- Project or purchase document reference, if available
- Explicit note for a missing, unreadable, or conflicting record
Work the release record before discussing movement
For a releasable line, record the storage location, the role that can authorize release, access limitations, and any seller deadline or internal return date that is already known. These are planning facts, not a commitment to pickup, freight, payment, or a purchase. Keeping them beside each line prevents a valid cable description from being mistaken for a completed release.
If the owner, approval role, or footage has not been confirmed, write unknown or pending confirmation and identify the next record to check. Do not alter an intact reel merely to make the list look uniform. A clear unknown is more useful than an assumed quantity or authority.
- Site or storage location
- Release authority and status of confirmation
- Seller-stated deadline only when known
Illustrative current-balance record
Illustrative inventory example—not a purchased lot: record OV-MAR-04 as two labeled reels of the same identified product. One line shows 300 ft documented from a current inventory record; the second shows 180 ft estimated from the remaining reel with its estimate basis noted. The historical order quantity stays in a separate column, and the second reel is marked release pending.
The common mistake is presenting the historical order total as the amount available now. The workable correction is a current-balance column supported by reel-level evidence, a visible reservation or approval flag, and photo references that point to the actual material. That format lets a reviewer ask focused follow-up questions without treating unavailable stock as offered stock.
- Example status: uninstalled; one reel release pending
- Example unknown: exact release authority pending confirmation
- Resolution: retain historical quantity only as context
