Hi folks
I'm trying to create a customer onboarding schedule, using an annual count as the input, and then divide the annual over 12 months.
My example of a wholesale business:
- Onboard 4 retailers in year 1, evenly distributed across each month of the year (ie: win a customer in March, June, Sept, Dec)
- Each retailer has a purchasing profile: 0 in month 1, 100 in month 2, 50 in month 3, 50 in month 4, and 10 per month ongoing
I can hard code, but would prefer an assumptions table to test revenue impact when accelerating retailer purchasing and retailer onboarding.
My question is: What's the best formula functions to pull from the assumptions table and distribute across the months, and layer on new customers (ie - by July we have 2 retailers with a cumulative product count)
Thanks in advance! I'm stumped how to schedule this out.
**edited to add attachment**
Bookmarks