I have a sales goal formula that I’d like to set up a form for my clients to work through the formula.
I’d need to set the form up so as they work through the formula it calculates as it goes.
Question 1: What’s your annual sales goal? For example $250,000
Question 2: What is your average revenue per client?
First calculation: sales goals divided by average revenue per client= total number of clients needed to hit your goal.
Question 3: What is your closing ratio?
Second calculation: total from first calculation divided by closing ratio = total number of leads to generate to hit goal.
Question 4: how many weeks are you going to dedicate to hitting your goal
Third calculation: number of leads to generate divided by # of working weeks= number of leads to generate per week
Question 5: how many days per week are you going to dedicate to hitting your goal
Four calculation: number of leads to generate per week divided by working days
I’m at a loss on how to set up the logic. I’ve been working on this for a while now and keep running into dead ends. Any help would be greatly appreciated.
Best answer by john.desborough
View original