All work stories
Anonymized case studyHome care / workforce services

Building a home-care growth model around staffed capacity

A home-care provider needed to rebuild its forecast after operating conditions changed how care staff were sourced. Families paid monthly for dedicated caregivers or nurses, making every occupied contract both recurring revenue and a staffing obligation.

Business-model reset and growth planningFinancial model
Home-care team supporting older adults across several homes with coordination, relief coverage and transport.
Original concept illustration. No client data shown.
CONFIDENTIAL BY DESIGNWhy you won’t see the client workbook

Financial models contain pricing, salaries, conversion assumptions, funding plans and other sensitive data. I do not publish client workbooks, identifiable screenshots or proprietary inputs—especially where an NDA applies. This page uses an anonymized summary and original concept art to explain the business decision and my modeling approach.

One-to-oneCapacity logic

Each active contract depended on an available caregiver or nurse, so demand and staffing could not be forecast independently.

MonthlyContract economics

Recurring fees and frontline employment costs were traced separately for each service type.

StepwiseSupport ratios

Relief coverage, managers, drivers and vehicles switched on at explicit team thresholds.

Cohort-ledHiring cash

Recruitment and onboarding costs followed staff cohorts and their sourcing assumptions.

WHY THIS WASN’T A TEMPLATE EXERCISE

The model had to respect
how the business actually moved.

The model connects patient acquisition and contract duration to available care staff, service mix, support ratios, recruitment cohorts and fleet thresholds, turning the growth target into a capacity-and-cash plan.

01

Demand could not be served without a person

Unlike a digital subscription, every new patient contract required an available professional. A sales forecast that ignored hiring lead time, deployment and unfilled capacity would overstate billable service.

02

Customers and employees had different lifetimes

Patient contracts could end and need replacing while a caregiver remained employed for much longer. Customer acquisition, staff recruitment and staff retention therefore needed separate monthly schedules.

03

The next block of capacity arrived all at once

Relief staff, supervisors, drivers and vehicles were triggered at different team sizes. These commitments created visible cost steps rather than a smooth percentage of revenue.

MODEL ARCHITECTURE

From operating activity
to a decision-ready view.

Each layer has one job. Together they keep the commercial story, unit economics and cash consequences on the same timeline.

01

Patient contract pipeline

New contracts, expected duration and contract endings create the monthly active-patient requirement by service type.

02

Assigned care capacity

Caregiver and nurse cohorts move through recruitment, availability and assignment, with relief coverage held separately from billable placements.

03

Service revenue

Fulfilled contracts multiply by the applicable monthly fee, keeping caregiver and nursing services distinct.

04

Frontline contribution

Salary, accommodation, customer acquisition and recurring service costs show the contribution left by each staffed contract.

05

Support and onboarding

Recruitment costs follow hiring cohorts, while managers, relief workers, drivers, vehicles and office resources switch on when their thresholds are reached.

06

P&L and cash

Product investment, overhead, hiring payments and operating results roll into break-even and funding scenarios on their actual timing.

WHAT THE ANALYSIS SURFACED

Useful answers,
without exposing client data.

The takeaways are intentionally qualitative. Exact assumptions, calculations and outputs remain inside the confidential client model.

Generalized project pattern

A staffing target was not yet a patient forecast

The model needed to separate people employed, people available, people assigned and patients under contract. Only the matched portion could generate service revenue.

Generalized project pattern

One service tier needed a pricing decision

The supplied assumptions left almost no contribution after frontline pay for one type of care, before housing, relief cover, transport or acquisition. Pricing, staffing mix and service scope therefore became first-order decisions.

Reconstructed insight

Smooth cost ratios would hide the hiring thresholds

A percentage-of-revenue forecast would miss the month when the next vehicle, driver, relief worker or supervisor became necessary. Explicit thresholds made the cash requirement visible.

Reconstructed insight

A sourcing change belonged inside each hiring cohort

When operating conditions changed where staff could be recruited, travel and onboarding costs changed too. Cohort-level switches kept a temporary rule from becoming a permanent average.

MODELING APPROACH

The working system
behind the answer.

  • Monthly patient-contract and customer-acquisition roll-forward
  • Caregiver and nurse hiring, availability and assignment schedules
  • Revenue and frontline contribution by service type
  • Salary, accommodation and recurring employment-cost build
  • Recruitment, uniform, documentation and travel costs by hiring cohort
  • Relief, supervision, driver and vehicle threshold schedules
  • Product investment, overhead, P&L, cash and break-even views
  • Scenarios for hiring timing, pricing, utilization and service mix

CASE CONFIDENTIALITY

This anonymized case explains the home-care operating logic without naming the provider, market, period, prices, salaries or staffing targets. The client workbook, contract inputs, recruitment assumptions and product budget remain private. The illustration is an original fictional care ecosystem rather than a client facility, workforce or model screenshot.

CUSTOM PROJECTS START AT $2,500 USD

Need a financial model?
Or the complete business package?

The final fee reflects the agreed scope, complexity and deliverables. Combined packages are quoted individually.