Rental Fleet Manager reports

The measures used in the Rental Fleet Manager reports are sourced from the Rental Utilization fact. These measures use Sum aggregation.

Top Avg Fleet Age

Description: This report shows the Item that are relatively old and have high Avg Fleet Age. Number of elements displayed is based on the Show N Records filter.

Measure: Avg Fleet Age

Chart type: 1 data series bar chart

Column selector: Item, Equipment Type, Equipment Group, Equipment Class, Serial Number

Bottom Avg Fleet Age

Description: This report shows the Item that are relatively new and have low Avg Fleet Age. Number of elements displayed is based on the Show N Records filter.

Measure: Avg Fleet Age

Chart type: 1 data series bar chart

Column selector: Item, Equipment Type, Equipment Group, Equipment Class, Serial Number

Avg Fleet Age vs Margin by Period

Description: This report shows the Avg Fleet Age, Rental Revenue, and Rental Cost Metric measures in trend with Year Period as category. In this report, you can analyze how the increasing average fleet age affects the revenue and rental cost metric of a fleet. You can select a specific equipment to check when the cost starts to overturn the revenue.

Measure: Avg Fleet Age, Rental Revenue, Rental Cost Metric (saved expression: Dynamic selection of measures with Rental Cost Metric filter)

Chart type: 3 data series combo, 1 column chart on Y axis 1 and 2 line chart on Y axis 2

Column selector: Year Period, Year

Top Maint and Rep Cost

Description: This report shows the top Item based on the Maint and Rep Cost measure. In this report, you can identify faulty items that the company is spending too much in maintenance and repair cost. Number of elements displayed is based on Show N Records filter.

Measure: Maint and Rep Cost

Chart type: 1 data series bar chart

Column selector: Item, Equipment Type, Equipment Group, Equipment Class, Serial Number

Bottom Maint and Rep Cost

Description: This report shows the bottom Item based on the Maint and Rep Cost measure. In this report, you can identify the items that the company is spending less in maintenance and repair cost. Number of elements displayed is based on the Show N Records filter.

Measure: Maint and Rep Cost

Chart type: 1 data series bar chart

Column selector: Item, Equipment Type, Equipment Group, Equipment Class, Serial Number

Rental Revenue vs Maint and Rep Cost

Description: This report shows the item and its rental revenue and maintenance and repair cost in a scatter plot chart. Using this report, you can identify cluster of items that have high maintenance and repair cost but low rental revenue.

Measure: Rental Revenue, Maint and Rep Cost

Chart type: 2 data series scatter plot chart

Column selector: Item, Equipment Type, Equipment Group, Equipment Class, Serial Number

Total Cost by Period

Description: This report shows the breakdown of cost measures in trend with Year Period as category. In this report, you can analyze in which cost measure a specific item tends to spend more. A column selector for Year is available to enable YoY analysis of the cost measures.

Measure: Maintenance Cost, Repair Cost, Depreciation Cost

Chart type: 3 data series column stacked chart

Column selector: Year Period, Year

Avg Fleet Age vs Margin Details

Description: This report shows detailed analysis of items with measures Avg Fleet Age, Rental Revenue, Maintenance Cost, Repair Cost, Maint and Rep Cost, Depreciation Cost, Maint and Rep vs Revenue Pct, sorted in descending order by Avg Fleet Age measure. By default, Item is shown as column. You can also use the column selector to check the other equipment attributes that are available for use.

Measure: Avg Fleet Age, Maintenance Cost, Repair Cost, Maint and Rep Cost, Depreciation Cost, Rental Revenue, Maint and Rep vs Revenue Pct

Chart type: Table

Column selector: Item, Equipment Type, Equipment Group, Equipment Class, Serial Number