Description
Subtract excludedHours from paidHours for positive eligibleHours and divide billableHours by it.
Capacity accounting compares available supply with commitments, reservations, or demand. Negative residuals can expose overload while zero capacity requires a distinct undefined utilization state.
Subtract excludedHours from paidHours for positive eligibleHours and divide billableHours by it.
When to use this tool
Use Resource Utilization Billable Exclusion when you need a transparent resource or workload capacity term.
How to use the tool and how it works
- Enter paidHours, excludedHours, billableHours. Use the units and conventions below.
- Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
- Read eligibleHours, utilization. Use the output convention below.
Subtract excludedHours from paidHours for positive eligibleHours and divide billableHours by it. Billable hours cannot exceed eligible hours.1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| paidHours | Paid Hours | Required. Finite number. |
| excludedHours | Excluded Hours | Required. Finite number; minimum 0. |
| billableHours | Billable Hours | Required. Finite number; minimum 0. |
| Output field | Interpretation | Returned shape |
|---|---|---|
| eligibleHours | Eligible Hours | Required. Finite number. |
| utilization | Utilization | Required. Finite number. |
{
"input": {
"paidHours": 40,
"excludedHours": 8,
"billableHours": 24
},
"output": {
"eligibleHours": 32,
"utilization": 0.75
}
}Limitations and assumptions
- This follows the supplied exclusion basis without validating time records, billing contracts, or employment policy.
- Inputs must satisfy both the field types and the cross-field conditions above. Invalid input causes an error; a successful false flag or documented placeholder is a different result.
- Numeric calculations use binary floating point unless exact decimal-integer arithmetic is explicitly stated. No hidden measurement tolerance or decimal rounding is added; nonfinite or out-of-contract results are rejected. Numeric signed-zero results are exported as zero.
Alternative or Complementary methods
Validate calendars, skill constraints, and concurrent demand with the actual resource plan.
References
Similar or alternative tools
- Workload Availability Holiday Adjustment
Subtract holidayDays from workDays, multiply by hoursPerDay, and subtract otherUnavailableHours for availableHours.
- Resource Share Zero Capacity Flag
Divide demand by capacity only when capacity is positive; otherwise return utilization zero and defined false.