Wicks — Inventory Unit Cost Analysis

Quantity on hand comes from ServiceTitan's Aggregate Inventory Stock report as of the transaction cutoff. Unit cost is ServiceTitan's current average cost (not the pricebook cost), at full precision (no rounding). ServiceTitan doesn't keep a history of average cost, so past cutoffs show today's average cost; total value = quantity at cutoff × average cost. Any cutoff in the last 90 days can be picked, plus any month-end in the last 24 months; each cutoff is pulled from ServiceTitan the first time you pick it, so allow a minute. For the count adjustment range, if an item + location was adjusted more than once in the range, the latest adjustment is used; its date is shown in the Adjustment Date column.