Why a current-balance workflow matters
Project and purchasing records often capture what was ordered, not what remains on the floor. If you rely on an original invoice or project total, you risk listing footage that no longer exists as a continuous length, or representing items as available that are still reserved or awaiting approval. This workflow helps you present the truth of your current balance: what is physically present, how each reel breaks down, and which person can release each line today or mark it pending.
Use the steps below to reconcile site stock with your records, preserve per-reel detail, explain why each line is released, and connect labeled photos to the exact list lines. That combination lets reviewers understand your inventory basis and distinguish genuinely available reels from those still on hold.
The city’s automotive and advanced manufacturing page names four OEM vehicle production plants: the Sterling Heights Assembly Plant, Sterling Heights Stamping Plant, Ford Van Dyke Transmission Plant and Ford Axle Plant. This offers limited local manufacturing context for a current-balance workflow, not evidence that a named site has surplus cable.
Step 1 — Reconcile the physical stock
Start at the storage location and build a list from what you can see and identify. Compare each reel and package against your ERP export, purchase order, or project list. If there is a mismatch, record what is physically present, then note the documentation source so reviewers can recognize how you arrived at the balance.
Capture these evidence fields at minimum so your current list stands on its own without assuming prior totals are correct.
- inventory line
- reel ID
- storage location
- current stock status
Step 2 — Preserve per-reel quantities and continuous lengths
Do not combine reels or cutoffs that merely share a specification. Retain separate lines for full reels, partial reels, and any cut lengths. This keeps continuous footage clear and helps prevent overstating what can be pulled as one length.
Where measurement differs from documentation, say how you established the figure on each line. That transparency is essential to avoid repeating the common mistake of using the original invoice quantity as today’s available balance.
- reel count
- footage per reel
- continuous/cut length
- measured/documented/estimated basis
Step 3 — Explain why each line is released (or not)
State the disposition for every line: project overrun, supplier overage, discontinued stock, or facility closeout. If any quantity is still allocated to a job, pending a return, or under internal review, mark it reserved or pending. Name the approval owner so it’s obvious who can move the line to released status.
Clarity here prevents the error of declaring everything released. Instead, you present a clean split between currently sellable items and those that need a green light.
- release reason
- project/order reference
- reserved or pending status
- approval owner
Step 4 — Match your evidence to the list
Tie photos and markings directly to the list. Use the list’s line IDs on both the labels in photos and the filenames, then include the manufacturer and part number visible on the jacket or label. State the condition based on what you can observe at the storage site. Identify the release authority for each line so reviewers know who can confirm availability.
This tracing ensures that anyone reviewing your submission can match a photo to a listed line without guesswork.
- photo filenames
- manufacturer/part number
- release authority
- condition
Handling unknowns and pending approvals
If you cannot confirm a length or status, do not omit the line—include it with an honest basis. For example, add the line with an estimated or documented length basis flagged as such, and mark it pending if release is not yet approved. Note any missing reel IDs or unreadable labels and add placeholder photos of the reel and jacket markings you can capture.
This approach keeps your list accurate without overstating availability. It also aligns with the resolution to the common mistake: present a current balance with its evidence basis, retain per-reel lengths, and clearly label any reserved or approval-pending lines rather than assuming they can be sold.
