Looking for a way to calculate items needed to reach target %

[UNCDave13]

Hey,

Let me explain exactly what I am looking for here.

I need a formula that will help me to determine the amount of items a person needs to reach a target percentage.

Let's relate it to sales calls. A person needs to have a certain percentage of sales at the end of month, if they are at 15 sales right now and have 100 calls, obviously at 15%. Let's say their target goal is 20%. How can I calculate how many more calls they would need to reach 20%?

The only things I have been able to find don't take into account that the fact that the total number of calls increases as well.

[rvasquez]

Hello There,

Attached is a spreadsheet I think accomplishes what you are looking for. Cells E2:E6 contain formulas that automatically calculate the data.

Let me know if this is what you were looking for!

Thanks!

RVASQUEZ

[GeneralDisarray]

....you would have to assume they made sales at some higher percentage for the remaining calls for the month...how would you know that percentage?

If you assumed they made sales 100% of the time for the rest of the month you woud just solve (15+x)/(100+x) = 0.20 => x = 6.25 calls...that seems to be not that useful?

[UNCDave13]

Not exactly.

Let me clarify just a bit. In the example I am using the agent has already made 100 calls, so making 5 more would actually be 105 calls. So he would only be at 19%, still short of goal. In this actual example the agent would need to make sales on his next 7 calls in order to reach 20%. The difficulty I am having in coming up with a formula stems from the fact that every call adds to the overall total, so the number is very dynamic.

Thanks for your help so far.

[roki4]

Would love to have formulas for both, then it just becomes a rate of change problem.

[Haseeb Avarakkan]

Hello UNCDave13, Welcome to the forum!

The best thing to describe your problem is, attach a file with desired results & a small explanation about how did you get these results. I am sure, you will have your answer. To attach a file, on bottom click Go Advanced, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button

Anyway, take your examples. Achieved Call = 105 in as 19%.

So the total call should be =109/19% = 552.6315789

PercentageGoal = 20%, so Goal Call =552.6315789*20% =110.5263158

Needed Sales = 110.5263158-105 = 5.526315789

So, generally Needed Sales =TotalCall*PercentageGoal-AchievedCall

Does this help you to get a start?

I am not a good financier, so I could be wrong too in somewhere.

[UNCDave13]

Thanks Haseeb,

I couldn't really seem to apply the formula you used to this situation. It seems like your formula was using 109 as the number of sales to be 19% of something. I also assumed the 109 was a mistype and you were using 105 which was from my example. However the example would have really been 20 sales out of 105 calls is 19%, not the 20% goal as a previous poster was attempting to assist with.

That being said, I do have a spreadsheet that has the goals listed, right now I can calculate them by hand, just by knowing what numbers are roughly what %. However, as this becomes applied to more agents the time involves becomes too burdensome, hence the need of a formula. I know I am just overlooking something simple, but I just can't seem to find it.

Notice the Sales to Goal in bold, that being the field I am looking for a formula for.

[Haseeb Avarakkan]

In G3,

=E3*C3-D3

Then copy down. Is this do you mean?

[UNCDave13]

GeneralDisarray had the right idea for what I was going for, just can't seem to find a way to turn that formula into something I can use as the numbers change.

Haseeb, what you suggested is the big issue I have been running into. Using the 100 calls, 15 sales, 20%goal example; That formula tells me you would need 5 more sales, which is not accurate b/c it does not factor in that 5 more sales would mean 5 more calls. So while 20/100 is 20%, 20/105 is only 19% and thus not at goal.

So in a nutshell, I have been trying to find a way to incorporate GD's formula. If anyone has any ideas I'd love to hear them or if I figure it out. I'll post and let you all know.

[vandan_tanna]

Attachment 155779

Will this do it?

Please look at snap5.jpg.

I can't figure out how to delete the wrong attachment (Snap1.jpg)!

[UNCDave13]

Vandan,

That works perfectly, I was leaving out the division of the inverse %. Work perfectly for those below goal. Doesn't work for above goal, but based on that formula it shouldn't. If I ever need a way to see how many calls can be made without a sale and stay above goal. I know where I'll post first.

Thanks to everyone.

[misszane]

Attachment 155779

Will this do it?

Please look at snap5.jpg.

I can't figure out how to delete the wrong attachment (Snap1.jpg)!

Hi Vandan,

Reading this thread, your answer may actually work for my case as well.
Except that I can't open the link nor snap5
I'm very new here.. still trying to find my way around..

Could you please resend/repost ?

Thanks!!

[rkmesh]

What was the solution. i don't get the attachment. Please advice. Im looking for the same issue

[FDibbins]

It seems the link is broken, you will need to start a new thread (which you would need to do anyway), and ask your questionthere