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

image-20241111-162215.png

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

image-20241111-162240.png

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

image-20241111-162307.png

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.