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