Results 1 to 5 of 5

formula for contacts required to meet Sales conversion target

This is a discussion on formula for contacts required to meet Sales conversion target within the Excel Questions forums, part of the Question Forums category; Hi, hopefully this is a quick one, (rather than the many hours of frustration one for me) As a salesperson ...

  1. #1
    New Member
    Join Date
    Dec 2011
    Posts
    15

    Default 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. #2
    MrExcel MVP Robert Mika's Avatar
    Join Date
    Jun 2009
    Location
    (current) UK, (origin) Poland
    Posts
    7,219

    Default Re: formula for contacts required to meet Sales conversion target

    Try:
    100134
    15
    20


    =ROUNDUP((A1/A2)*A3,0)
    - Read the Posting Guidelines, Forum Rules & FAQs
    - Want to post a small screen shot? Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste
    - If posting vba code, please use Code Tags .

  3. #3
    New Member
    Join Date
    Dec 2011
    Posts
    15

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

    Any help you could offer would be appreciated

  4. #4
    MrExcel MVP Robert Mika's Avatar
    Join Date
    Jun 2009
    Location
    (current) UK, (origin) Poland
    Posts
    7,219

    Default Re: formula for contacts required to meet Sales conversion target

    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.
    - Read the Posting Guidelines, Forum Rules & FAQs
    - Want to post a small screen shot? Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste
    - If posting vba code, please use Code Tags .

  5. #5
    New Member
    Join Date
    Dec 2011
    Posts
    15

    Default 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 HTMLSheet2

    *HIJKL
    6*ContactsSalesTargetXXX
    7Current 1001520XXX
    8Required10116*15.84%
    9*10217*16.67%
    10*10318XXX17.48%
    11XXX10419*XXX
    12*10520*19.05%
    13XXX106XXX*19.81%
    14XXX10722*20.56%
    15*10823*21.30%
    16*10924*22.02%
    17*11025*XXX
    18*11126*23.42%
    19*112XXX*24.11%
    20*XXXXXX*24.78%
    21*114XXX*25.44%
    22XXX11530XXX26.09%
    23*11631*26.72%
    24XXX11732*27.35%
    25*11833*27.97%
    26*11934XXX28.57%
    27*XXXXXX*29.17%
    28*12136*29.75%
    29*122XXX*30.33%
    30*12338XXX30.89%
    31*12439*31.45%

    Spreadsheet Formulas
    CellFormula
    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




Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com