Resource Capacity Planner
Use team members, hours per member in period, available delivery time (%), already committed hours to prepare the resource capacity planner record. The worksheet applies the displayed arithmetic to your supplied values; it does not retrieve account data.
Use team members, hours per member in period, available delivery time (%), already committed hours to prepare the resource capacity planner record. The worksheet applies the displayed arithmetic to your supplied values; it does not retrieve account data.
Reading capacity and cost without hiding the workload
This worksheet calculates the displayed relationship from the supplied quantities. Its label and period conventions determine how the amount should be interpreted. A staffing plan needs available hours and the portion of those hours that can serve the intended work. Paid time, productive time and billable time are separate definitions. Recruiting, training and supervision can change the cost of a role.
Scope of this operation
The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options. The example output for resource capacity planner is shown below so the supplied source can be checked against the actual format. It is not evidence that the operation has run against your own file or account.
How it works
Uncommitted hours = [Team members] × [Hours per member in period] × [Available delivery time (%)] ÷ 100 − [Already committed hours]
Inputs
| Field | Example | Definition |
|---|---|---|
| Team members | 5 | Use the source quantity represented by team members. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Hours per member in period | 160 | Use the duration unit stated in hours per member in period. A time period is not interchangeable with a currency amount or a count of events. |
| Available delivery time (%) | 70 | Enter available delivery time (%) on the percentage scale used in the formula (20 means 20%, not 0.20). Keep its base and reporting period consistent with the other inputs. |
| Already committed hours | 400 | Use the duration unit stated in already committed hours. A time period is not interchangeable with a currency amount or a count of events. |
Step-by-step guide
Prepare the source
Supply Team members, Hours per member in period, Available delivery time (%). Keep the original material so the output can be compared with it.
Build output
Check Team members, Hours per member in period, then select Generate output.
Use the result
Compare the resource capacity planner result with the unchanged source before copying or downloading it.
When to use it
Uncommitted hours = [Team members] × [Hours per member in period] × [Available delivery time (%)] ÷ 100 − [Already committed hours] The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options.
Example and scope
Example inputs: Team members: 5; Hours per member in period: 160; Available delivery time (%): 70; Already committed hours: 400.
The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options.
Worked output
Uncommitted hours: 160 Assumptions: people: 5 hours: 160 utilization: 70 committed: 400
Related tool family
This focused tool is associated with Agency Bench Cost Calculator. Use it when you need to isolate a specific part of that wider workflow.
Several parent models may support the same step. Keep the business question visible and choose the version that best matches the process you actually need to manage.
Related parent models
Agency Bench Cost Calculator, Scope Creep Cost Calculator, Change Order Margin Calculator, Project Quote Margin Calculator, Agency Break Even Client Calculator, Agency Valuation Multiple Calculator
Keep the displayed formula, input units and model scope with the result. Corrections or questions can be sent through the request section on this page.