Cost analysis report

The Fleet app allows for analysis on total vehicle costs, including both contract costs and service and repair charges. Data can be adjusted to view total costs by vehicle or driver. Additionally, costs can be compared with the previous year, quarter, or month, to view changes in fleet costs over time.

Total costs

To view the Cost Analysis Report, navigate to Fleet app ‣ Reporting ‣ Costs. The default report shows a bar chart of service and contract costs for the current year, organized by month.

Example

In this report, it is possible to determine that June had the highest total costs, with almost $14,000 dollars in contract and repair costs, while January had the lowest costs, with less than $2,000 of contract costs and no repairs.

The default cost analysis report showing contract and service costs.

Cost by vehicle

Some companies want to view costs not by month, but by vehicle. This allows fleet managers to determine which vehicles cost the most to keep on the road, aiding in decision making for future purchases and repairs.

To view these metrics, open the default cost analysis report. Next, click into the search bar, and click Vehicle under the Group By column.

Example

From this report, it can be determined the Toyota Corolla with the license plate STU-1718 cost the most, with almost $14,000 in costs for the year. Additionally, the both Nissan Micro vehicles and the Ford Focus cost the least, with under $5,000 in total costs each.

The cost analysis report showing annual costs by vehicle.

Cost by driver

Another useful metric is to determine which drivers incur the most repair costs, allowing fleet managers to determine which vehicles to assign which drivers. To view this configuration, open the default cost analysis report. Next, click into the search bar, and click Driver under the Group By column. Finally, click the (Pivot) icon.

The report now shows the totals for both Contract and Service costs for each driver in the database. This allows fleet managers to see which drivers incur the most repair costs.

Example

This report shows that Sandra Elvis had no service costs for the year, while both Doris Cole and David Armstrong had almost $9,000 in repairs. While this does not explain why those two drivers incurred the most costs, it is possible for the fleet manager to investigate the service records for those two drivers, to determine why there were such high costs for the year.

The cost analysis report showing costs by driver in a pivot table.

Detailed comparison

All reports in the Fleet app are able to compare costs from previous time periods, either year, quarter, or month. To view a detailed cost comparison between the third and fourth quarter, open the default cost analysis report, then click the (Pivot) icon. Next, click into the search bar and click Q4 in the Filters column, then Date: Previous Period in the Comparison column.

The report now shows detailed contract and service costs for each vehicle, with a Variation column, showing increases or decreases in costs from the third and fourth quarter of the current year.

Example

In this example, it can be determined that the Ford Focus had the greatest change in terms of lowered total costs, with a 75.25% reduction in costs. Additionally, the Nissan Micro with the license plate of DEF-456 was the only vehicle with an overall increase in total costs, with an increase of 41.78%.

A pivot table with a detailed cost comparison between the current and previous year.