Inventory

Building products & industrial supply
Data updated 15:24Checked 15:24Sign in Refresh
Sample data. Every figure, product and customer name is invented to show the shape of the tool. Real numbers appear once your own data is loaded.
PeriodScopes every figure and every tab below
Active work
3
3 total, 1 past due
Overdue
1
past their target date
Owed to you
$58,203
$0 over 60 days
Spend
$98,975
298 transactions
Stock value
$1,298,442
118 stocked lines
Run out ≤ 30 days
0
at the last 90 days' pace
Below reorder
14
lines needing a buy
Stale counts
15
not counted in 180 days

Download the count sheet (CSV) system quantities shown, Count column blank — the tic-marks replacement

Projected to run out

Days of cover at the last 90 days’ purchase_orders order volume — a proxy for consumption, not a measurement of it. On hand is summed across locations. 21 stocked items had no recent volume and are not projected.

ItemOn hand · paceRuns out in
LMB-2X4-9243 on hand · 1.1/day41 days
DRY-MUD-5357 on hand · 3.7/day96 days
TLS-BLD-7285 on hand · 2.9/day98 days
PNT-PRM-5319 on hand · 1.2/day273 days
LMB-OSB-716779 on hand · 2.8/day274 days
ELE-BOX-1G228 on hand · 0.8/day302 days
ROF-DRIP-10467 on hand · 1.4/day345 days
PLB-VLV-34680 on hand · 1.9/day362 days
LMB-2X10-16568 on hand · 1.5/day370 days
PNT-INT-5200 on hand · 0.5/day375 days
DRY-58-FC377 on hand · 0.9/day409 days
LMB-2X6-16260 on hand · 0.5/day557 days

Stock value by branch

Smithfield437KFour Oaks344KSelma269KClayton248K
CategoryValue
Smithfield437K
Four Oaks344K
Selma269K
Clayton248K

Stock value by category

Siding256KMillwork222KRoofing181KConcrete & Masonry173KElectrical163KPaint & Sundries61KFasteners60KLumber56KPlumbing50KFlooring44KDrywall25KTools & Safety7,190
CategoryValue
Siding256K
Millwork222K
Roofing181K
Concrete & Masonry173K
Electrical163K
Paint & Sundries61K
Fasteners60K
Lumber56K
Plumbing50K
Flooring44K
Drywall25K
Tools & Safety7,190

Below reorder point

On hand is under the level this item is meant to hold.

PNT-PRM-5Smithfield107 short
SID-FC-12Clayton103 short
DRY-58-FCSmithfield89 short
LMB-2X4-92Four Oaks56 short
ROF-DRIP-10Smithfield33 short
LMB-PLY-34Clayton16 short
LMB-2X4-92Smithfield15 short
SID-FC-12Four Oaks12 short
CON-MESH-66Clayton11 short
ELE-BRK-20Clayton11 short
TLS-GLV-LFour Oaks10 short
CON-VB-10Selma8 short

Not counted recently

A stock figure nobody has checked in six months is a number, not a fact.

LMB-LVL-18Selma458d ago
DRY-12-48Four Oaks449d ago
SID-FC-12Four Oaks446d ago
CON-VB-10Selma435d ago
MIL-CAB-B36Selma417d ago
SID-FC-12Smithfield415d ago
LMB-2X10-16Four Oaks399d ago
ROF-DRIP-10Smithfield395d ago
PNT-PRM-5Selma366d ago
SID-FC-12Selma358d ago
ELE-RMX-250Four Oaks326d ago
DRY-58-FCFour Oaks325d ago