+ Reply to Thread
Results 1 to 4 of 4

Customer Onboarding Schedule across months

  1. #1
    Registered User
    Join Date
    03-23-2021
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel for Mac 2016
    Posts
    2

    Customer Onboarding Schedule across months

    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**
    Attached Files Attached Files
    Last edited by ryanyvr; 03-23-2021 at 04:37 PM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,141

    Re: Customer Onboarding Schedule across months

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

  3. #3
    Registered User
    Join Date
    03-23-2021
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel for Mac 2016
    Posts
    2

    Re: Customer Onboarding Schedule across months

    Edited original to attach file - apologies

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,522

    Re: Customer Onboarding Schedule across months

    Here is a low tech proposal for getting the number of wholesale sales:
    1. List the retailers in C23:C32
    2. Starting with column G use the following: =IF(F$18=$C23,$E$9,IF(E$18=$C23,$F$9,IF(D$18=$C23,$G$9,IF(SUM($C23:F23)>=$E$9,$H$9,""))))
    3. Populate row 19 using: =SUM(D23:D32)
    For retail sales:
    1. List retailers in C35:C44
    2. Starting with column H use the following: =IF(F$18=$C35,$F$10,IF(E$18=$C35,$G$10,IF(D$18=$C35,$H$10,IF(SUM($C35:G35)>=$F$10,$I$10,""))))
    3. Populate row 20 using: =SUM(D35:D44)
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Need to create an excel form for Onboarding checklist of employees
    By aparnawangu in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-13-2018, 05:20 AM
  2. Summing for months and customer
    By kjohnson6 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-08-2018, 05:53 PM
  3. Sequential Formula for months based on a 4, 4, 5 schedule
    By scruz9 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-31-2017, 02:28 PM
  4. Booking Roll-Off Schedule With Variable # of Months
    By excel-help in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-01-2016, 01:40 PM
  5. Adding a column that shows years and months a customer has been with us
    By Rachel Catalogues in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-10-2015, 08:48 AM
  6. Replies: 1
    Last Post: 05-05-2015, 03:40 PM
  7. [SOLVED] Formula to return first 12 Months invoices to a customer
    By pbcsd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2015, 12:13 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1