Free editable workbook
Download the Technician + Vehicle Decision Model in Excel.
Use the illustrative inputs, formulas, checks, and decision prompts as a starting point, then replace them with your own business information.
No signup required. Illustrative model only; review assumptions before using the output for a business decision.
Workbook structure
Start Here → Inputs → Monthly Model → Scenario Summary → What to Consider → Checks. Base, Downside, and Upside assumptions change revenue per billable day, utilization, and direct costs. The 12-month model then calculates monthly contribution and cumulative cash impact.
Direct answer
How do you decide whether you can afford another technician and service vehicle?
Estimate the technician's full employment cost, vehicle and equipment costs, expected billable capacity, direct costs, ramp time, and cash committed before the new capacity reaches a sustainable workload. Then stress-test those assumptions.
Formula-driven outputs
Break-even workload
Calculated billable days and utilization needed to cover recurring technician, vehicle, and supervision costs.
Cash required
Lowest cumulative cash impact before the model pays back.
Payback
Month when modeled cumulative cash impact turns non-negative, or a flag if it does not happen within 12 months.
Downside case
Tests lower utilization / revenue and higher direct costs rather than relying only on the base case.
What to consider
- Is there enough real demand to support the break-even workload?
- How long will recruiting, training, and customer/route ramp take?
- Does the current dispatch and supervision team have capacity?
- What vehicle, insurance, fuel, maintenance, inventory, software, and tool costs are missing?
- Can the business absorb the modeled cash need if collections also slow?
Need the model customized to your business?
I can adapt it to your actual pay structure, pricing, technician economics, vehicle option, service mix, seasonality, collection timing, and current cash position.
Available as a project or as part of ongoing fractional CFO support.