1. Can you tell me what the conversion rate is and how you calculated it? 2. Can you tell me how to calculate the conversion
1. Can you tell me what the conversion rate is and how you calculated it?
2. Can you tell me how to calculate the conversion rate, the $ commissions and $ commissions per hour?
3. Can you tell me the conversion rate, #sales lost at closing, and $ sales in pipeline. thank you!
Qualified leads are fed into your pipeline through your inbound marketing system Sales Funnel My $'s $56,418 Leads - 58 Won Available Lost 58 Activity Call for appointment Meet to assess needs Prepare proposal Call to discuss and close 58 21 4 70 State Leads Needs assessment Proposal Negotiation Closed Assumed Conversion 0.3 0.4 0.5 0.5 total >>> Needs assessment - 21 Cycle time (days) 3.2 11.6 6.8 1.9 23.5 16 16 11 85 33 0 4 88 Proposal - 16 Conversion rate 0.49132948 Win rate Negotiation - 11 1140000 quota 0.077 commission rate 56417.9 % commissions 0.642719 % quota achieved 64% Using the data given, fill in the yellow and blue cells. (The dashboard itself auto- populates.) Conversion Rate 0.0% 85 #sales 732700 $ sales 8620 average $ sale Just input equationsumbers - no rounding or formatting please. Win Rate 49.1% sales quota State Won Lost Assumed conversion Cycle time (hours) Activity Prospect Call and close na na Leads Closed 258 72 0 0 937 0.08 total >>> 71 71 71 Lead response time I have found 1267 leads. I have made 1009 sales calls. I have been told NO 937 times. I make a sale about every 14 calls. For a conversion rate of 0%. I have made 72 sales. I make $99.50 every time I make a sale. So I have earned $. I have worked 388 hours. So I make $0 per hour. minutes spent Activity Prospect Call and close Total #completed 1267 1009 Minutes Req'd 12 8 15204 8072 23276 hours spent days spent (8 hrs) 253.4 31.675 134.5333333 16.81666667 387.9333333 48.49166667 2276 72 #sales $ sales (all sales are for $199) 0.346795 % time selling (e.g. call and close) Using the data given, fill in the yellow and blue cells. (The dashboard itself auto- populates.) 20.64 expected # sales in pipeline (using "Assumed conversion" rate) 4107.36 expected $ sales in pipeline (using $199 per sale) conversion rate 0.071358 win rate 0.986111111 # activities per sale 5.387962963 Whours per sale 0.04 commission rate ols commissions $ commission per hour Just input equationsumbers - no rounding or formatting please. Assumed Conversion Stage Time (hrs) Available na na Lead Needs Value Value/prep Value/appt Proposal Negotiation Negotiation/appt Closed Activity Prospect for a lead Call for appt- needs assess meeting Conduct needs meeting Prepare value proposition Call for appt-value prop meeting Conduct value proposition meeting Prepare and send proposal Call for appt - neg/close meeting Conduct neg/close meeting Won Avail Lost na na na 312 311 na 87 56 940 46 46 357 37 37 0 25 14 210 18 18 180 11 11 0 6 3 105 156 na 240 Hrs Req'd 0 0 1.5 0 0 1.5 0 0 1.5 0.05 0.1 0.15 0.15 0.2 0.3 0.3 0.4 Conversion Pr(next) na 0.071297989 0.125 0.57038391 0.175084175 0.71394231 0.175084175 1 0.22907489 0.76430976 0.311377246 0.73568282 0.311377246 1 0.393939394 0.79041916 0.39393939 18 111 71 5 84 52 3 62 406 311 56 46 37 14 18 11 3 conversion rate 0.393939394 win rate 0.22 commission rate 790 assumed average sale 156 #sales 122304 $ sales 26906.88 $ commissions #sales lost at closing Using the data given, fill in the yellow and blue cells. (The dashboard itself auto- populates.) 52.85 #sales in pipeline (using assumed conversion) $ sales in pipeline (using assumed average sale) Just input equationsumbers - no rounding or formatting please. Qualified leads are fed into your pipeline through your inbound marketing system Sales Funnel My $'s $56,418 Leads - 58 Won Available Lost 58 Activity Call for appointment Meet to assess needs Prepare proposal Call to discuss and close 58 21 4 70 State Leads Needs assessment Proposal Negotiation Closed Assumed Conversion 0.3 0.4 0.5 0.5 total >>> Needs assessment - 21 Cycle time (days) 3.2 11.6 6.8 1.9 23.5 16 16 11 85 33 0 4 88 Proposal - 16 Conversion rate 0.49132948 Win rate Negotiation - 11 1140000 quota 0.077 commission rate 56417.9 % commissions 0.642719 % quota achieved 64% Using the data given, fill in the yellow and blue cells. (The dashboard itself auto- populates.) Conversion Rate 0.0% 85 #sales 732700 $ sales 8620 average $ sale Just input equationsumbers - no rounding or formatting please. Win Rate 49.1% sales quota State Won Lost Assumed conversion Cycle time (hours) Activity Prospect Call and close na na Leads Closed 258 72 0 0 937 0.08 total >>> 71 71 71 Lead response time I have found 1267 leads. I have made 1009 sales calls. I have been told NO 937 times. I make a sale about every 14 calls. For a conversion rate of 0%. I have made 72 sales. I make $99.50 every time I make a sale. So I have earned $. I have worked 388 hours. So I make $0 per hour. minutes spent Activity Prospect Call and close Total #completed 1267 1009 Minutes Req'd 12 8 15204 8072 23276 hours spent days spent (8 hrs) 253.4 31.675 134.5333333 16.81666667 387.9333333 48.49166667 2276 72 #sales $ sales (all sales are for $199) 0.346795 % time selling (e.g. call and close) Using the data given, fill in the yellow and blue cells. (The dashboard itself auto- populates.) 20.64 expected # sales in pipeline (using "Assumed conversion" rate) 4107.36 expected $ sales in pipeline (using $199 per sale) conversion rate 0.071358 win rate 0.986111111 # activities per sale 5.387962963 Whours per sale 0.04 commission rate ols commissions $ commission per hour Just input equationsumbers - no rounding or formatting please. Assumed Conversion Stage Time (hrs) Available na na Lead Needs Value Value/prep Value/appt Proposal Negotiation Negotiation/appt Closed Activity Prospect for a lead Call for appt- needs assess meeting Conduct needs meeting Prepare value proposition Call for appt-value prop meeting Conduct value proposition meeting Prepare and send proposal Call for appt - neg/close meeting Conduct neg/close meeting Won Avail Lost na na na 312 311 na 87 56 940 46 46 357 37 37 0 25 14 210 18 18 180 11 11 0 6 3 105 156 na 240 Hrs Req'd 0 0 1.5 0 0 1.5 0 0 1.5 0.05 0.1 0.15 0.15 0.2 0.3 0.3 0.4 Conversion Pr(next) na 0.071297989 0.125 0.57038391 0.175084175 0.71394231 0.175084175 1 0.22907489 0.76430976 0.311377246 0.73568282 0.311377246 1 0.393939394 0.79041916 0.39393939 18 111 71 5 84 52 3 62 406 311 56 46 37 14 18 11 3 conversion rate 0.393939394 win rate 0.22 commission rate 790 assumed average sale 156 #sales 122304 $ sales 26906.88 $ commissions #sales lost at closing Using the data given, fill in the yellow and blue cells. (The dashboard itself auto- populates.) 52.85 #sales in pipeline (using assumed conversion) $ sales in pipeline (using assumed average sale) Just input equationsumbers - no rounding or formatting please
