Work Order Transaction Summary
- Andrew Finch
Summary/Use Case
Report Summary
The Work Order Transaction Summary report provides a consolidated overview of work order activity, summarized by vehicle and including totals for hours, labor, parts, tires, and overall cost. Fleet managers can use this summary to identify high-cost repairs, warranty utilization, and total effort spent across vehicles during a given timeframe. This report is especially relevant for operations and maintenance departments.
Use Case
Track overall maintenance costs by vehicle to identify high-cost units
Monitor use of internal vs. external labor and parts for budgeting insights
Evaluate warranty claim recovery trends
Use as a performance summary for internal reporting periods
Assist with identifying anomalies or errors in work order data
Location: Where to Find It
Reports > RTA Standard Reports > Work Order > Work Order Transaction Summary
Data Filter Prompts
You will be prompted for filtering of the Data to specify and narrow down the data that will be pulled. See Data Filter List Below for Options
Data Filter List
Filter Name | Recommended Filter Condition(s) | Value (Options) | Value (Default) | Value (Notes) |
|---|---|---|---|---|
Facility | Equal To | Any Facility Number | 1 - 99999 | Any Facility Range |
Vehicle | Is Between | Any Vehicle Range | blank - “zzzzzzzzzzzz” | Filters by vehicle range |
Date Range | Is Between | Any Date Range | First to Last Day of Previous Month | Filters data by date range |
VMRS Major | Is Between | 0 to 999 | 0 to 999 | Full range of VMRS Major code categories |
VMRS Inter | Is Between | 0 to 999 | 0 to 999 | Full range of VMRS Intermediate codes |
VMRS Minor | Is Between | 0 to 999 | 0 to 999 | Full range of VMRS Minor codes |
Report Output and Data Elements
Report Output
The Work Order Transaction Summary displays a table grouped by facility and vehicle, with calculated totals for various cost categories and work effort. Each row represents a vehicle with corresponding work hours, labor costs (internal, outside, and warranty), parts costs (internal, outside, and warranty), tire costs, and an overall total. Summation of totals provides visibility into the distribution and magnitude of repair efforts.
Report Data Elements
Column Number | Column Title | Data Notes |
|---|---|---|
1 | Vehicle | Identifier of the vehicle receiving work |
2 | Hours | Total labor hours charged |
3 | Labor Cost | Cost of internal labor |
4 | Outside | Cost of outsourced labor |
5 | Warranty | Labor cost covered under warranty |
6 | Parts Cost | Cost of internal parts used |
7 | Outside | Cost of outsourced parts |
8 | Warranty | Parts cost covered under warranty |
9 | Tires Cost | Internal tire-related costs |
10 | Outside | Outsourced tire-related costs |
11 | Warranty | Tire costs covered under warranty |
12 | Total | Sum of all costs for the vehicle, including labor, parts, and tires |