Inventory

Building products & industrial supply
Data updated 12:45Checked 12:46Sign 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
29
29 total, 1 past due
Overdue
1
past their target date
Owed to you
$1,154,604
$0 over 60 days
Spend
$1,265,587
1,544 transactions
Stock value
$1,298,442
118 stocked lines
Run out ≤ 30 days
4
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. 4 stocked items had no recent volume and are not projected.

ItemOn hand · paceRuns out in
TLS-BLD-7285 on hand · 16.1/day18 days
LMB-2X4-9243 on hand · 2.3/day19 days
TLS-GLV-L286 on hand · 15.1/day19 days
CON-MESH-6697 on hand · 4.7/day20 days
ELE-BOX-1G228 on hand · 7.5/day31 days
PNT-INT-5200 on hand · 5.0/day40 days
FLR-LVP-24342 on hand · 8.0/day43 days
PLB-VLV-34680 on hand · 14.0/day49 days
PLB-PEX-100694 on hand · 14.2/day49 days
ELE-BRK-20496 on hand · 7.1/day70 days
DRY-MUD-5357 on hand · 5.0/day71 days
DRY-12-48529 on hand · 7.5/day71 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-18Selma399d ago
DRY-12-48Four Oaks390d ago
SID-FC-12Four Oaks387d ago
CON-VB-10Selma376d ago
MIL-CAB-B36Selma358d ago
SID-FC-12Smithfield356d ago
LMB-2X10-16Four Oaks340d ago
ROF-DRIP-10Smithfield336d ago
PNT-PRM-5Selma307d ago
SID-FC-12Selma299d ago
ELE-RMX-250Four Oaks267d ago
DRY-58-FCFour Oaks266d ago