Report Overview and Usage

 

Prospect Report

Content of Report

Views

Use

Coverage Activity

  • list of active Cases and their Coverages
  • Due Dates and Effective Dates of Coverages by Sponsor
  • Summary of Coverages by Product Profit Center (for a RRAC Person)
  • by RRAC Person
  • monitor due dates and effective dates of coverages
  • increase underwriting productivity

Coverage vs Proposal

  • number of Coverages and their outcomes from Coverages received to Coverages Proposed for a rolling 12- month period
  • by Office and Region
  • by Product Profit Center
  • by Rep and Office
  • by RRAC Person
  • manage Rep and Distributor activity and overall pipeline
  • identify high volume Distributors and Coverages and DTQ patterns at both UW and Quote

Prospect Activity

  • list of Cases and their Prospects
  • number of lives
  • status of Coverage Group
  • premium
  • Due Date / Effective Date
  • Distributor
  • by Profit Center
  • by Rep and Office
  • identify sales pipeline activity
  • identify activity by product to manage sales goals

Prospect Status

  • daily status of active Prospects
  • number of Prospects received in the RRAC but not quoted or DTQ’d that are so many days before Due Date or after date received
  • number of rates released to Reps but not Quoted or Lost so many days after release
  • number of Proposals released to Distributors but not lost or sold so many days before the Effective Date
  • hyperlink to list of Prospects
  • by Office and Rep
  • by Product Profit Center
  • monitor daily status of active prospects
  • measure Rep responsiveness from rates released to Proposal
  • manage time and dates in the RRAC
  • measure time between Proposal delivery and Effective Dates

Prospect Trend

  • number of Prospects received by month for current and previous years
  • hyperlink to list of Prospects

  • by Office, Rep and Territory
  • by Profit Center
  • manage Rep activities in Territories
  • reassign or expand Territories

Prospect vs Goal

  • all Prospects received in a month
  • bar charts comparing Prospects and goals by Product Profit Center
  • by Rep, Office and Region
  • manage monthly Prospects

Prospect vs Goal Comparison

  • number of Prospects received by month for the current and previous year
  • percentage of goals reached
  • by Office and Region
  • by Product Profit Center (detailed)
  • by Product Profit Center (Product)
  • by Rep, Office and Region
  • manage actual activity to goals

Activity Turnaround

  • number of RRAC Activities that have been completed for Coverage Groups in a given period
  • turnaround time for each completed RRAC Activity for Coverage Groups
  • summary pages
  • by RRAC Person

  • monitor turnaround times for RRAC activities

Missing InformationTrend

  • number of Coverage Groups that are missing information for the past 12 months
  • number of Coverage Groups that have received missing information in the past 12 months
  • summary pages
  • by Market Segment and Region
  • by Profit Center and Region
  • monitor trends in the number of Coverage Groups that are missing information
  • measure the number of Coverage Groups that receive missing information

On Time Quote Matrix

  • comparison of requested and actual turnaround time for Coverage Groups that had rates released (current week, current month, or year-to-date)
  • summary pages for Office and Region
  • by Profit Center
  • by Group Office and Region
  • by End Result
  • monitor quoting turnaround times for Coverage Groups that had rates released

On Time Quote Trend

  • percentages of Coverage Groups in past 12 months that were quoted on time to the original Due Date
  • percentages of included Coverages that were on time to the Due Date and at least once in the Follow-up on MI Activity (past 12 months)
  • total number of quoted Coverage Groups (summary pages)
  • by Market Segment
  • by Region
  • by Office
  • by Rep 
  • monitor quoting turnaround times for Coverages in relation to missing information

Target

  •  list and summary of active Coverage Groups based on Rep and RRAC targets
  • current workflow activity of the Coverage Group
  • Sales Rep Target
  • Underwriter Target
  • view the status of hot Cases

Tracking

  • list of Group Offices that submitted Coverage Groups in a particular month
  • total number of Coverage Groups received from a Group Office in a month (based on RFP-Received Date)
  • total number of Coverage Groups

Underwriter Tracking:

  • by Profit Center
  • by RRAC Person
  • by month for rolling 12 months

Coverage Group Tracking:

  • by Profit Center
  • by month for rolling 12 months

Plan Design Tracking:

  • by Profit Center
  • by Product Line
  • by month for rolling 12 months
  • monitor RRAC productivity for underwriting, Coverage Groups and Plan Designs

Workload Balancing

  • details about current workload in the RRAC
  • by Region and Role (summary pages)
  • by RRAC person
  • manage the distribution of work among RRAC Persons

New Business Inventory

  • details about current workload in the RRAC by activity
  • by Office, Region and RRAC Person
  • by Office, Region and RRAC
  • by Rep, Office and Region
  • manage the distribution of work among RRAC Persons