Who doesn’t want to save money in today’s economy? In any economy? Tecta America saw potential to do just that in its vendor rebate programs. As a national commercial roofing contractor comprised of 27 companies, this coast-to-coast business had a range of vendors providing critical materials needed for Tecta America to deliver its roofing products to consumers. Each vendor manages its own set of incentives and quotas for receiving rebates – important rebates that help Tecta America reach its profit goals. With such a wide range of vendors, and the corresponding range of rebate programs, Tecta America needed a way to understand which vendors they should turn to for critical purchases, shifting purchasing behavior to focus strictly on price.
We’ve got a solution for that – Time for business intelligence
Tecta America needed something better than spreadsheets – something that offered flexibility across their 27 companies and reliable, immediate access to data – to manage its vendor rebate programs.
Enter: SPR Consulting.
Our team designed and deployed a solution that empowered the Tecta America team with:
What goes into a solution like that, anyway?
The right tools are a great start, but empowering people to use those tools is where the real magic happens. SPR Consulting constructed a prototype to demonstrate how a BI solution would successfully address Tecta America’s requirements.
Then, we built a custom solution using a Microsoft SQL Server BI toolset that extracted data from the Microsoft Dynamics NAV back-end system. Functionality was added so users could log on to view the reports and data with Microsoft Office SharePoint Server 2010. PowerPivot enabled the analysis of data from multiple sources.
The endless possibilities for data
New access to better data (thanks to SPR Consulting) meant better purchasing decisions across multiple vendors. Tecta America reached varying discount ‘gates’ among its vendors while modeling historical data from their ERP system against a rebate management application to gauge purchasing threshold.
So, what was the ROI? How about 6:1. The actual number is pretty impressive – Tecta America earned an additional $600,000 in vendor rebates in just six months.