Workforce plan, an interactive deck

Workforce plan: who covers the extra work?

A sample interactive deck on one decision: how should we cover the extra work? Three plans: A. contractors only, B. hire, C. automate plus hire. The team must absorb extra work for the next 24 months, counted in full-time-equivalent staff (FTE: one person working full time). Change any input, and every slide recalculates, its title included. Every figure is invented. It is not any company's data.

Or set your own

Extra workFTE

4 FTEfor 24 months20 FTE

Contractor premium%

20%over a permanent hire80%

Hiring lead timemonths

1 monthapproval to start date6 months

Share automation can take%

0%of the extra work40%

Held fixed: a permanent hire costs $9,000 a month, fully loaded, and is 50% productive in their first 3 months. Each hire also costs $15,000 to recruit, paid when they start, and $27,000 (three months' fully loaded cost) to exit or redeploy in month 24, when the work ends. Automation costs $150,000 up front in month 1 and $4,000 a month to run once it starts covering its share in month 4. Contractors are fully productive from month 1 and fill every gap, so no plan leaves work uncovered.

Change the inputs ↑

Use ← and → to move between slides. Read down the storyline on the leftabove: the titles alone tell the argument, and they rewrite themselves as you change the case.

See the numbers

Source: the invented assumptions in the sidebar and the Held-fixed line. How: month-by-month model, before tax. Monthly costs are rounded to the dollar; the totals come from the unrounded figures, so the rounded rows may not add up exactly to them. Left out: tax, financing, inflation and attrition (every hire stays the full 24 months).

Why an interactive deck? A static deck shows only the few combinations its authors picked, so a doubtful reader can only question the picks. Here the reader tests their own, and the meeting can spend its time on which assumptions to believe. The separate scenario lab takes the same approach further, with every lever and the month-by-month workings for the launch case.

Built by Junsheng (JS) Chen · LinkedIn profile

Workforce plan: who covers the extra work?