Introduction
Understand in monetary terms the size of the issue/loss so that you can look to address any areas that will help mitigate unnecessary revenue leakage. Aimed at everyone in the business but most likely to be used by Senior Leadership who can then affect change. A powerful insight into just how much revenue has been lost through delays or poor process or Non-Starters!
Shows total volumes of unforeseen losses through Contract Non-Starters and Early Terminations, along with the associated lost revenue in terms of WGP. The main view is a combination of both groups, with the ability to view Non-Starters or Early Terminations as groups separately.
Detailed views of Non-Starters/Early Terminations as a % of expected Starters, reasons for not starting or termination, and top 5 total GP losses by Client and by Consultant. Also includes individual data about each Placement.
Finally, view revenue variation due to early endings or late starts by client or consultant.
Report highlight
Top 5 losses by Consultant and by Clients - are some of your Clients wasting your time? Are some of your Consultants making poor matches?
These reports, considering their importance, should be viewed weekly!
Who it's for
Team Leaders & Senior Leadership.
Summary of the Overview screen
1 Click the funnel icon to open a filter panel for slicing and refining the data.
2 Key metrics relating to Lost Revenue across all circumstances.
3 View volumes of unforeseen losses and associated lost Weekly Gross Profit .
4 Understand the reasons for Non-Starters and Early Terminations by category.
5 Line chart showing total WGP loss from the top 5 impacted clients with the greatest GP loss across the current calendar year.
6 Bar chart showing the top 5 clients who have the greatest GP loss.
7 Bar chart showing the top 5 consultants with greatest GP loss.
Summary of Non-Starters screen
1 Click the funnel icon to open a filter panel for slicing and refining the data.
2 Key metrics relating to Lost Revenue due to non-starters.
3 Combined chart showing the number of Non-Starters to Permanent Placements and associated lost Gross Profit across the current calendar year.
4 Bar chart showing number of non-starters by Category.
5 Line chart showing total WGP loss from the top 5 impacted clients with the greatest GP loss across the current calendar year.
6 Bar chart showing the top 5 clients who have the greatest GP loss.
7 Bar chart showing the top 5 consultants with greatest GP loss.
Summary of Early Terminations screen
1 Click the funnel icon to open a filter panel for slicing and refining the data.
2 Key metrics relating to Lost Revenue due to early terminations.
3 Combined chart showing the number of Early Terminations to Placements and associated lost Gross Profit across the current calendar year.
4 Bar chart showing number of early terminations by Category.
5 Line chart showing total WGP loss from the top 5 impacted clients with the greatest GP loss across the current calendar year.
6 Bar chart showing the top 5 clients who have the greatest GP loss.
7 Bar chart showing the top 5 consultants who have the greatest GP loss.
Summary of Revenue Variation screen
1 Click the funnel icon to open a filter panel for slicing and refining the data.
2 Key metrics relating to revenue variation due to placements ending early / deferred start dates and associated WGP loss / deferred revenue.
3 Bar chart showing the incoming WGP losses due to early ending placements across the current calendar year, per week. NOTE: The most recent week bar will be lower than the previous weeks depending on what day the report is being viewed (e.g. start versus mid-week will show different values as it updates daily).
4 Pie chart showing top 5 losses of WGP due to early ending placements by either Client or Consultant.
5 Bar chart showing sources of deferred revenue due to late starting placements across the current calendar year. Toggle between a stacked or exploded view for better visuals. NOTE: The most recent week bar will be lower than the previous weeks depending on what day the report is being viewed (e.g. start versus mid-week will show different values as it updates daily).
6 Pie chart showing top 5 deferrals of WGP due to late starting placements by either Client or Consultant.
Report summary
The Contract Lost Revenue report shows total volumes of unforeseen losses that occur through Contract Non-Starters and Early Terminations, along with the associated lost revenue in terms of the Weekly Gross Profit.
The main view is a combination of these two groups, and you have the ability to view a different page to see just the Non-Starters or just the data related to Early Terminations in isolation.
All of the pages have the same layout, and on each page the main chart focuses on the number of unforeseen losses, the lost weekly gross profit associated with those losses, and the average weekly gross profit lost per person.
On the right hand side, the categories which describe the reasons why the Placements have either not started or have been terminated are displayed, and at the bottom of the screen you see the raw data table that shows details of each Placement.
By switching the toggle from the Table view to Top Losses you can now see how your top five Clients by Profit have been impacted by any of these unforeseen losses. You also have a view of the top 5 losses by Consultants which shows the 5 Consultants who have been associated with the highest value of losses.
You can filter the report in a number of ways including selecting the date range that you wish to view, or splitting the data down by Business Unit, Team, Territory, Site, Consultants or by Client.
Glossary of terms for this report
Headlines
Unforeseen Losses - a count of Contract/Temp Placements that start with a status including Cancelled or Terminated.
Non-Starters - a count of Contract/Temp Placements that start with a status including Cancelled.
Early Terminations - a count of Contract/Temp Placements that start with a status including Terminated.
Avg Weekly Gross Profit – average weekly margin (gross profit) lost for Contract/Temp placements that start with a status including Cancelled and/or Terminated (depending on page).
Total Weekly Gross Profit - the total weekly margin (gross profit) lost for Contract/Temp Placements that start with a status including Cancelled and/or Terminated (depending on page).
Avg Gross Profit - the average gross profit lost for Contract/Temp Placements that start with a status including Cancelled and/or Terminated (depending on page).
Total Gross Profit - the total gross profit lost for Contract/Temp Placements that start with a status including Cancelled and/or Terminated (depending on page).
Losses Rate % - Contract/Temp Placements that start with a status including Cancelled and/or Terminated (depending on page) as a percentage of all Placements.
Visuals
By Category - comes from Placement status.
WGP Loss for Top 5 Contracting Clients over time - the weekly margin (gross profit) lost for the top 5 Contract/Temp Clients by gross profit for Contract/Temp Placements that start with a status including Cancelled and/or Terminated (depending on page).
Total GP Loss for Top 5 Contracting Clients - the total gross profit lost for the top 5 Contract/Temp Clients by gross profit for Contract/Temp Placements that start with a status including Cancelled and/or Terminated (depending on page).
Top 5 Losses by Consultant - the 5 Consultants with the highest total gross profit lost for Contract/Temp Placements that start with a status including Cancelled and/or Terminated (depending on page).
Authored by Andy Montague - Product Manager @ Mercury