Calculator Inputs
Responsive layout: 3 columns large, 2 medium, 1 mobile.
How to use this calculator
- Set scope: choose annual or quarterly planning, then input total and eligible headcount.
- Estimate demand: enter participation rate and average hours per learner.
- Price delivery: fill internal, external, travel, and facility costs using your policies.
- Add controls: set admin overhead and contingency to reflect execution risk.
- Calculate and share: export CSV for finance, and PDF for stakeholders.
Formulas used
Core volume
- Learners = eligible employees × participation rate
- Travelers = learners × traveling learners rate
- Total learner hours = learners × avg training hours
Costs
- Direct costs = internal + external + travel + facilities + admin overhead
- Time cost = learners × training hours × fully loaded hourly rate
- Contingency = (direct costs + time cost) × contingency rate
- Total budget = direct costs + time cost + contingency
Key ratios
Budget per learner = total budget ÷ learners
Budget per employee = total budget ÷ total employees
Budget per hour = total budget ÷ total learner hours
Payroll share is estimated as total budget ÷ (employees × average salary).
Example data table
Use this sample to sanity-check your assumptions before finalizing approvals.
| Program type | Learners | Hours | Cost per learner | Typical notes |
|---|---|---|---|---|
| Onboarding refresh | 120 | 4 | 15.00 | Internal sessions + materials |
| Manager essentials | 60 | 10 | 95.00 | Blended; some travel |
| Role certification | 45 | 14 | 160.00 | Vendor + exam fees |
| Security awareness | 400 | 2 | 8.00 | Platform subscription |
Tip: If your travel policy is strict, adjust the traveling learners rate first.