ALLOCATE BY PRIORITY - problems with managing allocations
Posted: Tue Jan 23, 2018 12:09 pm
Dear,
I cannot manage to model correctly the ALLOCATE BY PRIORITY function for what I want to do, I hope I'll manage to make it clear and you'll be able to guide me...
I would like to model the human resources allocation for several buildings, depending on the operations (renovation and/or maintenance) I have to do on each building, only if I have a sufficient human resources stock.
I have 5 buildings such as :
[building]=A,B,C,D,E
I want to operate on those buildings according to 3 different scenarios :
operation scenario=4, 5 or 6 (depending on renovation(4), maintenance(6), or renovation+maintenance(5))
I calculated the quantity of human resources necessary for the buildings operations, such as :
HR demand[building,workforce type]=hours (with [workforce type]=manager, technician, support)
So I obtain something like this :
Time (Month) 0 1 2
HR demand (hours/month)
[bâtA,manager] 269,10 57,92 57,92
[bâtA,technicien] 577,20 273,78 273,78
[bâtA,support] 167,14 150,43 150,43
[bâtB,manager] 96,72 25,74 25,74
[bâtB,technicien] 280,11 121,68 121,68
[bâtB,support] 66,86 66,86 66,86
[bâtC,manager] 95,68 20,59 20,59
[bâtC,technicien]
[bâtC,support]
[bâtD,manager]
[bâtD,technicien] AND SO ON
[bâtD,support]
[bâtE,manager]
[bâtE,technicien]
[bâtE,support]
My first question is :
is it possible to obtain the results under the form : HR demand[building]=(manager,technician,support) ==> Here would be for instance HR demand for building A = (269.10,577.20,167,14) at Time=0.
This would be useful for me in order to compare the scenarios of every building to a total stock (Total stock of human resources=(1 manager,5 technician,2 support) for instance), and select the buildings I can operate considering the overall human resources available. I defined a scenario priority, ranking the buildings according to the operation demand (maintenance (score=6) has priority over renovation (score=4) ). This works well. The problem is that when I want to allocate HR, it occurs directly on the [workforce type], not on a building selection. Here is what I obtain for example :
Time (Month) 0 1 2
allocate ?[type d'effectif,bâtiment]
allocate ?
[manager,bâtA] 0 4.123 4.123
[manager,bâtB] 156 19.49 19.49
[manager,bâtC] 0 10.71 10.71
[manager,bâtD] 0 0 0
[manager,bâtE] 0 121.7 121.7
[technicien,bâtA] 477.5 273.8 273.8
[technicien,bâtB] 167.1 150.4 150.4
[technicien,bâtC] 80.02 25.74 25.74
[technicien,bâtD] 0 121.7 121.7
[technicien,bâtE] 55.31 66.86 66.86
[support,bâtA] 66.27 147.2 147.2
[support,bâtB] 96.72 25.18 25.18
[support,bâtC] 111.1 119 119
[support,bâtD] 0 0 0
[support,bâtE] 37.94 20.59 20.59
buildingB has the biggest score (6) and should have priority over all other buildings.
So I would like it to be selected, and compare its HR demand to my total HR stock (here Total stock of human resources=(1 manager=x hours/month,5 technician=y hours/month,2 support=z hours/month) ).
Then if HR demand[building,workforce type] < Total stock of human resources[workforce type], I take it off the Total stock of human resources, and compare the next scenario to this new Total stock of human resources[workforce type]. This way, I would like to allocate nothing to the buildings I don't have the HR for.
Do you have any idea how I could model this in order to compare and take off the HR "building after building" ?
Thank you a lot in advance !
Laura
I cannot manage to model correctly the ALLOCATE BY PRIORITY function for what I want to do, I hope I'll manage to make it clear and you'll be able to guide me...
I would like to model the human resources allocation for several buildings, depending on the operations (renovation and/or maintenance) I have to do on each building, only if I have a sufficient human resources stock.
I have 5 buildings such as :
[building]=A,B,C,D,E
I want to operate on those buildings according to 3 different scenarios :
operation scenario=4, 5 or 6 (depending on renovation(4), maintenance(6), or renovation+maintenance(5))
I calculated the quantity of human resources necessary for the buildings operations, such as :
HR demand[building,workforce type]=hours (with [workforce type]=manager, technician, support)
So I obtain something like this :
Time (Month) 0 1 2
HR demand (hours/month)
[bâtA,manager] 269,10 57,92 57,92
[bâtA,technicien] 577,20 273,78 273,78
[bâtA,support] 167,14 150,43 150,43
[bâtB,manager] 96,72 25,74 25,74
[bâtB,technicien] 280,11 121,68 121,68
[bâtB,support] 66,86 66,86 66,86
[bâtC,manager] 95,68 20,59 20,59
[bâtC,technicien]
[bâtC,support]
[bâtD,manager]
[bâtD,technicien] AND SO ON
[bâtD,support]
[bâtE,manager]
[bâtE,technicien]
[bâtE,support]
My first question is :
is it possible to obtain the results under the form : HR demand[building]=(manager,technician,support) ==> Here would be for instance HR demand for building A = (269.10,577.20,167,14) at Time=0.
This would be useful for me in order to compare the scenarios of every building to a total stock (Total stock of human resources=(1 manager,5 technician,2 support) for instance), and select the buildings I can operate considering the overall human resources available. I defined a scenario priority, ranking the buildings according to the operation demand (maintenance (score=6) has priority over renovation (score=4) ). This works well. The problem is that when I want to allocate HR, it occurs directly on the [workforce type], not on a building selection. Here is what I obtain for example :
Time (Month) 0 1 2
allocate ?[type d'effectif,bâtiment]
allocate ?
[manager,bâtA] 0 4.123 4.123
[manager,bâtB] 156 19.49 19.49
[manager,bâtC] 0 10.71 10.71
[manager,bâtD] 0 0 0
[manager,bâtE] 0 121.7 121.7
[technicien,bâtA] 477.5 273.8 273.8
[technicien,bâtB] 167.1 150.4 150.4
[technicien,bâtC] 80.02 25.74 25.74
[technicien,bâtD] 0 121.7 121.7
[technicien,bâtE] 55.31 66.86 66.86
[support,bâtA] 66.27 147.2 147.2
[support,bâtB] 96.72 25.18 25.18
[support,bâtC] 111.1 119 119
[support,bâtD] 0 0 0
[support,bâtE] 37.94 20.59 20.59
buildingB has the biggest score (6) and should have priority over all other buildings.
So I would like it to be selected, and compare its HR demand to my total HR stock (here Total stock of human resources=(1 manager=x hours/month,5 technician=y hours/month,2 support=z hours/month) ).
Then if HR demand[building,workforce type] < Total stock of human resources[workforce type], I take it off the Total stock of human resources, and compare the next scenario to this new Total stock of human resources[workforce type]. This way, I would like to allocate nothing to the buildings I don't have the HR for.
Do you have any idea how I could model this in order to compare and take off the HR "building after building" ?
Thank you a lot in advance !
Laura