Met and Haven't Met Worksheet Closed Sales Goal
100
Option 1: Met database = 2 Sales/12 names # of names needed per sales (2 sales/12 names = 1 sale/ 6 names) Total Number of Met Contacts needed to achieve Sales Goal
6 600
Option 2: Haven't Met Database 1 Sale/50 Names # of names needed per sale = 50 Total Number of Haven't Met Contacts to achieve Sales Goal
50 5000
Option 3: Combo from Met and Haven't Mets (you determine the percentage) Met Percentage desired from this group Met Closed Sales Goal # of names needed per sales (2 sales/12 names = 1 sale/6 names) Total Met Contacts needed
80% 80 6 480
Haven't Met Percentage desired from this group Haven't Met Closed Sales Goal # of names needed per sales (50) Total number of haven't met names needed to achieve goal Total Contacts needed
20% 20 50 1000 1480
Option 3 Gap Analysis Worksheet Directions Met Goal Numbers: Current Numbers: Total People I need to add:
480 100 380
Haven't Met 1000 500 500
Contacts to Add Monthly Met January February March April May June July August September October November December Total actually added (based on 10 months)
Total
Haven't Met 38 38 38 38 38 38 38 38 38 38 38 38 456 380
50 50 50 50 50 50 50 50 50 50 50 50 550 500