1/ Definition
The indicator shows the rate of available resource workload scheduled. It means the amount of work scheduled face to the total available work power. workload scheduled resources during the last week.
2/ Objective / Target
The objective is to show the amount of resources we are scheduling , in order to know wich which are the resources alocated allocated to planned works. One of the biggest interests is to compare this indicator face to the scheduling adherenceschedule compliance. Comparing both of them we can find the good level of resources to be scheduled. This indicator may also show us the accuracy of hour our planning process in timing time estimation.In the evoultion expected we should compare scheduling adherence and available resources scheduled at the same time. With a constant value for available resources scheduled the scheduling adherence should improve.
Example of a good target (Benchmark SolMaX): 80%
3/ Formula
| % available resource scheduled : [ ( ∑ scheduled workload for the last week (remaining work in hours)) / (available resource workload for the last week (capacity in hours) ) ] x 100 |
|---|
4/ Frequency
Weekly
5/ SAP extraction and detailed calculation
QlikView layout
Table ZWBWT001 for PF1 / ZWBWT002 for RCS. Those tables are for DT only
Tableau layout
