Forum Discussion
Overutilised Resources
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
That is not clear from the sample data. Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.Hi,
My sincere apologies.
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
A4 has worked for 5 hours more
So A1 , A2 and A4 are overutilised. Since A1 is Mgmt resource and should not be counted as Production resource, 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,A4 has worked 8 hours more, hence overutilised is 1
Thanks
Kiran
How does this impact the other metrics you need? Will "Unutilized Production Hours" and "Total Employees" now be calculated differently too?