High-Low Use Parts

COMING SOON!

Summary/Use Case

Report Summary

The High-Low Use Parts report provides a detailed list of parts filtered by their usage frequency over a specified date range. Fleet managers can use this report to quickly identify which parts are being used most/least often, enabling better inventory control and purchasing decisions. This helps ensure parts availability while avoiding overstocking rarely used items.

Use Case

  • Identify frequently used parts to maintain optimal stock levels

  • Highlight low-use parts for potential removal from inventory to reduce carrying costs

  • Support budgeting and purchasing decisions based on actual usage trends

  • Detect unusual usage spikes that may indicate maintenance or operational issues

Location: Where to Find It

Reports > RTA Standard Reports > Parts > High-Low Use Parts

image-20250813-131720.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

Parameter List

image-20250813-131747.png

Parameter Name

Value (Default)

Please select High or Low for usage filtering; selecting High will pull parts with usage greater than or equal to and selecting Low will pull parts with usage less than or equal the selected usage value

High

Enter the usage threshold (High = minimum, Low = maximum) for the date range

3

Data Filter List

image-20250813-131846.png

Filter Name

Recommended Filter Condition(s)

Value (Options)

Value (Default)

Value (Notes)

Facility

Equal To

1 - 99999

1

Part Number

Is Between

First possible value, Last possible value

First possible value, Last possible value

" " represents first possible value, "zzzzzzzz" represents last possible value

Starting Date (Condition must stay Greater Than Or Equal To)

Greater Than Or Equal To

Any valid date

Previous 90 Days

Start date for pulling usage data

Report Output and Data Elements

Report Output

The High-Low Use Parts report displays a tabular view of part usage data for the selected facility and date range, filtered by the specified usage threshold. The output includes details such as part numbers, descriptions, last date used, pricing, inventory levels, and calculated totals. The report also provides overall totals for usage quantity, current inventory value, and current total value.

Report Data Elements

image-20250813-132057.png

Column Number

Column Title

Data Notes

1

Part Number

Unique identifier for each part in the inventory.

2

Part Description

Text description of the part.

3

Last Date Used

Date when the part was last issued or consumed.

4

Bin Location

Primary storage location code for the part.

5

Average Price

Average cost per unit of the part.

6

Beginning Inventory

Quantity of the part in stock at the start of the date range.

7

Beginning Value

Total value of beginning inventory (Beginning Inventory × Average Price).

8

Usages

Number of times the part was used during the date range.

9

Current Inv

Current quantity of the part on hand.

10

Current Total

Total current inventory value (Current Inv × Average Price).

Part Count

Count of distinct parts within report

Total Current Inventory

Sum of all parts on-hand

Total Current Total Value

Grand total of current total values on-hand