Executive AI Dinner hosted by Kumo - Austin, April 8

Register here
3Regression · Workforce Planning

Workforce Planning & Staffing Optimization

How many service hours will each location need over the next 7 days?

Book a demo and get a free trial of the full platform: research agent, fine-tune capabilities, and forward-deployed engineer support.

By submitting, you accept the Terms and Privacy Policy.

Loved by data scientists, ML engineers & CXOs at

Catalina Logo

A real-world example

How many service hours will each location need over the next 7 days?

Overstaffing wastes 15–20% of labor budgets; understaffing leads to 2–3x overtime costs and degraded service quality. Most workforce planners rely on simple averages that miss event-driven spikes, seasonal patterns, and cross-location dependencies. When a convention comes to town or flu season peaks, the model that only sees last week's hours is already behind.

Quick answer

Workforce planning predicts how many service hours each location will need over the next 7 days. Graph-based models connect locations to appointments, staff rosters, event calendars, and seasonal patterns, catching demand spikes from trade shows, flu seasons, and cross-location dependencies that simple averaging misses entirely.

Approaches compared

4 ways to solve this problem

1. Historical Averages

Staff each location based on the same week last year or a rolling 4-week average. Simple, requires no technology, and is the default at most service organizations.

Best for

Stable businesses with minimal demand variability and no event-driven spikes.

Watch out for

Misses every demand spike that was not present in the historical window. A convention coming to town, a flu outbreak, or a competitor closing all create demand that last year's numbers do not reflect.

2. Scheduling Software Rules (Kronos, When I Work)

Workforce management platforms that use rules and simple forecasts based on historical transactions per hour. Automate shift creation based on predicted volume.

Best for

Retail and hospitality with steady traffic patterns and standardized shift structures.

Watch out for

Rules are static. They cannot learn from cross-location patterns (trade show weeks affect multiple clinics) or incorporate external signals (weather, events) without custom integration.

3. Time-Series Forecasting per Location

Fit Prophet, ARIMA, or similar models to each location's hourly or daily appointment volume. Captures trend and seasonality per location independently.

Best for

Locations with long, clean appointment histories and predictable weekly cycles.

Watch out for

Treats each location as independent. Cannot see that two locations in the same metro area compete for the same demand pool, or that a regional event will spike both simultaneously. Also struggles with locations that have short histories (new branches).

4. KumoRFM (Graph Neural Networks on Relational Data)

Connects locations, appointments, staff, and event calendars into a relational graph. Learns cross-location demand patterns, staff skill mix effects, and event-driven spikes automatically.

Best for

Multi-location service businesses where demand depends on regional events, staff specialization, and cross-location patient/client flow.

Watch out for

Requires appointment-level data with timestamps. If your scheduling system only tracks daily totals, the model has less signal to work with for hourly predictions.

Key metric: Graph-based workforce models reduce overtime costs by 30% and cut understaffing incidents by 40%, driven by cross-location demand signals that independent-location models cannot capture.

Why relational data changes the answer

Location L-05 (Downtown Clinic) needs 342 service hours next week. A simple average might predict 310 based on the last 4 weeks. But the relational graph sees several compounding factors: a trade show is active in the metro area (EVENTS table), driving 24% more walk-in appointments at both L-05 and nearby L-12. The fall intake seasonal pattern is at its peak (historical APPOINTMENTS data cross-referenced with calendar). Staff utilization is already at 87%, and the appointment complexity mix is trending toward longer, more specialized visits that require Senior Clinicians.

The cross-location dependency is especially important. When L-12 (Westside Branch) is at capacity, overflow patients are redirected to L-05. This spillover effect lives in the location-appointment-staff graph and is invisible to any model that forecasts each location independently. Graph neural networks propagate information across these connections: if L-12 is predicted to be at 100% capacity, L-05's forecast automatically adjusts upward for the expected overflow. On practical benchmarks, graph-based workforce models reduce overtime costs by 25-35% compared to average-based scheduling because they anticipate spikes instead of reacting to them.

Staffing a clinic based on last month's average is like an airline scheduling crew based on last year's flight count. A relational model is like seeing the actual booking data, connecting flight delays, crew certifications, airport weather, and maintenance schedules. You staff for what is actually coming, not what happened before.

How KumoRFM solves this

Relational intelligence for every forecast

Kumo connects locations to appointments, staff rosters, local event calendars, and seasonal patterns in a unified relational graph. Instead of treating each location as an independent time series, Kumo learns that Location L-05 shares a region with L-12 and both spike during trade-show weeks, that staff role mix affects appointment duration, and that holiday periods shift demand predictably. These cross-entity signals produce staffing forecasts that anticipate spikes before they hit.

From data to predictions

See the full pipeline in action

Connect your tables, write a PQL query, and get predictions with built-in explainability — all in minutes, not months.

1

Your data

The relational tables Kumo learns from

LOCATIONS

location_idlocation_nameregiontype
L-05Downtown ClinicMetroprimary
L-12Westside BranchMetrosatellite
L-28Harbor OfficeCoastalprimary

APPOINTMENTS

appt_idlocation_idstaff_idduration_hourstimestamp
APT-4001L-05EMP-1101.52025-09-15
APT-4002L-05EMP-1152.02025-09-15
APT-4003L-12EMP-2201.02025-09-16

STAFF

staff_idnamerolelocation_id
EMP-110Sarah ChenSenior ClinicianL-05
EMP-115Marcus RiveraClinicianL-05
EMP-220Priya SharmaClinicianL-12
2

Write your PQL query

Describe what to predict in 2–3 lines — Kumo handles the rest

PQL
PREDICT SUM(APPOINTMENTS.DURATION_HOURS, 0, 7, days)
FOR EACH LOCATIONS.LOCATION_ID
3

Prediction output

Every entity gets a score, updated continuously

LOCATION_IDTIMESTAMPTARGET_PRED
L-052025-09-22342
L-122025-09-22128
L-282025-09-22510
4

Understand why

Every prediction includes feature attributions — no black boxes

Location L-05 (Downtown Clinic)

Predicted: 342 service hours needed in next 7 days

Top contributing features

Historical booking trend (4w)

+12%

28% attribution

Local events (trade show)

Active

24% attribution

Seasonal pattern (fall intake)

Peak

21% attribution

Staff utilization rate

87%

15% attribution

Appointment complexity mix

High

12% attribution

Feature attributions are computed automatically for every prediction. No separate tooling required. Learn more about Kumo explainability

Frequently asked questions

Common questions about workforce planning & staffing optimization

How far ahead can AI predict staffing needs?

For most service businesses, 7-14 day prediction windows deliver the best results. This gives operations teams enough time to adjust schedules, bring in temporary staff, or redirect appointments to other locations. Same-day predictions are useful for real-time adjustments but too late for structural scheduling changes.

Can workforce planning AI account for employee skills and certifications?

Yes. Graph models connect staff members to their roles, certifications, and historical appointment types. The model can predict not just total hours needed but hours needed by role type. If next week requires 40% more Senior Clinician hours due to complex appointment mix, the graph captures this from the staff-appointment-complexity relationship.

How do local events affect staffing predictions?

Events like trade shows, sports games, and conferences create demand spikes that vary by location proximity and event type. Graph models learn these patterns by connecting the event calendar to locations and historical appointment volumes during past events. A medical conference in the metro area might increase specialist appointments by 30% at nearby clinics.

What is the ROI of AI-driven workforce planning?

The primary savings come from reducing overtime (30% typical reduction) and temporary staffing costs (20% reduction). Secondary benefits include improved service quality from better staffing ratios and reduced employee burnout from more balanced scheduling. For a 50-location service organization, this typically translates to $2-5M in annual savings.

Bottom line: Reduce overtime costs by 30% and improve service quality by matching staffing levels to actual predicted demand — not last month's average.

Topics covered

workforce planning AIstaffing optimization machine learninglabor demand forecastingservice hour predictionlocation staffing AIKumoRFMrelational deep learningpredictive query languageworkforce demand predictionlabor scheduling optimizationautomated workforce planningovertime cost reduction

One Platform. One Model. Infinite Predictions.

KumoRFM

Relational Foundation Model

Turn structured relational data into predictions in seconds. KumoRFM delivers zero-shot predictions that rival months of traditional data science. No training, feature engineering, or infrastructure required. Just connect your data and start predicting.

For critical use cases, fine-tune KumoRFM on your data using the Kumo platform and Research Agent for 30%+ higher accuracy than traditional models.

Book a demo and get a free trial of the full platform: research agent, fine-tune capabilities, and forward-deployed engineer support.