Public speaker lecture tour budgets and tickets sale potential

Hi I'm putting together a public speaking tour for an author and need someone who is creative and proficient with a spreadsheet to put in the different cities about 10 of them venues costs for the venue production audio etc. and then the possible outcomes with ticket sales based on different prices and different number of tickets sold