Need a calculator for a sales goal formula

@Natalie Klun - this comes to you from a user of the tool 

the logic steps for this are fairly straightforward to set up this set of calculations if you are using the new builder (as opposed to the classic version) - there is an example of types of calculations that are reliant upon inputs in the BMI calculator example which you should see over the right of the screen under Related topics heading . 

that being said here is how i would approach it:

• create variables: clients_needed, closing_ratio, leads_needed

Question 1: What’s your annual sales goal? For example $250,000

• create calculation: if q1 greater than 0 then add q1 to variable clients_needed

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. 

• create calculation: if q2 answer is greater than zero, then divide variable clients_needed by q2
  • since the variable was the sales $$ you now have the total dollar goal divided by rev per client as the value in the variable clients_needed

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. 

• ask for the closing ratio to be entered in as a whole number ie entering 40 means 40%
• create calculations
  • if q3 is greater than zero, add q3 to variable closing_ratio
  • if variable closing_ratio is greater than zero, divide closing ratio by 100 (to get to a decimal number)
  • if variable clients_needed is greater than zero, add variable clients_needed to leads_needed
  • if variable closing ratio is greater than zero, divide leads_needed by closing_ratio (this should divide the number of clients by the closing ratio percentage you want)

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

• create calculation: if q4 is greater than zero, divide leads_needed by q4 

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 

• create calculation: if q5 is greater than zero, divide leads_needed by q5 

that should get you to the figures you need.. i have not tested it in the form but it seems to be similar in nature to some of the calculation logic that i have tested out in other forms of my own. 

all that might be completely irrelevant once one of the real Typeformers gets to look at this .. 

cheers and good luck 

des