formula to derive appropriate ranking of efficiency and working hours.

[vinod9111]

Hi All,

Am trying to work on formuala which will give me efficieny ratio but i also want to factor number of working hours into the formula which i am not able to do it . Please help me with the tips . Have pasted two tables i.e Table 1 and Table 2, First table shows the actual time taken for the task against the standard time. Table 2 shows summary position of each staff.
If you look at table 2 efficiency ratio is more of C & D as they have taken less time but actual hours worked is lesser than A and B.

I want to derive a single formula which could factor efficiency as well as working hours taken by each staff.

Table 1
[TABLE="width: 613"]
<tbody>[TR]
[TD]Staff[/TD]
[TD]Standard time in minutes[/TD]
[TD]Actual time taken in minutes[/TD]
[TD] efficiecny ratio[/TD]
[/TR]
[TR]
[TD](a)[/TD]
[TD](b)[/TD]
[TD]©[/TD]
[TD](b)/©[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]45[/TD]
[TD]45[/TD]
[TD]1.00[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]60[/TD]
[TD]55[/TD]
[TD]1.09[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]75[/TD]
[TD]45[/TD]
[TD]1.67[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]55[/TD]
[TD]45[/TD]
[TD]1.22[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]65[/TD]
[TD]60[/TD]
[TD]1.08[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]75[/TD]
[TD]70[/TD]
[TD]1.07[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]85[/TD]
[TD]55[/TD]
[TD]1.55[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]95[/TD]
[TD]85[/TD]
[TD]1.12[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]105[/TD]
[TD]100[/TD]
[TD]1.05[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]115[/TD]
[TD]115[/TD]
[TD]1.00[/TD]
[/TR]
</tbody>[/TABLE]


Table 2
[TABLE="width: 512"]
<tbody>[TR]
[TD]Staff[/TD]
[TD]Average efficiency ratio[/TD]
[TD]Total hours[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]104%[/TD]
[TD]205[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]105%[/TD]
[TD]240[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]161%[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]117%[/TD]
[TD]130[/TD]
[/TR]
</tbody>[/TABLE]


regards
Vinod

 

[jorismoerings]

Hi Vinod,

This sound like you want some weighting included in your formula but you do not mention what should take preference in the calculation.
Could you share what your desired result looks like?

 

[vinod9111]

Hi Vinod,

This sound like you want some weighting included in your formula but you do not mention what should take preference in the calculation.
Could you share what your desired result looks like?

Thanks jorismoerings for your reply, yes agree with you , i want to give wightage to working hours while calculating efficiency ratio. In the Table 2 i would like B to be ranked 1 and A to be ranked 2 as they has put in more working hours as well as they have completed their task before standard time.

regards,
Vinod