Metrics like ROI, productivity rate, or employee cost are essential for business owners. Tracking them, however, can be tricky. Many managers rely on weekly or even monthly reports, which, insightful as they might be, usually provide little time for corrective actions. Watching your metrics change in real-time is what allows you to react immediately to alarming situations. How can you stay on top of your sales KPIs? A smart way to do it is to utilize the data your team produces daily – timesheets – and use a tool that can run the numbers for you.

In this article, I will show you how to set up a sales KPIs report in Teamdeck (resource management software) that can provide you with up-to-date insights.

If you haven’t signed up to Teamdeck yet, start your 30-days free trial now. Then, head to the reports section to set up your analytics.

Of course, you can create a new report from scratch (click create custom) to do so, but I recommend using a report template called “KPIs”.

It is arranged to provide you with the following sales KPIs calculated separately for each of your projects:
– Productivity
– Employee Productivity Rate
– Employee cost
– ROI

Sales KPIs

All of these values are calculated in this table based on your team’s timesheets. You just need to fill out your company’s external and internal rates. Here’s how to do it:

Teamdeck - external rates

Sales KPIs you can measure with Teamdeck.io – the resource management solution

Productivity:

Productivity is the amount of money your project generates. You can calculate it by taking timesheets and your team’s external rate into account. This is how much you can expect your client to pay you for a given period.

External rate * Timesheets: Time

If your team members have different hourly rates you can fill out the internal rate and external rate columns for each team member separately so that you arrive at precise calculations:

Productivity Rate - sales KPIs

Employee Productivity Rate

Employee Productivity Rate is the average amount of revenue per employee. You can compare this number to the actual productivity of your team members to see which employees deviate the most from the average.

(Timesheets: Time * External Rate) / Number of People

Employee Cost

This metric shows you how much you have to spend on salaries for each project. It takes into account your team’s timesheets and their hourly rates.

Similarly to Productivity, if your team members have different hourly rates you can fill out the internal rate and external rate columns for each team member separately.

The employee cost formula:

Timesheets: Time * Internal Rate

ROI

ROI (Return on Investment) is the bottom line of your business profitability: how much money there is left once you cover your team’s salaries?

In order to calculate your project’s profit you have to take into account the revenue generated by your employees and their salaries:

Productivity – Employee Cost

Start tracking your company’s sales KPIs 

Sales KPIs report makes you aware of how your current projects affect the bottom line of your business. This, in turn, helps you make more informed decisions when it comes to planning new projects or recruiting extra people. With Teamdeck resource planning is easy – you can set up your company’s report in just a few minutes.

Want to be closer to resource management’s KPI’s? 

Want to check if your projects are profitable? Build your sales KPIs report with Teamdeck resource planning software

Related posts