formula for contacts required to meet Sales conversion target

visionnz · May 9, 2012

Hi, hopefully this is a quick one,
(rather than the many hours of frustration one for me)

As a salesperson I have to meet a contacts to sales conversion target of 20%. If for example I had a current contact to sales conversion rate of 15% for the period, how would you calculate the minimum amount of contacts needed to meet the 20% Target? (assuming all new contacts were converted to sales)

E>G
Current Contacts : 100
Current Sales : 15
Target Sales : 20

Formula required = Minimum new contacts to meet 20% sales target (assuming all new contacts were sales)

Robert Mika · May 9, 2012

Try:
<TABLE style="WIDTH: 96pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=128><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=20 width=64 align=right>100</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=64 align=right>134</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=20 align=right>15</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=20 align=right>20</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63> </TD></TR></TBODY></TABLE>

=ROUNDUP((A1/A2)*A3,0)

visionnz · May 9, 2012

Hi Thier,
Thanks so much for the response im not sure what went wrong but the number im looking for is 107 Contacts.. which is worked out using a very long manual process using 3 columns and multiple rows were I add 1 to the contacts and 1 to the sales until I reach the target in this case 20.56%.

Any help you could offer would be appreciated

Robert Mika · May 9, 2012

Any sample of your data?
You can download and install two of the following programs:

HTLMaker

or
Excel Jeanie

or when using Internet Explorer just put borders around your data in Excel and copy those cells into your post.

visionnz · May 9, 2012

Hi .. hope this helps little new to excel genie here goes, the reference in yellow is the target values.. heres hoping theirs a formula as you can imagine this is a very time consuming and manual process when dealing with multiple agents...

<html><head><title>Excel Jeanie HTML</title></head><body>

Excel Workbook