Sample output · Document

output-staffing-brief.md

As of 2026-10-05. Horizon Oct 26 to Sep 27. Pursuits: RIV 70%, CC15 80%, BLD 60%, LIT 50%, ENG 25%, AUR 30%. What-if moves: 0.

Decisions

  1. Decide now: Sam Okafor is over capacity Nov 26 to Feb 27. Peaks at 150% in Dec 26 against a 100% limit for Superintendent.
  2. Decide now: Wash Park Medical Office Building has 2 unfilled seats from Nov 26. Seats the staffing sheet leaves open:
    • Superintendent 25–100% Nov 26 to Sep 27: best internal option Paul Henning (covers 8 of 11 months, from Feb 27; no healthcare experience on the roster)
    • Assistant Superintendent 100% Apr 27 to Sep 27: best internal option Kyle Brennan (free for all of it; no healthcare experience on the roster)
  3. Plan: Megan Doyle is assigned while on leave. Feb 27 to Apr 27 on Union Station Lofts. Name cover or move the assignment.
  4. Plan: Arvada Distribution Center needs a Superintendent (25–100%) from Apr 27. Apr 27 to Jun 27; best internal option Dave Kowalski (free for all of it; industrial experience; pencilled on RIV).
  5. Plan: Union Station Lofts has 6 unfilled seats from May 27. Seats the staffing sheet leaves open:
    • Project Executive 25% May 27 to Sep 27: best internal option Raj Patel (free for all of it; multifamily experience; pencilled on LIT, AUR)
    • Project Manager 50–100% May 27 to Sep 27: best internal option Chris Novak (free for all of it; multifamily experience; pencilled on LIT)
    • Assistant Project Manager 100% May 27 to Jul 27: best internal option Megan Doyle (free for all of it; multifamily experience)
    • Project Engineer 100% May 27 to Jul 27: best internal option Noah Fischer (free for all of it; multifamily experience)
    • Superintendent 100% Jun 27 to Aug 27: best internal option Jim Walsh (free for all of it; multifamily experience; pencilled on LIT)
    • Assistant Superintendent 200% May 27 to Jul 27: best internal option Derek Young (only 100% free, from May 27; multifamily experience)
  6. Watch: Superintendents run 2.1 FTE short Dec 26 to Feb 27. 1.5 FTE short on committed work alone; the rest is weighted pursuit demand.
  7. Watch: If Boulder Biosciences Lab TI is won, Emma Larson goes to 150%. Jan 27 against a 100% limit. Pencilled on the pursuit while still committed elsewhere.
  8. Watch: If Boulder Biosciences Lab TI is won, Hannah Kim goes to 150%. Jan 27 against a 120% limit. Pencilled on the pursuit while still committed elsewhere.
  9. Watch: If Boulder Biosciences Lab TI is won, Rick Sorensen goes to 200%. Jan 27 to Feb 27 against a 100% limit. Pencilled on the pursuit while still committed elsewhere.
  10. Watch: Dave Kowalski is pencilled on Riverside Medical Office Building without ICRA. Mar 27 to Sep 27. The seat requires ICRA; the roster does not list it. Schedule the training or name someone certified.
  11. Watch: If Riverside Medical Office Building is won, Dave Kowalski goes to 125%. Mar 27 against a 100% limit. Pencilled on the pursuit while still committed elsewhere.
  12. Watch: If Littleton Senior Living is won, Chris Novak goes to 200%. Apr 27 to Jun 27 against a 120% limit. Pencilled on the pursuit while still committed elsewhere.
  13. Watch: If Aurora Data Center Phase 2 is won, Priya Raman goes to 125%. Jun 27 against a 120% limit. Pencilled on the pursuit while still committed elsewhere.

Unfilled seats

Job Role When Gap Best internal options
Union Station Lofts Project Executive May 27 to Sep 27 25% Raj Patel: free for all of it; multifamily experience; pencilled on LIT, AUR
Tom Brandt: free for all of it; no multifamily experience on the roster
Karen Whitfield: free for all of it; no multifamily experience on the roster; pencilled on RIV
Union Station Lofts Project Manager May 27 to Sep 27 50–100% Chris Novak: free for all of it; multifamily experience; pencilled on LIT
Ben Carter: free for all of it; no multifamily experience on the roster
Hannah Kim: free for all of it; no multifamily experience on the roster; pencilled on BLD
Union Station Lofts Assistant Project Manager May 27 to Jul 27 100% Megan Doyle: free for all of it; multifamily experience
Sofia Martinez: free for all of it; no multifamily experience on the roster
Lucas Ferreira: covers 1 of 3 months, from Jul 27; no multifamily experience on the roster
Union Station Lofts Project Engineer May 27 to Jul 27 100% Noah Fischer: free for all of it; multifamily experience
Kevin Tran: free for all of it; no multifamily experience on the roster
Emma Larson: free for all of it; no multifamily experience on the roster; pencilled on BLD
Union Station Lofts Superintendent Jun 27 to Aug 27 100% Jim Walsh: free for all of it; multifamily experience; pencilled on LIT
Carla Mendes: free for all of it; no multifamily experience on the roster
Paul Henning: free for all of it; no multifamily experience on the roster
Union Station Lofts Assistant Superintendent May 27 to Jul 27 200% Derek Young: only 100% free, from May 27; multifamily experience
Jake Miller: only 100% free, from May 27; multifamily experience
Kyle Brennan: only 100% free, from May 27; no multifamily experience on the roster
Arvada Distribution Center Superintendent Apr 27 to Jun 27 25–100% Dave Kowalski: free for all of it; industrial experience; pencilled on RIV
Paul Henning: free for all of it; no industrial experience on the roster
Sam Okafor: free for all of it; no industrial experience on the roster
Wash Park Medical Office Building Superintendent Nov 26 to Sep 27 25–100% Paul Henning: covers 8 of 11 months, from Feb 27; no healthcare experience on the roster
Sam Okafor: covers 7 of 11 months, from Mar 27; healthcare experience
Rick Sorensen: covers 7 of 11 months, from Mar 27; no healthcare experience on the roster; pencilled on BLD, CC15
Wash Park Medical Office Building Assistant Superintendent Apr 27 to Sep 27 100% Kyle Brennan: free for all of it; no healthcare experience on the roster
Derek Young: covers 5 of 6 months, from May 27; no healthcare experience on the roster
Jake Miller: covers 5 of 6 months, from May 27; no healthcare experience on the roster

Overloads and conflicts

  • Sam Okafor (Superintendent): Nov 26 to Feb 27, peak 150% in Dec 26, limit 100%.
  • Megan Doyle: assigned Feb 27 to Apr 27 while on leave (Union Station Lofts).
  • Dave Kowalski: pencilled on Riverside Medical Office Building Mar 27 to Sep 27 without ICRA.

Roll-offs in the next six months

  • Feb 27: Emma Larson 100% → 50% (DTC Plaza Lobby and Amenity Renovation ending).
  • Feb 27: Hannah Kim 100% → 50% (DTC Plaza Lobby and Amenity Renovation ending).
  • Feb 27: Paul Henning 100% → 0% (DTC Plaza Lobby and Amenity Renovation ending).
  • Feb 27: Sam Okafor 150% → 100% (DTC Plaza Lobby and Amenity Renovation ending).
  • Mar 27: Dana Liu 50% → 0% (Cherry Creek Tower Floors 12-14 TI ending).
  • Mar 27: Dave Kowalski 100% → 25% (Lakewood Self Storage ending).
  • Mar 27: Emma Larson 50% → 0% (Cherry Creek Tower Floors 12-14 TI ending).
  • Mar 27: Hannah Kim 50% → 0% (Golden Family Dental TI ending).
  • Mar 27: Kevin Tran 100% → 0% (Lakewood Self Storage ending).
  • Mar 27: Priya Raman 100% → 75% (Lakewood Self Storage ending).
  • Mar 27: Rick Sorensen 100% → 0% (Cherry Creek Tower Floors 12-14 TI ending).
  • Mar 27: Sam Okafor 100% → 0% (Golden Family Dental TI ending).

If pursuits are won

Pursuit Win % Start Unfilled if won Pencilled people who would go over
Riverside Medical Office Building 70% Mar 27 Assistant Project Manager 100%, Project Engineer 100%, Assistant Superintendent 100% Dave Kowalski 125%
Cherry Creek Tower Floor 15 TI 80% Mar 27 Fully pencilled None
Boulder Biosciences Lab TI 60% Jan 27 Fully pencilled Hannah Kim 150%, Emma Larson 150%, Rick Sorensen 200%
Littleton Senior Living 50% Apr 27 Assistant Project Manager 100%, Project Engineer 100%, Superintendent 100%, Assistant Superintendent 100% Chris Novak 200%
Englewood Middle School Addition 25% May 27 Project Manager 100%, Project Engineer 100%, Superintendent 100%, Assistant Superintendent 100% None
Aurora Data Center Phase 2 30% Jun 27 Assistant Project Manager 100%, Project Engineer 200%, Superintendent 100%, Assistant Superintendent 200% Priya Raman 125%

Hiring signal

  • Superintendent: 2.1 FTE short Dec 26 to Feb 27 (1.5 FTE short on committed work alone).

Open questions

  • Union Station Lofts substantial completion moved from April to July 2027 (schedule update 9/28), but the staffing sheet still rolls the whole team off in April to June. Extend Chris, Megan, Noah, Jim, Jake, and Derek, or name replacements? (projects.csv row 5; staffing-sheet.csv rows 8, 13, 20, 26, 32, 33)
  • Megan Doyle is on Union Station through April on the staffing sheet, but the HR roster shows parental leave February to April 2027. Who covers the APM seat? (staffing-sheet.csv row 13; roster.csv row 13)
  • Sam Okafor’s December and January cells read “GLD + DTC nights 1/2”. Treated as 50% on DTC night shifts on top of Golden Dental. Confirm that is real and not a note. (staffing-sheet.csv row 29)
  • Wash Park MOB superintendent row reads “TBD - Frank?”. Frank Delgado is not counted on Wash Park because the sheet already splits him across four jobs. (staffing-sheet.csv rows 22, 36)
  • Frank Delgado’s cells read “GS - UNI/ARV/STV/BRM” with no percentages. Entered as 25% each per the note “GS split 4 ways”. Confirm the split. (staffing-sheet.csv row 22)
  • Riverside MOB start moved from February to March 2027 per the owner. Pencilled names on the sheet were shifted one month to match. (pursuits.csv row 2; staffing-sheet.csv rows 2, 7, 23)

Proposal for review. Nothing was changed in the staffing sheet and nobody was notified.

Part of a fictional sample project for Workforce Planning.