Parts Usage by WO
Summary/Use Case
Report Summary
The Parts Usage by WO report provides detailed insights into the parts used in various work orders, capturing essential data like part numbers, transaction dates, descriptions, work orders, vehicles, VMRS codes, part types, quantities, prices, and total costs. Fleet managers can leverage this report to track parts utilization across work orders, helping to optimize inventory and identify trends in part usage across different vehicles.
Use Case
Monitor parts consumption across work orders to manage inventory effectively.
Identify high-usage parts and plan for adequate stock levels.
Analyze part costs associated with different work orders for budgeting.
Review specific parts used within date ranges for accountability and auditing.
Assess trends in vehicle part usage to assist in predictive maintenance planning.
Location: Where to Find It
Reports > RTA Standard Reports > Parts > Parts Usage by WO
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) |
---|---|---|---|
Facility | Is Between | 1 - 99999 | 1 - 99999 |
Date | Is Between | Any Date Range | 10/12/2024 to 11/11/2024 |
Part Number | Is Between | blank to zzzzzz | blank to zzzzzz |
Report Output and Data Elements
The Parts Usage by WO report presents a detailed list of parts used in various work orders, including key information such as part numbers, transaction dates, descriptions, associated work orders, vehicles, VMRS codes, part types, quantities, unit prices, and total costs for each part entry.
Report Output
Report Data Elements
Column Number | Column Title | Data Notes |
---|---|---|
1 | Part Number | Unique identifier for each part used. |
2 | Trans Date | Date when the part transaction occurred. |
3 | Desc | Description of the part. |
4 | Work Order | Identifier for the associated work order. |
5 | Vehicle | Vehicle associated with the part usage. |
6 | VMRS Code | VMRS code for categorizing the part usage. |
7 | Type | Type of part (e.g., file part, non-file part). |
8 | Quantity | Quantity of the part used. |
9 | Price | Unit price of the part. |
10 | Total | Total cost (quantity multiplied by price) for each part. |