Tool Day – Free Payroll Productivity Worksheet

Starting today, and every Friday (fingers crossed), I will work on posting another retail tire and service tool.  Today I am posting a Daily Payroll Productivity Worksheet that I put together and it seems to work really well.  The Worksheet is pretty straight forward, enter your Total Sales, Service Sales, Technician & Sales Associate payroll information daily and in turn the Worksheet will produce:

  • Vehicle Service Associate Payroll percent to Sales
  • Customer Service Associate Payroll percent to Sales
  • Total Payroll percent to Sales
  • Effective hourly rate of pay for Flat Rate Technicians and your Sales Team

There is even an area to adjust for Fringe (taxes, benefits, etc) and spiffs for your sales team.

Benchmarks are listed at the top of the page.  Most Retail Tire Stores shoot for:

  • 20% Vehicle Service Payroll/Service Sales  
  • 10% Customer Service Payroll/Total Sales
  • 30% Total Payroll/Total Sales

You can find further posts covering additional tools that may be helpful to your business here.

You can down-load the Daily Payroll Productivity Worksheet here.

Let me know if you have any questions.  Also – The sheet is protected so the formulas are not over-written.  There is no password.  Just “un-protect” the sheet in excel, then you can modify the worksheet to your liking.

Good Selling!

About Patrick Murphy

I have spent the past eighteen years producing, coaching and mentoring retail teams. The past six have been in support of Independents across Western US. Although, I have worked most of my career in automotive retail, It hasn’t and never will be about “cars and trucks.” What it has been about is the challenge and satisfaction of helping people with all types of backgrounds to realize their potential.
I am very proud that many of my former teammates have gone on to do some pretty terrific things with their life. Several are currently running their own groups and a few have even opened their own businesses.
My assignments with Bridgestone Firestone and TBC Corporation has offered me the opportunity to work in and become familiar with many markets across the country. From my hometown of Philadelphia, to Boston, Arizona, Dallas, New Mexico, Florida and Southern California. Each market has presented its own unique set of challenges, but at the end of the day, it always came down to three things: people, process and execution.