Report
{{key?key:'Date'}} test
| # | Hero | Project | Revenue Center | Allocated Hours (A) | Allocated Billing Hours (B) | Actual Billed Hours(Monthly) (C) | Billing Percentage (D) | Actual Hours Logged(Monthly) (E) | Hours logged Percentage (F) |
|---|---|---|---|---|---|---|---|---|---|
| {{$index+1}} | {{d.emp_first_name +' '+d.emp_last_name}} | {{d.proj_name}} | {{d.rc_name}} | {{d.partialHours|| "0" }} | {{d.billableHours|| "0" }} | {{d.mngr_sum && d.partialHours?((d.mngr_sum/(d.partialHours * filter.selectedMonthBusinessDays)) * 100).toFixed(0):'0'}} | {{d.monthly_sum|| "0" }} | {{d.monthly_sum && d.partialHours?((d.monthly_sum/(d.partialHours * filter.selectedMonthBusinessDays)) * 100).toFixed(0): "0" }} |
Billing Efficiency
{{key?key:'Date'}} test
| Total Allocated Hours ( Sum of A * Working Days ) | {{totalPartialHours}} |
|---|---|
| Total Expected Billing Hours ( Sum of B * Working Days ) | {{totalSOWHours}} |
| Total Actual Billed Hours(Monthly) ( Sum of C ) | {{totalActualBilledHours}} |
| Overall Billing percentage Actual to Allocated ( (Sum of C / Sum of A * Working Days) * 100 ) | {{((totalActualBilledHours/(totalPartialHours)) * 100).toFixed(3)}} |
| Overall Billing percentage Actual to Expected Billing Hours ( (Sum of C / Sum of B * Working Days) * 100 ) | {{((totalActualBilledHours/(totalSOWHours)) * 100).toFixed(3)}} |