Introduction
Understand in monetary terms the size of the issue/loss in order to address any areas that will help mitigate unnecessary revenue leakage. 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.
Report highlights
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 All Losses page
1 Click the funnel icon to open a filter panel for slicing and refining the data. The Date Period filter is applied automatically.
2 View volumes of unforeseen losses and associated lost Weekly Gross Profit .
3 Understand the reasons for Non-Starters and Early Terminations by category.
4 Line chart showing total WGP loss from the top 5 impacted clients with the greatest GP loss across the current calendar year.
5 Bar chart showing the top 5 clients who have the greatest GP loss.
6 Bar chart showing the top 5 consultants with greatest GP loss.
Summary of Early Terminations page
1 Click the funnel icon to open a filter panel for slicing and refining the data. The Date Period filter is applied automatically.
2 Combined chart showing the number of Early Terminations to Placements and associated lost Gross Profit across the current calendar year.
3 Bar chart showing number of early terminations by Category.
4 Line chart showing total WGP loss from the top 5 impacted clients with the greatest GP loss across the current calendar year.
5 Bar chart showing the top 5 clients who have the greatest GP loss.
6 Bar chart showing the top 5 consultants who have the greatest GP loss.
Summary of Non-Starters page
1 Click the funnel icon to open a filter panel for slicing and refining the data. The Date Period filter is applied automatically.
2 Combined chart showing the number of Non-Starters to Permanent Placements and associated lost Gross Profit across the current calendar year.
3 Bar chart showing number of non-starters by Category.
4 Line chart showing total WGP loss from the top 5 impacted clients with the greatest GP loss across the current calendar year.
5 Bar chart showing the top 5 clients who have the greatest GP loss.
6 Bar chart showing the top 5 consultants who have the greatest GP loss.
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 reports remain the same across each page for easy comparison and insight into reasons for lost revenue.
All of the pages have the same layout, and on each page the main chart focuses on the number of unforeseen losses and the lost weekly gross profit associated with those losses.
You also have a view of the (up to) top 5 losses by Consultants/Clients which lists those 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