Halnory Home Services
Work orders, dispatch, technician utilization, and truck stock
About Halnory Home Services
Industry
HVAC & Plumbing Field Services
Company size
Fictional regional field-service company with 14 service branches, about 180 field technicians, and roughly 12,000 active customers.
Service catalog
70 service job types across HVAC install, HVAC repair, HVAC maintenance, plumbing repair, drain and sewer, water heater, indoor air quality, and emergency categories, each with an internal service code and a standard price.
Packaged scale
About 381,000 rows across 10 Standard-tier tables, including 180,000 work orders, 25,000 service agreements, 155,000 invoices, a monthly truck-stock snapshot, and a monthly technician utilization snapshot.
Revenue range
The two-year window carries roughly $125M to $150M in total job revenue, which works out to about $63M to $75M in annual job revenue across the branches.
Operating footprint
Five fictional reporting regions covering metro, lakeside, riverlands, and highlands service areas.
Customer mix
A residential-led base with meaningful commercial and property-management segments, served from a primary branch in each customer's region.
Halnory Home Services is a fictional regional HVAC and plumbing field-service company used for synthetic BI analysis. The company story follows a network of neighborhood and flagship service branches, the field technicians who run the trucks, the residential and commercial customers they serve, and the daily flow of work orders, dispatch, service agreements, invoices, and truck stock. Everything here is invented for analytics practice. No real home-services company, branch, technician, customer, or payer is represented.
Operating Profile
- Branches are trade-specialised: HVAC and plumbing branches book and staff only their own trade, while combined branches carry both.
- Only branches with crew enough for an after-hours rota run emergency call-outs, so emergency work sits in the larger branches.
- Dispatch picks a technician based at the job's branch and licensed in the trade it needs, and only a completed job books revenue and hours.
- The catalogue prices each job off its own book time and equipment, and truck stock is carried and burned per truck against branch consumption.
- Response time carries the drive, so a rural route waits far longer than an inner-metro address on the same promised priority.
- Excludes permit records, equipment serial and warranty detail, fleet telematics, payroll, and full financial ledger.
Recent Business Events
- 1One flagship branch is the executive focus: revenue is strong but several technicians run close to fully booked in the cooling peak.
- 2Renewals are the open question on the service-agreement book: contracts that auto-renew hold, and the ones that do not are where the lapses land.
- 3Leadership wants one view connecting work order revenue, dispatch, technician utilization, invoice collection, and truck stock.
These are the operating questions this kit is optimized to answer first.
Work order volume, job revenue, and revenue per work order by branch and segment
Response time, on-time rate, first-visit resolution, and callback rate
Invoice labor and parts amounts, paid versus balance, and collection by method
Agreement counts, plan mix, contract value, and renewal versus lapse by term and auto-renew
Billable hours, utilization percent, and jobs completed by technician
On-hand units and value, consumption, and reorder pressure by branch
Embedded Analytical Stories
Two-peak seasonality
Job revenue climbs through the cooling and heating peaks and eases in the shoulder months.
Every trade has its own season
Heating and cooling failures spike at the temperature extremes while tune-ups fill the quieter spring and autumn shoulders.
Volume versus value
High-ticket install and water heater jobs concentrate revenue while small repair calls drive the most work orders.
Renewal versus lapse
The longer a contract has been running the more chance it has to lapse, and auto-renew is what holds a book together.
Skill moves the numbers
Master technicians clear jobs faster, resolve more first visits, and draw fewer callbacks than apprentices.
Cash-flow contrast
Collection varies by payment method and recency, separating financed installs from routine repair calls.