Tabellab
HR & People Ops Intermediate

Contingent Workforce Costs: Agency Markups, Contractor Day Rates, Fixed-Fee Statements of Work, Conversion Fees & Total Cost per Hour

See what temps, contractors and outsourced projects really cost the company that buys them: comparable hourly rates, agency markups vs loaded employee costs, rate-card checks, fixed fee vs time and materials, temp-to-perm conversion fees, extensions and a workforce mix dashboard, with every cell checked as you go.

8 lessons 8 labs 2.1 h Certificate

One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.

About this course

In this course you work out what contingent workers really cost a fictional manufacturer with three sites. You turn hourly, daily and monthly rates into one comparable hourly rate with IFS, build agency bill rates from pay rates and markups and compare them with a loaded employee cost per productive hour. XLOOKUP checks contractor rates against a rate card by role and level, SUMPRODUCT prices fixed-fee work against time and materials, and an approximate XLOOKUP finds temp-to-perm fee bands. EDATE plans assignment end dates, SUMIFS builds spend reports by category, department and supplier, and a dashboard compares employee and contingent FTE, cost per FTE and a conversion scenario with a chart.

Lessons

  1. Hourly, Daily, Monthly: Turning Every Rate into One Comparable Hourly RateLab15 min Pro
  2. Agency Temps: Pay Rate × Markup = Bill Rate, and the Loaded Cost of an EmployeeLab16 min Pro
  3. Rate-Card Compliance: Card Rates by Role and Level, Overpayments and SavingsLab16 min Pro
  4. Fixed-Fee Statements of Work vs Time and Materials: Estimates, Change Requests and OverrunsLab16 min Pro
  5. Temp-to-Perm Conversion Fees: Fee Scales by Weeks Worked and the Break-Even PointLab16 min Pro
  6. Tenure & Extensions: Planned End Dates, Months on Assignment and the Cost of ExtendingLab15 min Pro
  7. Contingent Spend Reporting: By Category, Department and Supplier, and the Share of Workforce CostLab16 min Pro
  8. Workforce Mix Dashboard: Employees vs Contingent FTE and Cost, a Conversion Scenario and a ChartLab18 min Pro