Skip to main content

Methodology

Service Rate & Quote Planner methodology

This planner converts annual cost and profit requirements into a rate using saleable capacity, then applies project hours and a visible scope buffer. Utilisation is treated as an assumption to test, not an market-neutral benchmark.
Duc Nguyen X.By Duc Nguyen X.· Founder, Margin101Last reviewed: View update historyMethodology

Educational only: Business decision support, not accounting, tax or legal advice.

Privacy: Calculations run locally; Margin101 does not receive your commercial inputs.

Update policy: Reviewed when formulas or official dependencies change.

Scope: Market-neutral small-business planning using your own assumptions.

1. Formulas and units

Available hours
Hₐ = W × h

Where

W, h, Hₐ
working weeks, weekly hours and annual available hours (weeks/year and hours)Source: User assumption
Billable hours
H = Hₐ × u

Where

H
annual billable hours (hours/year)Source: Calculated output
u
billable utilisation (decimal)Source: User assumption
W, h, Hₐ
working weeks, weekly hours and annual available hours (weeks/year and hours)Source: User assumption
Required hourly rate
r = A ÷ H

Where

A
annual cost and profit recovery (currency units/year)Source: User decision
H
annual billable hours (hours/year)Source: Calculated output
r, rₑ
hourly rate and day rate (currency units/hour and currency units/day)Source: Calculated output
Day rate
rₑ = r × h_d

Where

r, rₑ
hourly rate and day rate (currency units/hour and currency units/day)Source: Calculated output
h_d
entered billable hours per quoted day (hours/day)Source: User decision
Project quote
Q = (r × Hₚ + E) ÷ (1 − b)

Where

b
scope or availability buffer (decimal)Source: User decision
r, rₑ
hourly rate and day rate (currency units/hour and currency units/day)Source: Calculated output
Hₚ, E, Cₚ
project hours, expenses and project delivery cost including entered expenses (hours and currency units/project)Source: Business record
Q, mₚ
project quote and delivery margin (currency units/project and decimal)Source: Calculated output
Effective project delivery margin
mₚ = (Q − Cₚ) ÷ Q

Where

Hₚ, E, Cₚ
project hours, expenses and project delivery cost including entered expenses (hours and currency units/project)Source: Business record
Q, mₚ
project quote and delivery margin (currency units/project and decimal)Source: Calculated output
Monthly retainer
R = (r × Hᵣ) ÷ (1 − b)

Where

b
scope or availability buffer (decimal)Source: User decision
r, rₑ
hourly rate and day rate (currency units/hour and currency units/day)Source: Calculated output
Hᵣ, Cᵣ
reserved monthly hours and allocated retainer cost (hours/month and currency units/month)Source: Business record
R, mᵣ
monthly retainer and delivery margin (currency units/month and decimal)Source: Calculated output
Effective retainer delivery margin
mᵣ = (R − Cᵣ) ÷ R

Where

Hᵣ, Cᵣ
reserved monthly hours and allocated retainer cost (hours/month and currency units/month)Source: Business record
R, mᵣ
monthly retainer and delivery margin (currency units/month and decimal)Source: Calculated output
Annual loaded labour cost
Cₗ = S + (S × e) + Oₗ

Where

S, Oₗ, Hₙ, uₗ
salary, other annual on-costs, other paid non-productive time and productive utilisation (currency units/year, hours/year and decimal)Source: User assumption
e
editable employer on-cost planning rate (decimal)Source: User assumption
Cₗ, Hₗ, rₗ
annual loaded cost, productive hours and loaded cost per productive hour (currency units/year, hours/year and currency units/hour)Source: Calculated output
Productive hours
Hₗ = ((52 − wₗ) × hₗ − Hₙ) × uₗ

Where

S, Oₗ, Hₙ, uₗ
salary, other annual on-costs, other paid non-productive time and productive utilisation (currency units/year, hours/year and decimal)Source: User assumption
wₗ
editable paid-leave planning weeks (weeks/year)Source: User assumption
hₗ
editable ordinary weekly-hours assumption (hours/week)Source: User assumption
Cₗ, Hₗ, rₗ
annual loaded cost, productive hours and loaded cost per productive hour (currency units/year, hours/year and currency units/hour)Source: Calculated output
Loaded cost per productive hour
rₗ = Cₗ ÷ Hₗ

Where

hₗ
editable ordinary weekly-hours assumption (hours/week)Source: User assumption
Cₗ, Hₗ, rₗ
annual loaded cost, productive hours and loaded cost per productive hour (currency units/year, hours/year and currency units/hour)Source: Calculated output
Retainer tier plus overage
Rₜ = (Hᵢ × r) ÷ (1 − b) + Hₒ × rₒ

Where

b
scope or availability buffer (decimal)Source: User decision
r, rₑ
hourly rate and day rate (currency units/hour and currency units/day)Source: Calculated output
Hᵢ, Hₒ, rₒ, Hₘ
included hours, expected overage hours and rate, and monthly capacity (hours/month and currency units/hour)Source: User assumption
Rₜ, H꜀
expected retainer-tier revenue and capacity remaining (currency units/month and hours/month)Source: Calculated output
Capacity remaining
H꜀ = Hₘ − Hᵢ − Hₒ

Where

H
annual billable hours (hours/year)Source: Calculated output
Hᵢ, Hₒ, rₒ, Hₘ
included hours, expected overage hours and rate, and monthly capacity (hours/month and currency units/hour)Source: User assumption

Money inputs and outputs use the currency selected in the scenario without changing the canonical methodology. Rates, margins, utilisation and buffers are entered as percentages and converted to decimal values for calculation.

2. Worked example

Input assumptions

Suppose annual costs are 120,000 currency units and the profit target is 30,000 currency units. If the operator expects 1,200 billable hours, the required rate is 150,000 currency units ÷ 1,200 = 125 currency units per hour excluding indirect tax.

Calculation and outputs

Example

Suppose annual costs are 120,000 currency units and the profit target is 30,000 currency units. If the operator expects 1,200 billable hours, the required rate is 150,000 currency units ÷ 1,200 = 125 currency units per hour excluding indirect tax.

Annual billable hours
1200.00 hours
Required hourly rate
125.00 currency units
Day rate from the 7.6-hour example
950.00 currency units
Project quote
11,764.71 currency units
Monthly retainer
2,777.78 currency units
Annual loaded labour cost
96,000.00 currency units
Loaded cost per productive hour
65.08 currency units
Retainer tier with expected overage
5,404.44 currency units
Retainer capacity remaining
56.00 hours

A 40-hour project with no expenses and a 10% scope buffer is (40 × 125 currency units) ÷ 0.90 = 5,555.56 currency units ex indirect tax. Reserving 20 hours each month with a 10% availability buffer uses the same gross-up and gives 2,777.78 currency units ex indirect tax.

Interpretation

Treat the sustainable rate as a commercial benchmark, then adjust the client price for scope risk, positioning and value.

3. Validation and boundary checks

  • Rate multiplied by billable hours should recover the annual cost and profit requirement before rounding.
  • Lower utilisation reduces billable hours and therefore raises the required rate when other assumptions stay fixed.
  • A zero buffer leaves the underlying hourly recovery unchanged; a 10% buffer divides the project or retainer recovery amount by 0.90.
  • Loaded labour adds salary, the entered employer on-cost rate and other entered on-costs once, while leave and non-productive time reduce the productive-hour denominator.
  • Included plus expected overage hours cannot exceed entered monthly capacity.

4. Assumptions and source classification

  • Working time, utilisation, annual costs, profit target, project hours, expenses, reserved retainer hours and buffers are user-supplied planning assumptions.
  • The displayed day rate converts the calculated hourly rate using the entered billable hours per quoted day. The 7.6-hour example is editable and is not a jurisdictional rule.
  • Project and retainer buffers gross the recovery amount up by dividing by one minus the entered buffer rate; they are not simple cost mark-ups.
  • The indirect tax rate is an editable user assumption used only as a display scenario after the tax-exclusive quote is calculated.
  • The loaded-labour example uses illustrative employer on-cost, paid-leave and weekly-hours assumptions. Replace them with the rules and employment terms that apply in the relevant jurisdiction.
  • Required rate, buffered hours and quote are calculated outputs, not market rates or promises of achievable utilisation.

This planner has no current policy-data dependency. Its commercial assumptions are user supplied. Registered family-level regression suites exercise the shared business-logic engine and worked-result reconciliation.

5. Limitations

  • The model does not determine demand, collection risk, worker classification, employment-rule coverage, benefit eligibility, leave liability, payroll tax, workers compensation or the legal terms of a quote.
  • It treats capacity as an annual planning average and does not model seasonality, multiple staff grades or timing of cash receipts.

This is educational decision support, not tax, accounting, legal or financial advice. Check the treatment of your actual transactions under the rules that apply to your business and seek qualified advice where appropriate.

6. Update and evidence policy

Registered family-level suites test formula invariants and example reconciliation; the release ledger records that coverage without claiming a separate oracle for every line of public copy. There is no official threshold or benchmark to refresh for this planner. Commercial inputs remain user-supplied because they vary by business and contract.

Change history

  1. : Initial public release of the planner and methodology after pre-launch calculation, content, source and interaction review.

Related reading

Guides to interpret the decision and its assumptions.

Return to the planner