RedClay utilized a centralized SQL Server database & Microsoft’s .NET framework to tie in diverse data sources and provide timely sales & financial information.

The 4th largest dealership in the United States, McCombs Enterprises needed a better handle on dealership activity.

Description & Features
The Sigma Application (as it was named) is accessed via a browser with additional security permissions set for specific user & administrative access. Information relating to a vehicle sale is imported from the Reynolds & Reynolds (R&R) auto dealership system. Financial Institutions (GMAC, Ford Motor Credit, Security Service, Frost Bank, etc...) provide monthly reports on deals financed through each dealership detailing each sale and financing terms. These reports are cross-referenced with the Sigma Analysis Tool for verification. Any missing information is then input into the database. Once data is verified and posted, statements & invoices are generated and printed for each Dealership. Statements are maintained in the database to allow historical referencing, analysis and trends reporting.

The McCombs Sigma Enterprises Web Application automatically analyzes each sale for compliance with a predetermined criteria, such as terms within a certain range, rule of 78s for comparison purposes, etc. It comes with a complete set of data analysis tools to determine trends, sales volume, average financing terms, etc, as well as tracking payoff status, cancellations (repossessions, refinancing etc.) and any adjustments. It provides an overview of critical sales and financial information which can then be drilled down to a Dealership and even to a specific deal if necessary.

Through Key Performance Indicators established when developing the progam, Sigma provides relevant measurements to determine the organization's current sales performance.