eProfitFocus’ Dynamic KPI Reports are a powerful tool that allows you to make timely, value adding decisions that make a real difference to your bottom line. The dynamic nature of the reports allow you to quickly analyse and compare your performance across different time periods, market segments, brands, regions – at both the high level or by department. Compare their performance against individual industry constituents, a national benchmark and the industry average – highlighting areas of potential growth and market opportunity.
Industry Insights Dynamic Reports vs Franchise Insights Dynamic Reports
Dynamic reports can be run in two forms: industry or franchise. The industry version uses total dealership data (i.e. performance of the entire dealership). In contrast, the franchise version will only use reporting franchise specific data (i.e. the brand that you report to eProfitFocus with) and compare this to other dealerships that trade in the same franchise – also using only their reporting franchise specific data.
Guide to using Franchise Profitability - Dynamic Reports
Once logged in, click on Franchise Profitability – Dynamic under the ‘Report Tab’.
Tailor the dealerships/franchises for which a comparison would like to be made by selecting appropriate paramters.
A) Time Period: A minimum of one month must be selected.
B) Country: Only dealerships from the country in which you trade will be selected for comparison.
C) Franchise: Only the franchise to which you report to eProfitFocus for will appear in the criterion as this is a Franchise Insights report.
D) State: Only deaerlships from your selection of states will be selected for comparsion. To show national performance, simply ‘Select All’ for this criterion.
E) Region: Multiple regions, or a single region may be selected. If ‘Metro’ is selected, the report will only compare the user’s deaerlship against metro dealerships.
F) Composite Type: The key metric from which dealerships are ranked. If ‘Net Profit % Sales (Net Profit Margin), New, Used, Parts or Service’ are selected, only the dealerships that have performed the strongest in the respective department will be included in the report – the rest will be excluded. If ‘Average’ is selected, all dealerships in the database will be included in the report – no dealerships will be exlcuded (except for those dealerships that do not meet the paramters above).
G) Top: Defines how the top dealers from ‘Net Profit % Sales, New, Used, Parts or Service’ are selected.
After clicking view report, a graph containing the key metrics and a profitaiblity summary table will be displayed. Sales revenue, gross profit and department selling gross profit can all be expanded – detailing the compsition of their total values. Similarly, state and region, which runs across the top, can also be expanded.
The average column displays the average results of the top dealers included in the report. Next to this is the dealer’s own data which can be used as a comparison and a source of information for value adding decision making.
The report can be saved byclicking on the ‘Export’ button contained within the report. The report may be saved in any number of formats, including Excel and PDF.