ABQ Plumbing — Assets Warehouse Stocking

Live from ServiceTitan via Peaka — every table on this page runs its query fresh each time you open it, no manual refresh needed. Three views: seasonal pre-stocking for the 115 heating/cooling items pulled by maintenance departments, the same period-based math run across the full 2,846-item warehouse catalog, and whether the data supports splitting truck templates into Service vs. Install per trade.
Checking data freshness…

Seasonal items & pre-season stock targets — Assets Warehouse

Loading…
Scoped to material drawn by maintenance departments (HVAC, Plumbing, Electrical & Commercial Maintenance business units), matched against the Assets Warehouse's own par catalog. An item is flagged seasonal when its average monthly draw during the peak months runs at least 2.5× its average draw the rest of the year. Suggested max = that period's weekly draw × the period's length in weeks (enough to run the whole period with no mid-period reorder, 3-week lead time). Suggested min = weekly draw × 3 weeks. Figures are rounded up to whole units.

Suggested min/max by period — click a period, then click an item for the math

ItemSeason Suggested minSuggested max Current (static) Min–Max$ value at suggested max
Loading live data…

Full warehouse stock — all materials, by period

Loading…
Every item in the Assets Warehouse catalog with real usage (not just the flagged seasonal ones), company-wide draw across all business units. Same period math as Seasonal Stocking — suggested max = weekly draw × period length, suggested min = weekly draw × 3-week lead time, rounded up to whole units.

Itemized — pick a period, click a row for the math

ItemSuggested minSuggested max Current (static) Min–Max$ value at suggested max
Loading live data…

Service vs. Install — can 2 new truck templates be gleaned from the data?

Loading…
Classified by the business unit on the invoice line (HVAC/PLUMBING/ELECTRICAL × SERVICE/INSTALL), matched to the Assets Warehouse catalog. There's no vendor lead time for a truck (resupplied from the warehouse, not a supply house) — suggested min = 2 weeks of draw, suggested max = 4 weeks of draw, rounded up.

Itemized — pick Service or Install, click a row for the math

ItemMonths activeAvg monthly qty Suggested minSuggested max$ value at suggested max
Loading live data…