need your help...

G

giantrules

New member
Joined
Feb 8, 2011
Messages
4
Hi, I need some help in designing a work rotation equitably. That is, ensuring everybody receives an equal number of shifts based on their FTE (full time equivalant). 16 people total with the division of FTEs listed below.

8 people at 1.0 FTE
3 people at 0.8 FTE
2 people at 0.65 FTE
3 people at 0.5 FTE

The shifts to be divided equitably:

160 - E (evening) shifts
80 - 1230 shifts
80 - 1100 shifts

(the 1230 and 1100 simply refer to the shift start times)

I am assuming their is an equation to assist in this task. I need to make sure that the lower FTEs (.8, .65, and .5) have an equitable portion of these shifts compared to the 1.0 FTEs. How do I solve this challenge? Of course I need the answer to this problem but greatly interested in the process as I predict being faced with this challenge again in the future. Thank you, Lee.
 
giantrules said:
Hi, I need some help in designing a work rotation equitably. That is, ensuring everybody receives an equal number of shifts based on their FTE (full time equivalant). 16 people total with the division of FTEs listed below.

8 people at 1.0 FTE
3 people at 0.8 FTE
2 people at 0.65 FTE
3 people at 0.5 FTE

The shifts to be divided equitably:

160 - E (evening) shifts
80 - 1230 shifts
80 - 1100 shifts

(the 1230 and 1100 simply refer to the shift start times)

I am assuming their is an equation to assist in this task. I need to make sure that the lower FTEs (.8, .65, and .5) have an equitable portion of these shifts compared to the 1.0 FTEs. How do I solve this challenge? Of course I need the answer to this problem but greatly interested in the process as I predict being faced with this challenge again in the future. Thank you, Lee.
Click to expand...

Assuming all the shifts are equally desirable and more FTE gets more shifts proportinately, according to my calculations:

8 people with 1 FTE should get 24 shifts each - total 192

3 people with 0.8 FTE should get 20 shifts each - total 60

2 people with 0.65 FTE should get 16 shifts each - total 32

3 people with 0.5 FTE should get 12 shifts each - total 36
 
Assuming all the shifts are equally desirable and more FTE gets more shifts proportinately, according to my calculations:

8 people with 1 FTE should get 24 shifts each - total 192

3 people with 0.8 FTE should get 20 shifts each - total 60

2 people with 0.65 FTE should get 16 shifts each - total 32

3 people with 0.5 FTE should get 12 shifts each - total 36[/quote]

Thank you for the reply. I need to calculate this for each shift respectively, how did you formulate this. Would you mind showing me the calculation based on the 160 evening shifts. It is looking like a basic algebra equation to me but my answer comes out a bit off...I am just a few years out from using what I thought I didn't need to know :?
 
thanks for getting me thinking again....

Is this how it would be written?

320=(x)8+(.8x)3+(.65x)2+(.5x)3

Nonetheless....I get it....thank you!
 
giantrules said:
thanks for getting me thinking again....

Is this how it would be written?

320=(x)8+(.8x)3+(.65x)2+(.5x)3

Nonetheless....I get it....thank you!
Click to expand...

Yes - but "x" will come out in fraction - so you move it up or down to make the # of shifts an integer.
 
You must log in or register to reply here.
Top