11 Replies Latest reply on Nov 30, 2015 12:09 PM by matt.kaskow

    How to use number of business days in monthly utilization calculation

    matt.kaskow

      Hi guys,

       

      Would appreciate any feedback on the below issue:

       

      I am trying to calculate utilization: ( (# of hours/employee/mo.) / ( #of business days/mo. *9(# of hours/day).

       

      The piece I am having trouble with is the dynamic use of # of business days/mo. I have incorporated all 12 months of the year, so trying to figure out how to have the correct # of business days/mo. for each month.