Google Sheets Formula Expert

Hello,

**** UK & English Speaking ONLY ****

I need a spreadsheet to work out how many letters someone is able to send based on the number of hours they have available each week derived from two scenarios:

Ball Park Offer Strategy (100 Letters / 15 Responses)

Average response rate from 100 letters sent is 15
10% of initial responses say no (15% of 15 letters)

Each of the 2.25 responses would required:

Initial Call - 15 Minutes
Site Check - 20 mins
Quick Fire Appraisal - 45 mins
Ball Park Offer to Landowner - 20 Mins

(1hr 40mins)


Of the Ball Park Offers Presented, 50% continue further to an appraisal which requires:

Round #1 of Detailed Appraisal Work - 2hrs
Creating Offer Letter - 30 mins
Presenting Offer - 30 mins

(3hrs)

-

No Ball Park Offer Strategy (100 Letters / 15 Responses)

Average response rate from 100 letters sent is 15
10% of initial responses say no (15% of 15 letters)

Each of the 2.25 responses would required:

Initial Call - 15 Minutes
Site Check - 20 mins
Quick Fire Appraisal - 45 mins

(1hr 20mins)

After Quick Fire Appraisal, 75% of sites continue to next stage:

Round #1 of Detailed Appraisal Work - 2 hrs
Creating Offer Letter: - 30 mins
Presenting Offer - 30 mins

_______________________________________

It will look something like this:

https://docs.google.com/spreadsheets/d/1IOvPJ1yMwnZS4f9QqVH2ryg7ZSpXCl4obegowIqmzXA/edit?usp=sharing