Open Stats

Reports > Work Orders > Open Stats shows the state of a group scheme's open work orders: how long they have been open and how long since they were last actioned, by status, location, retailer branch and product model. It needs a group scheme chosen in the header (see Reports); it has no date filter, as it reads the work orders open now.

What it shows and why

The report covers every open work order of the scheme, grouped four ways: by status, by the location doing the work, by the retailer branch it came from and by the product model. For each group it gives how many work orders are open and the shortest, longest and average time they have waited.

It portrays the scheme's backlog: where work is sitting, how long it has been there and how long since anyone touched it. A high average age against a status shows work stalling at that step; a high time since last action against a location shows work being left; a model standing out shows a product that is hard to fix or short of parts.

Use it to manage the queue week to week: to chase the oldest work, to move work from an overloaded location, and to answer a client asking how their open jobs are going.

Statuses

One row per status with the number of open work orders in it, and for each the shortest, longest and average time in days since the work order was last actioned (Act) and since it was created (Age). The summary row averages the columns.

Age by Location, Age by Branch, Age by Model

The same shortest, longest and average age in days, and the count, of the open work orders grouped by the location they are allocated to, by the retailer and branch they came from, and by the product's brand, type and model. Each grid has its own Export.