Monthly Retainer Capacity Calculator

An apparently profitable retainer can fail in two different ways. It may sell more availability than the provider can reliably deliver, or it may fit the calendar while leaving too little margin after delivery cost. Capacity and price therefore need to be tested together before another recurring commitment is accepted.

Included hours are only the visible part of the promise. Faster response times interrupt planned work, and rollover lets unused entitlement arrive in a later month. A capacity plan reserves for those obligations even when average logged delivery looks comfortable.

Commitment should be measured conservatively. When expected use exceeds included hours, the higher amount drives the capacity requirement. When expected use is lower, the included-hour entitlement still remains the minimum before response reserve and rollover exposure are added.

Margin needs its own stress case. Expected delivery cost describes an ordinary month, included-cap cost assumes every included hour is used, and stress cost also values reserved response and rollover exposure. A quote that passes only the expected-use margin can become fragile during a busy month.

The result is a planning model, not a promise that demand arrives evenly or that every reserved hour is interchangeable. Skill mix, deadlines, simultaneous requests, scope boundaries, subcontractor availability, taxes, and payment risk still need separate judgment.

How to Use This Tool:

Model one retainer offer against the monthly delivery pool and commitments that already exist.

1. Choose a planning profile as a starting point, then replace its values with the real monthly capacity, existing retained commitments, and operating buffer.
2. Enter the monthly fee, included service hours, expected use, standard hourly rate, and loaded delivery cost in one currency denomination.
3. Select the response commitment and rollover policy. For a custom response reserve, enter the percentage of included hours that must remain available.
4. Enter the proposed new retainer count, target stress margin, and overage-rate multiplier.
5. Review Safe additional retainers, Headroom after proposed, and Stress margin together. Capacity fit does not guarantee an acceptable margin.
6. If the plan is withheld, correct the named range or policy. In particular, monthly fee and standard rate must be positive, proposed retainers must be a whole number from 0 to 100, and the target margin cannot exceed 95%.

Interpreting Results:

Safe additional retainers is the whole number that fits after the operating buffer and existing commitments are deducted. Headroom after proposed tests the count actually entered. A value below zero is an over-capacity plan; a non-negative value smaller than one more retainer commitment is marked tight.

Committed utilization compares existing plus proposed commitments with protected capacity, not with all nominal hours. One hundred percent is the protected limit. A lower percentage is not automatically waste if the remaining room supports project work, leave, or demand spikes.

Stress margin is the stricter pricing check because it costs the full capacity commitment per retainer. When it misses the target, Fee needed at target margin and Rate needed at target margin show the price implied by the current assumptions. They are planning outputs, not market-price recommendations.

Technical Details:

The model first protects part of the monthly delivery pool, then builds a conservative hourly commitment for one retainer. Capacity counts and margin tests are derived from that same commitment.

Formula Core:

Protected capacity P reduces monthly delivery capacity C by operating buffer b. Expected delivery D applies expected-use percentage u to included hours H.

Unused hours are the positive remainder of included hours after expected delivery. Rollover exposure X applies the selected rollover percentage r and cap, while response reserve S applies response percentage q. The commitment K uses the larger of included hours and expected delivery, then adds both reserves.

With existing commitments E and proposed count n, safe additional retainers use floor division. Headroom keeps its sign so an over-capacity proposal remains visible.

Margin Core:

Gross margin is evaluated at expected delivery, the included-hour cap, and the full stress commitment. Revenue is the monthly retainer fee F; loaded delivery cost per hour is c.

Use h = D for expected margin, H for cap margin, and K for stress margin. The target-margin fee uses stress cost and target percentage t. Effective hourly rate is fee divided by included hours; the overage rate is the standard hourly rate multiplied by the chosen overage factor.

Policy Lookup Core:

These percentages are named planning assumptions, not industry standards. Changing a policy changes both the capacity commitment and stress margin.

Decision Rule Core:

• The proposed count fits when headroom is greater than or equal to 0 hours.
• A fitting plan is tight when headroom is less than one commitment per retainer.
• Cap margin and stress margin pass when the calculated margin is greater than or equal to the target margin.
• Over-capacity hours equal the positive amount by which headroom falls below zero.

The model keeps full numeric precision. Currency selection changes denomination and formatting only; it does not perform exchange-rate conversion.

Limitations:

This is an educational planning estimate, not accounting, legal, tax, or financial advice. The arithmetic assumes hours are interchangeable and monthly obligations can be represented by averages and reserves.

• Model simultaneous deadlines, specialist bottlenecks, leave, and subcontractor limits separately.
• Treat rollover and response percentages as contract assumptions to negotiate, not observed demand.
• Check taxes, payment delays, software costs, bad debt, and non-hourly scope outside the gross-margin result.

Worked Examples: