+ Reply to Thread
Results 1 to 6 of 6

Help with forumla to calculate daily targets

  1. #1
    Forum Contributor
    Join Date
    08-13-2008
    Location
    South Africa
    Posts
    130

    Help with forumla to calculate daily targets

    Hi Guys

    I need a forumala to calculate the daily target left.

    Example: the monthly target is 2000 sales, broken down daily assuming there is 20 working days, that will be 100 sales per day. Assuming that the daily sales target of 100 sales is not met i need a formula that will tell me how many sales are required per day that we need to do to make up the 2000 sales. Also bear in mind that the number of working days are decreasing

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Help with forumla to calculate daily targets

    It may be easier if you provide a sample of how your data is laid out - ie where the daily actuals are stored etc...

    In calc terms your required daily sales will be:

    (Target-Actuals to Date)/Days Remaining

  3. #3
    Forum Contributor
    Join Date
    08-13-2008
    Location
    South Africa
    Posts
    130

    Re: Help with forumla to calculate daily targets

    Thanks, i have attached the example. Also, just remember that the daily target if not achieved needs to be added on to the following daily sales targets
    Attached Files Attached Files

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Help with forumla to calculate daily targets

    Using the previously mentioned formula

    H6: =(H2-SUM(D2:D27))/(H3-COUNT(D2:D27))

    Assumes that if a day has no sales a 0 is entered, ie not left blank.

  5. #5
    Forum Contributor
    Join Date
    08-13-2008
    Location
    South Africa
    Posts
    130

    Re: Help with forumla to calculate daily targets

    Thanks for the info buddy! Also just wanted to find out is there a way that excel can autmatically reduce the number of days from a given number? Example if i say there are 20 working days in a month can excel reduce the working days automatically as the days progress?

  6. #6
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Help with forumla to calculate daily targets

    Isn't that what this does ?

    (H3-COUNT(D2:D27))

    The above (which is the divisor in your required rate calc) assumes that for each working day a numerical value is entered into the appropriate row in column D ... thus as you add values to D so the remaining working days will adjust automatically given they are calculated by means of subtracting the number of values entered at that point in time in Column D from the total working days as specified in H3.

    I'm not entirely sure I'm following so please elaborate as much as possible if you need more info.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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