Inputs
Formula Used
- Trainer cost = (Delivery hours × Trainer rate) + (Prep hours × Prep rate)
- Admin cost = Admin hours × Admin rate
- Variable costs = Trainees × (Materials + Platform + Travel + Meals + Accommodation + Certification + Other)
- Fixed costs = Venue + Equipment + Other fixed
- Direct cost = Trainer + Admin + Variable + Fixed − Discount
- Overhead = Direct × (Overhead% ÷ 100)
- Opportunity = Trainees × Delivery hours × Average wage (optional)
- Total = (Direct + Overhead + Opportunity + Contingency) + Tax
How to Use This Calculator
- Enter trainees and total delivery hours for the cohort.
- Add trainer delivery and preparation rates and hours.
- Fill per‑trainee items like materials, platform, travel, and meals.
- Add fixed costs like venue, equipment, and one‑time vendor fees.
- Set overhead, contingency, and optional tax percentage.
- Enable opportunity cost if you want full economic cost.
- Press Estimate Cost to view results above the form.
- Download CSV or PDF for sharing and budget approvals.
Example Data Table
| Scenario | Trainees | Hours | Trainer rate | Per‑trainee items | Fixed costs | Overhead | Estimated total |
|---|---|---|---|---|---|---|---|
| New hire onboarding | 25 | 12 | $60/hr | $22 each | $300 | 10% | $2,680 |
| Compliance refresh | 60 | 3 | $90/hr | $4 each | $0 | 8% | $1,021 |
| Leadership workshop | 18 | 16 | $150/hr | $45 each | $900 | 12% | $5,544 |
Cost drivers to capture before budgeting
Build estimate from four buckets: trainer, admin, variable, and fixed. Trainer cost equals delivery hours × delivery rate plus prep hours × prep rate. Admin cost equals coordinator hours × admin rate. Variable cost equals trainees × per‑trainee items. Fixed cost covers venue, equipment, and one‑time vendor fees. Example: 20 trainees, 16 hours, 75/hr delivery, 6 prep hours at 75/hr gives trainer cost 1,650.
Planning prep-to-delivery ratios
Prep time is the fastest lever to change totals, so track it explicitly. Use the ratio prep hours ÷ delivery hours to compare programs. With 6 prep hours on 16 delivery hours, the ratio is 37.5%. If you repeat the same workshop, prep may drop to 10–20%. If you customize for a new system rollout, it can exceed 50%, especially when building exercises and assessments.
How cohort size changes unit cost
Fixed costs spread across trainees, so cost per trainee generally falls as class size grows. If fixed costs are 370 and you train 10 people, that is 37 each; at 25 people, it is 14.8 each. Variable costs scale linearly: 30 trainees × 20 per‑trainee items adds 600. Run scenarios for 15, 25, and 40 learners, then compare cost per trainee and cost per trainee‑hour to align with capacity limits.
Overhead, contingency, and tax controls
Overhead is applied to direct cost after discounts, reflecting shared services like facilities and IT. Contingency is applied to the base (direct + overhead + opportunity, if used) to cover uncertainty like venue changes or added licenses. Keep the contingency percent consistent with policy and document exceptions. Tax is applied last to the subtotal; set it to zero when taxes are not applicable or already embedded in vendor quotes.
Using opportunity cost for decision making
Opportunity cost estimates paid time in training: trainees × delivery hours × average wage. This does not change budget, but it changes portfolio decisions. Example: 20 trainees × 16 hours × 12 wage adds 3,840 of economic cost. Compare two options with equal spend: a shorter course can be cheaper and reduces time away from work. Pair this with per class hour to spot high-cost sessions.
FAQs
What costs should be included for external trainers?
Enter delivery hours and the trainer rate, then add prep hours and prep rate. Include any one‑time facilitation fees as “Other fixed” if they do not scale per trainee.
How do I estimate per‑employee cost for multiple sessions?
Run one estimate per cohort or session, then add the grand totals. If inputs are identical, multiply the total by the number of sessions to speed planning.
When should I enable opportunity cost?
Enable it when time away from work matters for comparison, capacity, or ROI. Use an average loaded wage rate so the estimate reflects real labor cost during training hours.
How do I set overhead and contingency?
Use your internal policy rates when available. If not, choose a consistent overhead percent for shared services and a smaller contingency percent for uncertainty, then document the assumption in Notes.
Can I model discounts or vendor subsidies?
Yes. Enter the amount in Discount/Subsidy. The tool caps the discount to prevent negative direct cost, keeping totals realistic for approvals and reporting.
What KPIs should I report to leadership?
Share grand total, cost per trainee, cost per class hour, and cost per trainee‑hour. Add the breakdown table to show which levers—trainer time, fixed fees, or per‑trainee items—drive the number.