Case Study: Vospers BI Solution
"We chose RWA because of their ability to integrate with many different data sources, their ability to present information cleanly and succinctly in the context of how it will be used and actioned. We have been really impressed with their track record, testimonials from their customers and their commercial mindset and agile way of working."- Nick Vosper, Managing Director, Vospers
Like other multi-site, multi-franchise auto dealers, Vospers found data was difficult to extract from their CDK DMS and consequently information resided in many different custom reports and spreadsheets. This required a major collation effort from the accounts and management function which inevitably meant that information was not always to hand when required and not all bases could be consistently covered. Their requirement was to bring all this data together into one place so that they could have executive dashboards that were drillable by outlet, franchise for new cars, used cars, parts and service. They also required information and reports to be disseminated automatically to each manager, based on their job role. After extensive market research, Vospers concluded RWA’s secure cloud solution ticked all the boxes at an affordable price.
RWA in partnership with Vospers installed a cloud based Business Intelligence solution that extracts data from the DMS, Budgets, OEM’s and other third parties then presents KPI’s and actionable information measuring performance levels by location, department, and even down to team member level.
Key insights include:
- Drillable Executive Dashboards showing all major KPI’s.
- Daily & Weekly Branch KPI tracking & action reports.
- Continuous oversight of performance against manufacturer objectives with
- what if’s.
- DOC (Daily Operating Controls) showing sales, upsells, enquiries and
- prospecting against targeted activity.
- Full analysis of vehicle stock by age, payment terms, likely profitability.
- Salesperson and management views on Sales, GPU, upsell, financing /
- insurance and showroom activity.
- Trade Partner parts analysis showing profitability & geolocations/van routes.
- Parts stock analysis based on overstocks and target achievement.
- Workshop performance metrics.
- Exception reporting based on aged WIPs, parts not located, RTS codes.
- Technician, Parts/Service Advisor views based on their activity levels.
Established in 1946, Vospers is a multisite, family owned, AM 100 dealer group operating with 11 different franchises across Devon and Cornwall.
The company employs over 700 staff, has a turnover in excess of £250 million and has won numerous awards for excellence in customer satisfaction & performance.
- Much greater transparency and accountability across all levels.
- Ability to continuously focus on performances levels by Person / Brand / Site.
- Realign management and staff roles based on much better information quality.
- Switching from collation effort to thinking time to take strategic actions.
- More consistent achievement against targets driving better results.