formula for contacts required to meet Sales conversion target

Thanks:  0
Likes:  0

# Thread: formula for contacts required to meet Sales conversion target

1. ## formula for contacts required to meet Sales conversion target

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)

2. ## Re: formula for contacts required to meet Sales conversion target

Try:
 100 134 15 20

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

3. ## Re: formula for contacts required to meet Sales conversion target

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%.

4. ## Re: formula for contacts required to meet Sales conversion target

HTLMaker

or
Excel Jeanie

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

5. ## Re: formula for contacts required to meet Sales conversion target

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...

Excel Jeanie HTML ******>Sheet2

 * H I J K L 6 * Contacts Sales Target XXX 7 Current 100 15 20 XXX 8 Required 101 16 * 15.84% 9 * 102 17 * 16.67% 10 * 103 18 XXX 17.48% 11 XXX 104 19 * XXX 12 * 105 20 * 19.05% 13 XXX 106 XXX * 19.81% 14 XXX 107 22 * 20.56% 15 * 108 23 * 21.30% 16 * 109 24 * 22.02% 17 * 110 25 * XXX 18 * 111 26 * 23.42% 19 * 112 XXX * 24.11% 20 * XXX XXX * 24.78% 21 * 114 XXX * 25.44% 22 XXX 115 30 XXX 26.09% 23 * 116 31 * 26.72% 24 XXX 117 32 * 27.35% 25 * 118 33 * 27.97% 26 * 119 34 XXX 28.57% 27 * XXX XXX * 29.17% 28 * 121 36 * 29.75% 29 * 122 XXX * 30.33% 30 * 123 38 XXX 30.89% 31 * 124 39 * 31.45%

 Cell Formula L7 =J7/I7 J8 =J7+1 L8 =J8/I8 J9 =J8+1 L9 =J9/I9 J10 =J9+1 L10 =J10/I10 J11 =J10+1 L11 =J11/I11 J12 =J11+1 L12 =J12/I12 J13 =J12+1 L13 =J13/I13 J14 =J13+1 L14 =J14/I14 J15 =J14+1 L15 =J15/I15 J16 =J15+1 L16 =J16/I16 J17 =J16+1 L17 =J17/I17 J18 =J17+1 L18 =J18/I18 J19 =J18+1 L19 =J19/I19 J20 =J19+1 L20 =J20/I20 J21 =J20+1 L21 =J21/I21 J22 =J21+1 L22 =J22/I22 J23 =J22+1 L23 =J23/I23 J24 =J23+1 L24 =J24/I24 J25 =J24+1 L25 =J25/I25 J26 =J25+1 L26 =J26/I26 J27 =J26+1 L27 =J27/I27 J28 =J27+1 L28 =J28/I28 J29 =J28+1 L29 =J29/I29 J30 =J29+1 L30 =J30/I30 J31 =J30+1 L31 =J31/I31

Excel tables to the web >> Excel Jeanie HTML 4

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•