Recurring Revenue Model Help

[alphafoxtrot]

Hello,

I am trying to create a revenue forecast that can account for monthly sales that recur once a quarter.

For example, an Account Executive can make a sale in January and that very same customer will use our service again in three months (but not before). All the while our Account Executive is making sales every month leading up to the second service event for their first sale.

I can do this with manual data entry but I'm looking to automate this with very few inputs (Recurrence period, headcount, sales quota, etc.)

Please see attached.

MonthlySalesAndQuarterlyRecurringRevenue.xlsx
huf7ya.jpg