Forum Discussion

bskiran1711's avatar
bskiran1711
Regular Visitor
1 year ago

Overutilised Resources

I have the below sample data   Name Dt Total Worked Hours Alloted Production Hours A1 2/1/2025 75 70 A1 2/2/2025 80 85 A1 2/3/2025 95 90 A2 2/1/2025 65 60   A2 ...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

What does "over utilized"  mean?  Worked more than allotted? Does that reset each day or is it cumulative?

 

 

So A1 and A2 are overutilized by a cumulative 8 hrs and 3 is underutilized by 15  resulting in a total of 7 ?

 

 

 

  • bskiran1711's avatar
    bskiran1711
    Regular Visitor
    1 year ago

    Hi,

    Thanks for the reply, If 2/1/2025 is selected in Slicer,

    A1 has worked for 5 hours more,

    A2 has worked for 5 hours more

    A3 has worked for 5 hours less

    So A1 and A2 are overutilised. Hence Overutilised resources are 2.

     

    Similarly if 2/1/2025 and 2/2/2025 is selected

     

    For A1, A2 and A3 have not worked for more than Alloted Production hours, Hence overutilised is 0

     

    Thanks

    Kiran

      • bskiran1711's avatar
        bskiran1711
        Regular Visitor
        1 year ago

        Hi,

        Thanks for the solution, There is an additional condition that Mgmt resources should not be considered while calculating Overutilised.

        Request your kind assistance in this regard.

         

        A1 is a Mgmt resource helping in production so resource type Mgmt should be excluded. 

         

        Thanks

        Kiran