Results 1 to 3 of 3

Math Help - average throughputs / number of customers using the service?

  1. #1
    Newbie
    Joined
    May 2008
    Posts
    2

    average throughputs / number of customers using the service?

    hi everyone, first post on the forum and would really appreciate some help with a problem....

    I'm a manager of a charity that has customers (service users) who use the service for varying periods of time, ususally between 3 and 12 months (the length of the program of support). New customers enter the service as time progresses, which can be measured monthly, so for example we might have 50 referrals to the service each month.

    I've tried to create a 'calculator' in excel to enable me to work out the answer to the following question...i've attached it but im not convinced its all that accurate (boxes in white can have figures inputted, boxes in beige output figures) here's the main question i need to answer...

    1. If x number of customers commence services each month, and the average stay with the service is y number of months, what will the average number of people using the service at any one point be?

    This will help me work out how many staff i would need to provide the service if x number of people are referred to it per month, and stay for y length of time.

    i might be complicating the issue by trying to incorporate the total number of customers at the start of the period...

    Anyway, if anyone has a few moments and wouldnt mind taking a look at what i've done and can show me where i might be going wrong, that would be great .

    Thanks in advance! Mike
    Attached Files Attached Files
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Banned
    Joined
    Nov 2007
    Posts
    54

    You need to send your forumlas.

    Your spreadsheet appears to be devoid of formulas.

    Be sure to protect the cells, also, so if any looks, the will be inclined to copy and work rather than change the original.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    May 2008
    Posts
    2
    Hi Bradley, thanks for the reply. If you click the 'answer' boxes highlighted in beige the excel formulas should appear...i think i could probably have been clearer about that

    let me know if the formulas appear!
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Average employee number
    Posted in the Algebra Forum
    Replies: 5
    Last Post: August 5th 2010, 09:28 AM
  2. 'Average' number
    Posted in the Statistics Forum
    Replies: 1
    Last Post: July 29th 2010, 01:38 PM
  3. Average Value of a Number
    Posted in the Calculus Forum
    Replies: 3
    Last Post: May 6th 2010, 08:05 AM
  4. Renewal (counting customers)
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: March 13th 2010, 03:05 PM
  5. need help with cleasning service quote
    Posted in the Algebra Forum
    Replies: 1
    Last Post: July 22nd 2008, 08:05 AM

Search Tags


/mathhelpforum @mathhelpforum