Consolidation of Setup KPIs
- Total Setup Calendar Hours KPI
- Daily Setup Hours KPI
- Total Setup Labor Hours KPI
- Total Setup Cost KPI
Total Setup Calendar Hours KPI
The total scheduled Setup Hours in the entire schedule based on calendar time (independent of the number of Resources used during the setup).
Calculation
Total Setup Calendar Hours KPI = For all Activities where Activity.Scheduled = true, SUM(Activity.ScheduledSetupSpan)
Significant Data
- Activity.ScheduledSetupSpan
Daily Setup Hours KPI
The daily average of Setup Hours in the Short Term.
Calculation
Daily Setup Hours KPI = For all scheduled Activities where Activity.ScheduledStartDate < SystemOptions.ShortTermSpanEnd, SUM(Activity.ScheduledSetupSpan) / ShortTermSpan.TotalDays
Significant Data
- Activity.ScheduledStartDate
- SystemOptions.ShortTermSpanEnd
- Activity.ScheduledSetupSpan
- ShortTermSpan.TotalDays
Total Setup Labor Hours KPI
The total scheduled Setup Hours in the entire schedule based on the number of utilized Resources that have a Resource Type that is a type of person.
Calculation
Total Setup Labor Hours KPI = For all Activities where Activity.Scheduled = true, SUM(Activity.ScheduledSetupSpan) if Resource.ResourceType = Employee OR Engineer OR Inspector OR Labor OR Operator OR Supervisor OR Team OR Technician
Significant Data
- Activity.Scheduled
- Activity.ScheduledSetupSpan
- Resource.ResourceType
Total Setup Cost KPI
The total scheduled Setup Hours times Resource Standard Cost.
Calculation
Total Setup Cost KPI = For all Activities where Activity.Scheduled = true, SUM(Resource.StandardHourlyCost * CapacityInterval.Duration where CapacityInterval.IntervalType = Online) + SUM(Resource.OvertimeHourlyCost * CapacityInterval.Duration where CapacityInterval.IntervalType = Overtime OR CapacityInterval.IntervalType = Potential Overtime) + SUM(Activity.ReportedSetupSpan * Resource.StandardHourlyCost)
Significant Data
- Activity.Scheduled
- Resource.StandardHourlyCost
- Resource.OvertimeHourlyCost
- CapacityInterval.Duration
- CapacityInterval.IntervalType
- Activity.ReportedSetupSpan
Special Considerations
There is no way to determine if Activity.ReportedSetupSpan was run during Online, Overtime, or Potential Overtime so Resource.StandardHourlyCost is used here.