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
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
regards
Vinod
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
Staff | Standard time in minutes | Actual time taken in minutes | efficiecny ratio |
(a) | (b) | © | (b)/© |
A | 45 | 45 | 1.00 |
B | 60 | 55 | 1.09 |
C | 75 | 45 | 1.67 |
D | 55 | 45 | 1.22 |
A | 65 | 60 | 1.08 |
B | 75 | 70 | 1.07 |
C | 85 | 55 | 1.55 |
D | 95 | 85 | 1.12 |
A | 105 | 100 | 1.05 |
B | 115 | 115 | 1.00 |
<tbody>
</tbody>
Table 2
Staff | Average efficiency ratio | Total hours |
A | 104% | 205 |
B | 105% | 240 |
C | 161% | 100 |
D | 117% | 130 |
<tbody>
</tbody>
regards
Vinod