Nov-08-2023, 03:44 PM
Could you please help with the following. I am trying to find a way to automatically reallocate resources based on the available hours, demand and job type. The attached document contains an example of two locations which have been broken down into four tables consisting of Utilisation by job type (recommendation), Utilisation by job type (in figures), Contractual hours, Number of staff and Available hours.
Desired Outcome
Using programming (not sure which) I would like to do two things:
- Capture the current resource utilisation per area and also across all areas as a whole in its current form
- Based on the available hours and demand i would like to recommend the optimal resource allocation across all areas using programming (not sure which one).
If you look at rows 10 to 14 I have manually recommended a shift of resources from one area to the next based on available hours and demand. For example, i have recommended removing 6 hours from location 3 or the equivalent of 3 employees altogether. While for Location 2 i have recommended moving 2 hours from location 1 or the equivalent of 1 employee to location 2 into job type 3.
The output should rearrange resources to show the new recommended utilisation (for specific areas and overall) against the old. This was I can see the effects of my recommendation
Note
- Demand in hours data will come from another source
- Number of staff will come from another source
- Contractual hours are fixed and will come from another source
Desired Outcome
Using programming (not sure which) I would like to do two things:
- Capture the current resource utilisation per area and also across all areas as a whole in its current form
- Based on the available hours and demand i would like to recommend the optimal resource allocation across all areas using programming (not sure which one).
If you look at rows 10 to 14 I have manually recommended a shift of resources from one area to the next based on available hours and demand. For example, i have recommended removing 6 hours from location 3 or the equivalent of 3 employees altogether. While for Location 2 i have recommended moving 2 hours from location 1 or the equivalent of 1 employee to location 2 into job type 3.
The output should rearrange resources to show the new recommended utilisation (for specific areas and overall) against the old. This was I can see the effects of my recommendation
Note
- Demand in hours data will come from another source
- Number of staff will come from another source
- Contractual hours are fixed and will come from another source
Attached Files
