+ Reply to Thread
Results 1 to 2 of 2

Finding the average?. We deliver x many of days a week out of a possible x

  1. #1
    Registered User
    Join Date
    03-28-2019
    Location
    Melbourne, Australia
    MS-Off Ver
    2013
    Posts
    1

    Unhappy Finding the average?. We deliver x many of days a week out of a possible x

    Hi All!

    i have a list of customers, we could deliver to them up to 4 times a week (a possible 208 days a year) but they have ordered X amount of times within a year. (the dockets per year)
    So under AV Weekly orders, i would like to work out how many times they are getting an order on a weekly average. i am going OUT OF MY MIND
    SOS xoxoSOS.png

    EG. Store 1 got 19 deliveries in 1 year, they could have had 208.. what is the formula needed to give a weekly average

  2. #2
    Valued Forum Contributor
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010
    Posts
    907

    Re: Finding the average?. We deliver x many of days a week out of a possible x

    If I'm understanding correctly: If you have 19 deliveries per year that's 19 in 52 weeks and so an average of 19/52 per week. = an average of 0.365 deliveries / wk.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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