I am trying to estimate ticket sales for about 10 events,
Scenario :
1st Event Ticket Sales Start Date : Oct 1st , Event Date : Dec 31st -- Which means we have 13 weeks to sell tickets.
My estimate is to sell 100 tickets, logic is 10% of the tickets will sell on the first 10 weeks and balance 90% will sell on the last 3weeks before the event date.
So, need a excel where it will show me how many tickets will be sold in Oct, Nov and December
Like wise for all the events which we enable tickets, which is based on ticket enabled date and event date.
I must have a way to know how many tickets will be sold in Oct -- with sum of all the events i ticket.
Hope there is a way to find out, i tried to calculate the weeks and distribute it .. but did not work.
Please help !
Scenario :
1st Event Ticket Sales Start Date : Oct 1st , Event Date : Dec 31st -- Which means we have 13 weeks to sell tickets.
My estimate is to sell 100 tickets, logic is 10% of the tickets will sell on the first 10 weeks and balance 90% will sell on the last 3weeks before the event date.
So, need a excel where it will show me how many tickets will be sold in Oct, Nov and December
Like wise for all the events which we enable tickets, which is based on ticket enabled date and event date.
I must have a way to know how many tickets will be sold in Oct -- with sum of all the events i ticket.
Hope there is a way to find out, i tried to calculate the weeks and distribute it .. but did not work.
Please help !
