Franchise Profitability


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

Step 1

Once logged in, click on Franchise Profitability – Dynamic under the ‘Report Tab’.

Step 2

Tailor the dealerships/franchises for which a comparison would like to be made by selecting appropriate parameters.


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 dealerships from your selection of states will be selected for comparison. 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 dealership 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 excluded (except for those dealerships that do not meet the parameters above).
G) Top: Defines how the top dealers from ‘Net Profit % Sales, New, Used, Parts or Service’ are selected.

Step 3

After clicking view report, a graph containing the key metrics and a profitability summary table will be displayed. Sales revenue, gross profit and department selling gross profit can all be expanded – detailing the composition 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.

Step 4

The report can be saved by clicking on the ‘Export’ button contained within the report. The report may be saved in any number of formats, including Excel and PDF.